rdr.EndOfStream shows function evaluation timeout

public void CopyFlatFilePurchaseOrder()

{

//OracleCommand cmdDel = new OracleCommand("Delete from Bcil_PurchaseOrder", cnn);

//cnn.Open();

//cmdDel.ExecuteNonQuery();

////cnn.Close();

string FTP_filename;

string FTP_User;

string FTP_Password;

try

{

OracleCommand cmdFTP = new OracleCommand("Select FTP_Name,FTP_USer,FTP_Password,FTP_PO_FILENAME from Bcil_Configuration_Master", cnn);

if (cnn.State == ConnectionState.Open) cnn.Close();

cnn.Open();

OracleDataReader odr = cmdFTP.ExecuteReader();

if (odr.Read())

{

FTP_filename = odr["FTP_Name"].ToString() + "//" + odr["FTP_PO_FILENAME"].ToString();

FTP_User = odr["FTP_User"].ToString();

FTP_Password = odr["FTP_Password"].ToString();

}

else

{

OracleCommand cmdError = new OracleCommand("Insert into ErrorLog(ErrorDate,ErrorTable,Module,Remarks) values ('" + DateTime.Now.Date.ToString("dd-MMM-yyyy") + "','Bcil_PurchaseOrder','Default.aspx','File not found')", cnn);

if (cnn.State == ConnectionState.Open) cnn.Close();

cnn.Open();

cmdError.ExecuteNonQuery();

cnn.Close();

return;

}

cnn.Close();

}

catch (Exception ex)

{

if (cnn.State == ConnectionState.Open) cnn.Close();

cnn.Open();

cmdError.ExecuteNonQuery();

cnn.Close();

return;

}

FtpWebRequest request = (FtpWebRequest)WebRequest.Create(FTP_filename);

request.Credentials = new NetworkCredential(FTP_User, FTP_Password);

request.UsePassive = true;

request.UseBinary = true;

request.KeepAlive = true;

//request.Method = WebRequestMethods.Ftp.DownloadFile;

// This example assumes the FTP site uses anonymous logon.

FtpWebResponse response = (FtpWebResponse)request.GetResponse();

Stream responseStream = response.GetResponseStream();

StreamReader rdr = new StreamReader(responseStream);

//StreamReader rdr = new StreamReader("D:\\ORDMAST.TXT");

int intCount = 1;

string strConcept = null;// (1 char),

string strType = null; // (1 char),

string strOrderNo = null; // (7 char),

string strDelDateT = null; // (8 char),

string strOrdYrWk = null; // (6 char),

string strDelDate = null; // (8 char),

string strArtNo = null; // (7 char),

string strRdcNo = null; // (5 char),

string strAssoNo = null; // (5 char),

string strAsstCode = null; // (2 char),

int intTotPR; //( 9 digit),

int intPR1; //( 7 digit),

int intPR2; //( 7 digit),

int intPR3; //( 7 digit),

int intPR4; //( 7 digit),

int intPR5; //( 7 digit),

int intPR6; //( 7 digit),

int intPR7; //( 7 digit),

int intPR8; //( 7 digit),

int intPR9; //( 7 digit),

int intPR10; //( 7 digit),

int intPR11; //( 7 digit),

int intPR12; //( 7 digit),

int intPR13; //( 7 digit),

int intPR14 = 0; //( 7 digit),

string strPrntAg = null; //(1 dight),

string strOrderType = null; //(1 dight),

string strCategory = null; //(4 dight),

string strPackMth = null; //(1 dight),

string strNoClmDisk = null; //(6 dight),

string strFob = null; //(6 dight),

string strProforma = null; //(6 dight),

string strDelYrWk = null; // (6 char),

string strOpnYrWk = null; // (6 char),

int intUnitBal; //(7 digit),

int intRDCBal; //(7 digit),

int intMaxQty; //(7 digit),

int intOdrQty; //(3 digit),

string strPacktype; //(1 char),

string str = null;

while (!rdr.EndOfStream)

{

string strRow = rdr.ReadLine();

try

{

strConcept = strRow.Substring(0, 1);

strType = strRow.Substring(1, 1);

strOrderNo = strRow.Substring(2, 7);

strDelDateT = strRow.Substring(9, 8);

strOrdYrWk = strRow.Substring(17, 6);

strDelDate = strRow.Substring(23, 8); // (8 char),

strArtNo = strRow.Substring(31, 7); // (7 char),

strRdcNo = "1" + strRow.Substring(38, 5); // (5 char),

strAssoNo = strRow.Substring(43, 5); // (5 char),

strAsstCode = strRow.Substring(48, 2); // (2 char),

intTotPR = int.Parse(strRow.Substring(50, 9)); //( 9 digit),

intPR1 = int.Parse(strRow.Substring(59, 7)); //( 7 digit),

intPR2 = int.Parse(strRow.Substring(66, 7)); //( 7 digit),

intPR3 = int.Parse(strRow.Substring(73, 7)); //( 7 digit),

intPR4 = int.Parse(strRow.Substring(80, 7)); //( 7 digit),

intPR5 = int.Parse(strRow.Substring(87, 7)); //( 7 digit),

intPR6 = int.Parse(strRow.Substring(94, 7)); //( 7 digit),

intPR7 = int.Parse(strRow.Substring(101, 7)); //( 7 digit),

intPR8 = int.Parse(strRow.Substring(108, 7)); //( 7 digit),

intPR9 = int.Parse(strRow.Substring(115, 7)); //( 7 digit),

intPR10 = int.Parse(strRow.Substring(122, 7)); //( 7 digit),

intPR11 = int.Parse(strRow.Substring(129, 7)); //( 7 digit),

intPR12 = int.Parse(strRow.Substring(136, 7)); //( 7 digit),

intPR13 = int.Parse(strRow.Substring(143, 7)); //( 7 digit),

//intPR14 = int.Parse(strRow.Substring(150, 7)); //( 7 digit),

strPrntAg = strRow.Substring(150, 1); //(1 dight),

strOrderType = strRow.Substring(151, 1); //(1 dight),

strCategory = strRow.Substring(152, 4); //(4 dight),

strPackMth = strRow.Substring(156, 1); //(1 dight),

strNoClmDisk = strRow.Substring(157, 6); //(6 dight),

strFob = null; //(6 dight),

strProforma = null; //(6 dight),

strDelYrWk = strRow.Substring(184, 6); // (6 char),

strOpnYrWk = strRow.Substring(190, 6); // (6 char),

intUnitBal = int.Parse(strRow.Substring(196, 7)); //(7 digit),

intRDCBal = int.Parse(strRow.Substring(203, 7)); //(7 digit),

intMaxQty = int.Parse(strRow.Substring(210, 7)); //(7 digit),

int.TryParse(strRow.Substring(217, 3), out intOdrQty); //(3 digit),;

strPacktype = strRow.Substring(220, 1);

string strPlan = GetPlan(strDelDateT);

int counter = 0;

OracleDataAdapter odp = new OracleDataAdapter("select count(*) from Bcil_PurchaseOrder where ART_CODE='" + strArtNo + "' and PROD_ORDER='" + strOrderNo + "' and DESTINATION='" + strRdcNo + "'", cnn);

DataSet ds = new DataSet();

odp.Fill(ds);

counter = Convert.ToInt32(ds.Tables[0].Rows[0][0].ToString());

//OracleCommand cmdIns = new OracleCommand("select count(*) from Bcil_PurchaseOrder where ART_CODE='" + strArtNo + "' and PROD_ORDER='" + strOrderNo + "' and DESTINATION='" + strRdcNo + "'", cnn);

//cnn.Open();

//counter = cmdIns.ExecuteNonQuery();

if (counter <= 0)

{

OracleCommand cmd = new OracleCommand("Insert into Bcil_PurchaseOrder(REQUEST_TYPE,ART_CODE,PROD_ORDER,PROD_UNIT,DESTINATION,BOX_QTY,ORD_QTY,CONCEPT,SUP_CATEGORY,PACK_TYPE,ART_SIZE1,ART_SIZE2,ART_SIZE3,ART_SIZE4,ART_SIZE5,ART_SIZE6,ART_SIZE7,ART_SIZE8,ART_SIZE9,ART_SIZE10,ART_SIZE11,ART_SIZE12,ART_SIZE13,ART_SIZE14,TOT_QTY,DPLAN_NO,CREATE_BY,CREATE_DT) values ('" + strType + "','" + strArtNo + "','" + strOrderNo + "','" + strAssoNo + "','" + strRdcNo + "'," + intOdrQty + "," + intTotPR + ",'" + strConcept + "','" + strCategory + "','" + strPacktype + "'," + intPR1 + "," + intPR2 + "," + intPR3 + "," + intPR4 + "," + intPR5 + "," + intPR6 + "," + intPR7 + "," + intPR8 + "," + intPR9 + "," + intPR10 + "," + intPR11 + "," + intPR12 + "," + intPR13 + "," + intPR14 + "," + intTotPR + ",'" + strPlan + "','BCIL','" + DateTime.Now.Date.ToString("dd-MMM-yyyy") + "')", cnn);

cnn.Open();

cmd.ExecuteNonQuery();

}

else //if (counter <= 0)

{

OracleCommand cmd = new OracleCommand("update Bcil_PurchaseOrder set REQUEST_TYPE='" + strType + "',PROD_UNIT='" + strAssoNo + "',BOX_QTY=" + intOdrQty + ",ORD_QTY=" + intTotPR + ",CONCEPT='" + strConcept + "',SUP_CATEGORY='" + strCategory + "',PACK_TYPE='" + strPacktype + "',ART_SIZE1=" + intPR1 + ",ART_SIZE2=" + intPR2 + ",ART_SIZE3=" + intPR3 + ",ART_SIZE4=" + intPR4 + ",ART_SIZE5=" + intPR5 + ",ART_SIZE6=" + intPR6 + ",ART_SIZE7=" + intPR7 + ",ART_SIZE8=" + intPR8 + ",ART_SIZE9=" + intPR9 + ",ART_SIZE10=" + intPR10 + ",ART_SIZE11=" + intPR11 + ",ART_SIZE12=" + intPR12 + ",ART_SIZE13=" + intPR13 + ",ART_SIZE14=" + intPR14 + ",TOT_QTY=" + intTotPR + ",DPLAN_NO='" + strPlan + "',CREATE_BY='BCIL',CREATE_DT='" + DateTime.Now.Date.ToString("dd-MMM-yyyy") + "' where ART_CODE='" + strArtNo + "' and PROD_ORDER='" + strOrderNo + "' and DESTINATION='" + strRdcNo + "'", cnn);

cnn.Open();

cmd.ExecuteNonQuery();

}

cnn.Close();

}

catch (Exception ex)

{

if (cnn.State == ConnectionState.Open) cnn.Close();

cnn.Open();

cmdError.ExecuteNonQuery();

cnn.Close();

}

rdr.Close();

rdr.Dispose();

}

8 Replies

Know the answer? Post it — somebody with the same question will find it here.

Jaganathan Bantheswaran13y ago
Hi,

I could try this post. But still it may help you.

Have a look at this post
Ish Bandhu13y ago
I think problem in connection open and close, please check your code you properly opened and closed connection. You debugged your code and check in which line it showing problem.

may be problem is here:

OracleDataAdapter odp = new OracleDataAdapter("select count(*) from Bcil_PurchaseOrder where ART_CODE='" + strArtNo + "' and PROD_ORDER='" + strOrderNo + "' and DESTINATION='" + strRdcNo + "'", cnn);
DataSet ds = new DataSet();
odp.Fill(ds);

here u did not open the connection
Ravi Shekhar13y ago
public void CopyFlatFilePurchaseOrder()
{
//OracleCommand cmdDel = new OracleCommand("Delete from Bcil_PurchaseOrder", cnn);
//cnn.Open();
//cmdDel.ExecuteNonQuery();
////cnn.Close();
string FTP_filename;
string FTP_User;
string FTP_Password;
try
{
OracleCommand cmdFTP = new OracleCommand("Select FTP_Name,FTP_USer,FTP_Password,FTP_PO_FILENAME from Bcil_Configuration_Master", cnn);
if (cnn.State == ConnectionState.Open) cnn.Close();
cnn.Open();
OracleDataReader odr = cmdFTP.ExecuteReader();
if (odr.Read())
{
FTP_filename = odr["FTP_Name"].ToString() + "//" + odr["FTP_PO_FILENAME"].ToString();
FTP_User = odr["FTP_User"].ToString();
FTP_Password = odr["FTP_Password"].ToString();
}
else
{
OracleCommand cmdError = new OracleCommand("Insert into ErrorLog(ErrorDate,ErrorTable,Module,Remarks) values ('" + DateTime.Now.Date.ToString("dd-MMM-yyyy") + "','Bcil_PurchaseOrder','Default.aspx','File not found')", cnn);
if (cnn.State == ConnectionState.Open) cnn.Close();
cnn.Open();
cmdError.ExecuteNonQuery();
cnn.Close();
return;
}

cnn.Close();
}
catch (Exception ex)
{
OracleCommand cmdError = new OracleCommand("Insert into ErrorLog(ErrorDate,ErrorTable,Module,Remarks) values ('" + DateTime.Now.Date.ToString("dd-MMM-yyyy") + "','Bcil_PurchaseOrder','Default.aspx','" + ex.Message + "')", cnn);
if (cnn.State == ConnectionState.Open) cnn.Close();
cnn.Open();
cmdError.ExecuteNonQuery();
cnn.Close();
return;
}

FtpWebRequest request = (FtpWebRequest)WebRequest.Create(FTP_filename);
request.Credentials = new NetworkCredential(FTP_User, FTP_Password);

request.UsePassive = true;
request.UseBinary = true;
request.KeepAlive = true;
//request.Method = WebRequestMethods.Ftp.DownloadFile;

// This example assumes the FTP site uses anonymous logon.

FtpWebResponse response = (FtpWebResponse)request.GetResponse();
Stream responseStream = response.GetResponseStream();
StreamReader rdr = new StreamReader(responseStream);
//StreamReader rdr = new StreamReader("D:\\ORDMAST.TXT");

int intCount = 1;
string strConcept = null;// (1 char),
string strType = null; // (1 char),
string strOrderNo = null; // (7 char),
string strDelDateT = null; // (8 char),
string strOrdYrWk = null; // (6 char),
string strDelDate = null; // (8 char),
string strArtNo = null; // (7 char),
string strRdcNo = null; // (5 char),
string strAssoNo = null; // (5 char),
string strAsstCode = null; // (2 char),
int intTotPR; //( 9 digit),
int intPR1; //( 7 digit),
int intPR2; //( 7 digit),
int intPR3; //( 7 digit),
int intPR4; //( 7 digit),
int intPR5; //( 7 digit),
int intPR6; //( 7 digit),
int intPR7; //( 7 digit),
int intPR8; //( 7 digit),
int intPR9; //( 7 digit),
int intPR10; //( 7 digit),
int intPR11; //( 7 digit),
int intPR12; //( 7 digit),
int intPR13; //( 7 digit),
int intPR14 = 0; //( 7 digit),
string strPrntAg = null; //(1 dight),
string strOrderType = null; //(1 dight),
string strCategory = null; //(4 dight),
string strPackMth = null; //(1 dight),
string strNoClmDisk = null; //(6 dight),

string strFob = null; //(6 dight),
string strProforma = null; //(6 dight),

string strDelYrWk = null; // (6 char),
string strOpnYrWk = null; // (6 char),
int intUnitBal; //(7 digit),
int intRDCBal; //(7 digit),
int intMaxQty; //(7 digit),
int intOdrQty; //(3 digit),
string strPacktype; //(1 char),

string str = null;
while (!rdr.EndOfStream)
{
string strRow = rdr.ReadLine();

try
{
strConcept = strRow.Substring(0, 1);
strType = strRow.Substring(1, 1);
strOrderNo = strRow.Substring(2, 7);
strDelDateT = strRow.Substring(9, 8);
strOrdYrWk = strRow.Substring(17, 6);
strDelDate = strRow.Substring(23, 8); // (8 char),
strArtNo = strRow.Substring(31, 7); // (7 char),
strRdcNo = "1" + strRow.Substring(38, 5); // (5 char),
strAssoNo = strRow.Substring(43, 5); // (5 char),
strAsstCode = strRow.Substring(48, 2); // (2 char),
intTotPR = int.Parse(strRow.Substring(50, 9)); //( 9 digit),
intPR1 = int.Parse(strRow.Substring(59, 7)); //( 7 digit),
intPR2 = int.Parse(strRow.Substring(66, 7)); //( 7 digit),
intPR3 = int.Parse(strRow.Substring(73, 7)); //( 7 digit),
intPR4 = int.Parse(strRow.Substring(80, 7)); //( 7 digit),
intPR5 = int.Parse(strRow.Substring(87, 7)); //( 7 digit),
intPR6 = int.Parse(strRow.Substring(94, 7)); //( 7 digit),
intPR7 = int.Parse(strRow.Substring(101, 7)); //( 7 digit),
intPR8 = int.Parse(strRow.Substring(108, 7)); //( 7 digit),
intPR9 = int.Parse(strRow.Substring(115, 7)); //( 7 digit),
intPR10 = int.Parse(strRow.Substring(122, 7)); //( 7 digit),
intPR11 = int.Parse(strRow.Substring(129, 7)); //( 7 digit),
intPR12 = int.Parse(strRow.Substring(136, 7)); //( 7 digit),
intPR13 = int.Parse(strRow.Substring(143, 7)); //( 7 digit),
//intPR14 = int.Parse(strRow.Substring(150, 7)); //( 7 digit),
strPrntAg = strRow.Substring(150, 1); //(1 dight),
strOrderType = strRow.Substring(151, 1); //(1 dight),
strCategory = strRow.Substring(152, 4); //(4 dight),
strPackMth = strRow.Substring(156, 1); //(1 dight),
strNoClmDisk = strRow.Substring(157, 6); //(6 dight),

strFob = null; //(6 dight),
strProforma = null; //(6 dight),

strDelYrWk = strRow.Substring(184, 6); // (6 char),
strOpnYrWk = strRow.Substring(190, 6); // (6 char),
intUnitBal = int.Parse(strRow.Substring(196, 7)); //(7 digit),
intRDCBal = int.Parse(strRow.Substring(203, 7)); //(7 digit),
intMaxQty = int.Parse(strRow.Substring(210, 7)); //(7 digit),

int.TryParse(strRow.Substring(217, 3), out intOdrQty); //(3 digit),;
strPacktype = strRow.Substring(220, 1);

string strPlan = GetPlan(strDelDateT);

int counter = 0;
OracleDataAdapter odp = new OracleDataAdapter("select count(*) from Bcil_PurchaseOrder where ART_CODE='" + strArtNo + "' and PROD_ORDER='" + strOrderNo + "' and DESTINATION='" + strRdcNo + "'", cnn);
DataSet ds = new DataSet();
odp.Fill(ds);
counter = Convert.ToInt32(ds.Tables[0].Rows[0][0].ToString());

//OracleCommand cmdIns = new OracleCommand("select count(*) from Bcil_PurchaseOrder where ART_CODE='" + strArtNo + "' and PROD_ORDER='" + strOrderNo + "' and DESTINATION='" + strRdcNo + "'", cnn);
//cnn.Open();
//counter = cmdIns.ExecuteNonQuery();

if (counter <= 0)
{
OracleCommand cmd = new OracleCommand("Insert into Bcil_PurchaseOrder(REQUEST_TYPE,ART_CODE,PROD_ORDER,PROD_UNIT,DESTINATION,BOX_QTY,ORD_QTY,CONCEPT,SUP_CATEGORY,PACK_TYPE,ART_SIZE1,ART_SIZE2,ART_SIZE3,ART_SIZE4,ART_SIZE5,ART_SIZE6,ART_SIZE7,ART_SIZE8,ART_SIZE9,ART_SIZE10,ART_SIZE11,ART_SIZE12,ART_SIZE13,ART_SIZE14,TOT_QTY,DPLAN_NO,CREATE_BY,CREATE_DT) values ('" + strType + "','" + strArtNo + "','" + strOrderNo + "','" + strAssoNo + "','" + strRdcNo + "'," + intOdrQty + "," + intTotPR + ",'" + strConcept + "','" + strCategory + "','" + strPacktype + "'," + intPR1 + "," + intPR2 + "," + intPR3 + "," + intPR4 + "," + intPR5 + "," + intPR6 + "," + intPR7 + "," + intPR8 + "," + intPR9 + "," + intPR10 + "," + intPR11 + "," + intPR12 + "," + intPR13 + "," + intPR14 + "," + intTotPR + ",'" + strPlan + "','BCIL','" + DateTime.Now.Date.ToString("dd-MMM-yyyy") + "')", cnn);
cnn.Open();
cmd.ExecuteNonQuery();
}
else //if (counter <= 0)
{
OracleCommand cmd = new OracleCommand("update Bcil_PurchaseOrder set REQUEST_TYPE='" + strType + "',PROD_UNIT='" + strAssoNo + "',BOX_QTY=" + intOdrQty + ",ORD_QTY=" + intTotPR + ",CONCEPT='" + strConcept + "',SUP_CATEGORY='" + strCategory + "',PACK_TYPE='" + strPacktype + "',ART_SIZE1=" + intPR1 + ",ART_SIZE2=" + intPR2 + ",ART_SIZE3=" + intPR3 + ",ART_SIZE4=" + intPR4 + ",ART_SIZE5=" + intPR5 + ",ART_SIZE6=" + intPR6 + ",ART_SIZE7=" + intPR7 + ",ART_SIZE8=" + intPR8 + ",ART_SIZE9=" + intPR9 + ",ART_SIZE10=" + intPR10 + ",ART_SIZE11=" + intPR11 + ",ART_SIZE12=" + intPR12 + ",ART_SIZE13=" + intPR13 + ",ART_SIZE14=" + intPR14 + ",TOT_QTY=" + intTotPR + ",DPLAN_NO='" + strPlan + "',CREATE_BY='BCIL',CREATE_DT='" + DateTime.Now.Date.ToString("dd-MMM-yyyy") + "' where ART_CODE='" + strArtNo + "' and PROD_ORDER='" + strOrderNo + "' and DESTINATION='" + strRdcNo + "'", cnn);
cnn.Open();
cmd.ExecuteNonQuery();
}

cnn.Close();

}
catch (Exception ex)
{
OracleCommand cmdError = new OracleCommand("Insert into ErrorLog(ErrorDate,ErrorTable,Module,Remarks) values ('" + DateTime.Now.Date.ToString("dd-MMM-yyyy") + "','Bcil_PurchaseOrder','Default.aspx','" + ex.Message + "')", cnn);
if (cnn.State == ConnectionState.Open) cnn.Close();
cnn.Open();
cmdError.ExecuteNonQuery();
cnn.Close();
}
}
rdr.Close();
rdr.Dispose();
}
Ish Bandhu13y ago
can u post the code of reading file
Ravi Shekhar13y ago
I have set

but still getting timeout.
Ravi Shekhar13y ago
Thank you ish!!! :)
Jaganathan Bantheswaran13y ago
Can you post the code ?
Ish Bandhu13y ago
Set that in web.config: