public Boolean ApprovePR(purchasereturnheader prh)
{
Boolean status = true;
string utString = "";
try
{
string updateSQL = "update PurchaseReturnHeader set DocumentStatus=99, status=1 " +
", ApproveUser='******'" +
", commentStatus='" + prh.CommentStatus + "'" +
", PurchaseReturnNo=" + prh.MRNNo +
", PurchaseReturnDate=convert(date, getdate())" +
" where DocumentID='" + prh.DocumentID + "'" +
" and TemporaryNo=" + prh.TemporaryNo +
" and TemporaryDate='" + prh.TemporaryDate.ToString("yyyy-MM-dd") + "'";
utString = utString + updateSQL + Main.QueryDelimiter;
utString = utString +
ActivityLogDB.PrepareActivityLogQquerString("update", "PurchaseReturnHeader", "", updateSQL) +
Main.QueryDelimiter;
if (!UpdateTable.UT(utString))
{
status = false;
}
}
catch (Exception)
{
status = false;
}
return status;
}
public Boolean reversePR(purchasereturnheader prh)
{
Boolean status = true;
string utString = "";
try
{
string updateSQL = "update PurchaseReturnHeader set DocumentStatus=" + prh.DocumentStatus +
", forwardUser='******'" +
", commentStatus='" + prh.CommentStatus + "'" +
", ForwarderList='" + prh.ForwarderList + "'" +
" where DocumentID='" + prh.DocumentID + "'" +
" and TemporaryNo=" + prh.TemporaryNo +
" and TemporaryDate='" + prh.TemporaryDate.ToString("yyyy-MM-dd") + "'";
utString = utString + updateSQL + Main.QueryDelimiter;
utString = utString +
ActivityLogDB.PrepareActivityLogQquerString("update", "PurchaseReturnHeader", "", updateSQL) +
Main.QueryDelimiter;
if (!UpdateTable.UT(utString))
{
status = false;
}
}
catch (Exception)
{
status = false;
}
return(status);
}
public Boolean deletePRHeader(purchasereturnheader prh)
{
Boolean status = true;
string utString = "";
try
{
string updateSQL = "delete PurchaseReturnHeader where DocumentID='" + prh.DocumentID + "'" +
" and TemporaryNo=" + prh.TemporaryNo +
" and TemporaryDate='" + prh.TemporaryDate.ToString("yyyy-MM-dd") + "'";
utString = utString + updateSQL + Main.QueryDelimiter;
utString = utString +
ActivityLogDB.PrepareActivityLogQquerString("delete", "PurchaseReturnHeader", "", updateSQL) +
Main.QueryDelimiter;
if (!UpdateTable.UT(utString))
{
status = false;
}
}
catch (Exception)
{
status = false;
}
return(status);
}
public Boolean updatePRHeader(purchasereturnheader prh)
{
Boolean status = true;
string utString = "";
try
{
string updateSQL = "update PurchaseReturnHeader set CustomerID='" + prh.CustomerID +
"',MRNNo='" + prh.MRNNo +
"',MRNDate='" + prh.MRNDate.ToString("yyyy-MM-dd") +
"', ProductValue='" + prh.ProductValue +
"', TaxAmount='" + prh.TaxAmount +
"', PurchaseReturnValue='" + prh.PRValue +
"', Remarks='" + prh.Remarks +
"', Comments='" + prh.Comments +
"', CommentStatus='" + prh.CommentStatus +
"', ForwarderList='" + prh.ForwarderList + "'" +
" where DocumentID='" + prh.DocumentID + "'" +
" and TemporaryNo=" + prh.TemporaryNo +
" and TemporaryDate='" + prh.TemporaryDate.ToString("yyyy-MM-dd") + "'";
utString = utString + updateSQL + Main.QueryDelimiter;
utString = utString +
ActivityLogDB.PrepareActivityLogQquerString("update", "PurchaseReturnHeader", "", updateSQL) +
Main.QueryDelimiter;
if (!UpdateTable.UT(utString))
{
status = false;
}
}
catch (Exception)
{
status = false;
}
return status;
}
public static List <purchasereturndetail> getPRDetail(purchasereturnheader prh)
{
purchasereturndetail prd;
List <purchasereturndetail> PRDetail = new List <purchasereturndetail>();
try
{
string query = "";
SqlConnection conn = new SqlConnection(Login.connString);
query = "select RowID,DocumentID,DocumentName,TemporaryNo, TemporaryDate,StockItemID,StockItemName,ModelNo,ModelName,Quantity, " +
"Price,Tax,TaxDetails," +
"BatchNo,SerialNo,ExpiryDate,StoreLocationID,StoreLocationName,StockReferenceNo,TaxCode " +
"from ViewPurchaseReturnDetail " +
"where DocumentID='" + prh.DocumentID + "'" +
" and TemporaryNo=" + prh.TemporaryNo +
" and TemporaryDate='" + prh.TemporaryDate.ToString("yyyy-MM-dd") + "'" +
" order by StockItemID";
SqlCommand cmd = new SqlCommand(query, conn);
conn.Open();
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
prd = new purchasereturndetail();
prd.RowID = reader.GetInt32(0);
prd.DocumentID = reader.GetString(1);
prd.DocumentName = reader.GetString(2);
prd.TemporaryNo = reader.GetInt32(3);
prd.TemporaryDate = reader.GetDateTime(4).Date;
prd.StockItemID = reader.GetString(5);
prd.StockItemName = reader.GetString(6);
prd.ModelNo = reader.IsDBNull(7)?"NA":reader.GetString(7);
prd.ModelName = reader.IsDBNull(8) ? "NA" : reader.GetString(8);
prd.Quantity = reader.GetDouble(9);
prd.Price = reader.GetDouble(10);
prd.Tax = reader.GetDouble(11);
prd.TaxDetails = reader.GetString(12);
prd.BatchNo = reader.GetString(13);
prd.SerialNo = reader.GetString(14);
prd.ExpiryDate = reader.GetDateTime(15);
prd.StoreLocationID = reader.IsDBNull(16) ? "" : reader.GetString(16);
prd.StoreLocationName = reader.IsDBNull(17) ? "" : reader.GetString(17);
prd.StockReferenceNo = reader.GetInt32(18);
prd.TaxCode = reader.IsDBNull(19)?"":reader.GetString(19);
PRDetail.Add(prd);
}
conn.Close();
}
catch (Exception ex)
{
MessageBox.Show("Error querying Purchase return Details");
}
return(PRDetail);
}
public Boolean updatePRDetail(List <purchasereturndetail> PRDetails, purchasereturnheader prh)
{
Boolean status = true;
string utString = "";
try
{
string updateSQL = "Delete from PurchaseReturnDetail where DocumentID='" + prh.DocumentID + "'" +
" and TemporaryNo=" + prh.TemporaryNo +
" and TemporaryDate='" + prh.TemporaryDate.ToString("yyyy-MM-dd") + "'";
utString = utString + updateSQL + Main.QueryDelimiter;
utString = utString +
ActivityLogDB.PrepareActivityLogQquerString("delete", "PurchaseReturnDetail", "", updateSQL) +
Main.QueryDelimiter;
foreach (purchasereturndetail prd in PRDetails)
{
updateSQL = "insert into PurchaseReturnDetail " +
"(DocumentID,TemporaryNo,TemporaryDate,StockItemID,ModelNo,TaxCode,Quantity,Price,Tax,TaxDetails,BatchNo,SerialNo,ExpiryDate,StoreLocationID,StockReferenceNo) " +
"values ('" + prh.DocumentID + "'," +
prh.TemporaryNo + "," +
"'" + prh.TemporaryDate.ToString("yyyy-MM-dd") + "'," +
"'" + prd.StockItemID + "'," +
"'" + prd.ModelNo + "'," +
"'" + prd.TaxCode + "'," +
prd.Quantity + "," +
prd.Price + "," +
prd.Tax + "," +
"'" + prd.TaxDetails + "'," +
"'" + prd.BatchNo + "'," +
"'" + prd.SerialNo + "'," +
"'" + prd.ExpiryDate.ToString("yyyy-MM-dd") + "'," +
"'" + prd.StoreLocationID + "',"
+ prd.StockReferenceNo + ")";
utString = utString + updateSQL + Main.QueryDelimiter;
utString = utString +
ActivityLogDB.PrepareActivityLogQquerString("insert", "PurchaseReturnDetail", "", updateSQL) +
Main.QueryDelimiter;
}
if (!UpdateTable.UT(utString))
{
status = false;
}
}
catch (Exception ex)
{
status = false;
}
return(status);
}
public Boolean insertPRHeader(purchasereturnheader prh)
{
Boolean status = true;
string utString = "";
try
{
string updateSQL = "insert into PurchaseReturnHeader " +
"(DocumentID,TemporaryNo,TemporaryDate,PurchaseReturnNo,PurchaseReturnDate,MRNNO,MRNDate," +
"CustomerID,ProductValue,TaxAmount,PurchaseReturnValue,Remarks," +
"Comments,CommentStatus,CreateUser,CreateTime,ForwarderList,DocumentStatus,Status)" +
" values (" +
"'" + prh.DocumentID + "'," +
prh.TemporaryNo + "," +
"'" + prh.TemporaryDate.ToString("yyyy-MM-dd") + "'," +
prh.PRNo + "," +
"'" + prh.PRDate.ToString("yyyy-MM-dd") + "'," +
prh.MRNNo + "," +
"'" + prh.MRNDate.ToString("yyyy-MM-dd") + "'," +
"'" + prh.CustomerID + "'," +
prh.ProductValue + "," +
prh.TaxAmount + "," +
prh.PRValue + "," +
"'" + prh.Remarks + "'," +
"'" + prh.Comments + "'," +
"'" + prh.CommentStatus + "'," +
"'" + Login.userLoggedIn + "'," +
"GETDATE()" + "," +
"'" + prh.ForwarderList + "'," +
prh.DocumentStatus + "," +
prh.status + ")";
utString = utString + updateSQL + Main.QueryDelimiter;
utString = utString +
ActivityLogDB.PrepareActivityLogQquerString("insert", "PurchaseReturnHeader", "", updateSQL) +
Main.QueryDelimiter;
if (!UpdateTable.UT(utString))
{
status = false;
}
}
catch (Exception)
{
status = false;
}
return(status);
}
public Boolean validatePRHeader(purchasereturnheader prh)
{
Boolean status = true;
try
{
if (prh.DocumentID.Trim().Length == 0 || prh.DocumentID == null)
{
return(false);
}
if (prh.CustomerID == null || prh.CustomerID.Trim().Length == 0)
{
return(false);
}
if (prh.MRNNo == 0)
{
return(false);
}
if (prh.MRNDate == null)
{
return(false);
}
if (prh.ProductValue == 0)
{
return(false);
}
if (prh.PRValue == 0)
{
return(false);
}
if (prh.Remarks == null || prh.Remarks.Trim().Length == 0)
{
return(false);
}
}
catch (Exception ex)
{
return(false);
}
return(status);
}
public Boolean InsertPRHeaderAndDetail(purchasereturnheader prh, List <purchasereturndetail> PRDetails)
{
Boolean status = true;
string utString = "";
string updateSQL = "";
try
{
prh.TemporaryNo = DocumentNumberDB.getNumber(prh.DocumentID, 1);
if (prh.TemporaryNo <= 0)
{
MessageBox.Show("Error in Creating New Number");
return(false);
}
updateSQL = "update DocumentNumber set TempNo =" + prh.TemporaryNo +
" where FYID='" + Main.currentFY + "' and DocumentID='" + prh.DocumentID + "'";
utString = utString + updateSQL + Main.QueryDelimiter;
utString = utString +
ActivityLogDB.PrepareActivityLogQquerString("update", "DocumentNumber", "", updateSQL) +
Main.QueryDelimiter;
updateSQL = "insert into PurchaseReturnHeader " +
"(DocumentID,TemporaryNo,TemporaryDate,PurchaseReturnNo,PurchaseReturnDate,MRNNO,MRNDate," +
"CustomerID,ProductValue,TaxAmount,PurchaseReturnValue,Remarks," +
"Comments,CommentStatus,CreateUser,CreateTime,ForwarderList,DocumentStatus,Status)" +
" values (" +
"'" + prh.DocumentID + "'," +
prh.TemporaryNo + "," +
"'" + prh.TemporaryDate.ToString("yyyy-MM-dd") + "'," +
prh.PRNo + "," +
"'" + prh.PRDate.ToString("yyyy-MM-dd") + "'," +
prh.MRNNo + "," +
"'" + prh.MRNDate.ToString("yyyy-MM-dd") + "'," +
"'" + prh.CustomerID + "'," +
prh.ProductValue + "," +
prh.TaxAmount + "," +
prh.PRValue + "," +
"'" + prh.Remarks + "'," +
"'" + prh.Comments + "'," +
"'" + prh.CommentStatus + "'," +
"'" + Login.userLoggedIn + "'," +
"GETDATE()" + "," +
"'" + prh.ForwarderList + "'," +
prh.DocumentStatus + "," +
prh.status + ")";
utString = utString + updateSQL + Main.QueryDelimiter;
utString = utString +
ActivityLogDB.PrepareActivityLogQquerString("insert", "PurchaseReturnHeader", "", updateSQL) +
Main.QueryDelimiter;
updateSQL = "Delete from PurchaseReturnDetail where DocumentID='" + prh.DocumentID + "'" +
" and TemporaryNo=" + prh.TemporaryNo +
" and TemporaryDate='" + prh.TemporaryDate.ToString("yyyy-MM-dd") + "'";
utString = utString + updateSQL + Main.QueryDelimiter;
utString = utString +
ActivityLogDB.PrepareActivityLogQquerString("delete", "PurchaseReturnDetail", "", updateSQL) +
Main.QueryDelimiter;
foreach (purchasereturndetail prd in PRDetails)
{
updateSQL = "insert into PurchaseReturnDetail " +
"(DocumentID,TemporaryNo,TemporaryDate,StockItemID,ModelNo,TaxCode,Quantity,Price,Tax,TaxDetails,BatchNo,SerialNo,ExpiryDate,StoreLocationID,StockReferenceNo) " +
"values ('" + prh.DocumentID + "'," +
prh.TemporaryNo + "," +
"'" + prh.TemporaryDate.ToString("yyyy-MM-dd") + "'," +
"'" + prd.StockItemID + "'," +
"'" + prd.ModelNo + "'," +
"'" + prd.TaxCode + "'," +
prd.Quantity + "," +
prd.Price + "," +
prd.Tax + "," +
"'" + prd.TaxDetails + "'," +
"'" + prd.BatchNo + "'," +
"'" + prd.SerialNo + "'," +
"'" + prd.ExpiryDate.ToString("yyyy-MM-dd") + "'," +
"'" + prd.StoreLocationID + "',"
+ prd.StockReferenceNo + ")";
utString = utString + updateSQL + Main.QueryDelimiter;
utString = utString +
ActivityLogDB.PrepareActivityLogQquerString("insert", "PurchaseReturnDetail", "", updateSQL) +
Main.QueryDelimiter;
}
if (!UpdateTable.UT(utString))
{
status = false;
}
}
catch (Exception ex)
{
status = false;
MessageBox.Show("Transaction Exception Occured");
}
return(status);
}
public Boolean updatePRHeaderAndDetail(purchasereturnheader prh, purchasereturnheader prevprh, List <purchasereturndetail> PRDetails)
{
Boolean status = true;
string utString = "";
try
{
string updateSQL = "update PurchaseReturnHeader set CustomerID='" + prh.CustomerID +
"',MRNNo='" + prh.MRNNo +
"',MRNDate='" + prh.MRNDate.ToString("yyyy-MM-dd") +
"', ProductValue='" + prh.ProductValue +
"', TaxAmount='" + prh.TaxAmount +
"', PurchaseReturnValue='" + prh.PRValue +
"', Remarks='" + prh.Remarks +
"', Comments='" + prh.Comments +
"', CommentStatus='" + prh.CommentStatus +
"', ForwarderList='" + prh.ForwarderList + "'" +
" where DocumentID='" + prevprh.DocumentID + "'" +
" and TemporaryNo=" + prevprh.TemporaryNo +
" and TemporaryDate='" + prevprh.TemporaryDate.ToString("yyyy-MM-dd") + "'";
utString = utString + updateSQL + Main.QueryDelimiter;
utString = utString +
ActivityLogDB.PrepareActivityLogQquerString("update", "PurchaseReturnHeader", "", updateSQL) +
Main.QueryDelimiter;
updateSQL = "Delete from PurchaseReturnDetail where DocumentID='" + prevprh.DocumentID + "'" +
" and TemporaryNo=" + prevprh.TemporaryNo +
" and TemporaryDate='" + prevprh.TemporaryDate.ToString("yyyy-MM-dd") + "'";
utString = utString + updateSQL + Main.QueryDelimiter;
utString = utString +
ActivityLogDB.PrepareActivityLogQquerString("delete", "PurchaseReturnDetail", "", updateSQL) +
Main.QueryDelimiter;
foreach (purchasereturndetail prd in PRDetails)
{
updateSQL = "insert into PurchaseReturnDetail " +
"(DocumentID,TemporaryNo,TemporaryDate,StockItemID,ModelNo,TaxCode,Quantity,Price,Tax,TaxDetails,BatchNo,SerialNo,ExpiryDate,StoreLocationID,StockReferenceNo) " +
"values ('" + prh.DocumentID + "'," +
prh.TemporaryNo + "," +
"'" + prh.TemporaryDate.ToString("yyyy-MM-dd") + "'," +
"'" + prd.StockItemID + "'," +
"'" + prd.ModelNo + "'," +
"'" + prd.TaxCode + "'," +
prd.Quantity + "," +
prd.Price + "," +
prd.Tax + "," +
"'" + prd.TaxDetails + "'," +
"'" + prd.BatchNo + "'," +
"'" + prd.SerialNo + "'," +
"'" + prd.ExpiryDate.ToString("yyyy-MM-dd") + "'," +
"'" + prd.StoreLocationID + "',"
+ prd.StockReferenceNo + ")";
utString = utString + updateSQL + Main.QueryDelimiter;
utString = utString +
ActivityLogDB.PrepareActivityLogQquerString("insert", "PurchaseReturnDetail", "", updateSQL) +
Main.QueryDelimiter;
}
if (!UpdateTable.UT(utString))
{
status = false;
MessageBox.Show("Transaction Exception Occured");
}
}
catch (Exception ex)
{
status = false;
}
return(status);
}
public Boolean ApprovePR(purchasereturnheader prh, List <purchasereturndetail> PRDetails)
{
Boolean status = true;
string utString = "";
try
{
string updateSQL = "";
updateSQL = "update PurchaseReturnHeader set DocumentStatus=99, status=1 " +
", ApproveUser='******'" +
", commentStatus='" + prh.CommentStatus + "'" +
", PurchaseReturnNo=" + prh.MRNNo +
", PurchaseReturnDate=convert(date, getdate())" +
" where DocumentID='" + prh.DocumentID + "'" +
" and TemporaryNo=" + prh.TemporaryNo +
" and TemporaryDate='" + prh.TemporaryDate.ToString("yyyy-MM-dd") + "'";
utString = utString + updateSQL + Main.QueryDelimiter;
utString = utString +
ActivityLogDB.PrepareActivityLogQquerString("update", "PurchaseReturnHeader", "", updateSQL) +
Main.QueryDelimiter;
if (prh.DocumentID == "PURCHASERETURNQA")
{
foreach (purchasereturndetail prd in PRDetails)
{
double Quant = prd.Quantity;
int refNo = prd.StockReferenceNo;
updateSQL = "update Stock set " +
" PresentStock=" + "( (select PresentStock from Stock where RowID = " + refNo + ")-" + Quant + ")" +
", PurchaseReturnQuantity=" + "( (select PurchaseReturnQuantity from Stock where RowID = " + refNo + ")+" + Quant + ")" +
" where RowID=" + refNo;
utString = utString + updateSQL + Main.QueryDelimiter;
utString = utString +
ActivityLogDB.PrepareActivityLogQquerString("update", "Stock", "", updateSQL) +
Main.QueryDelimiter;
}
}
else
{
foreach (purchasereturndetail prd in PRDetails)
{
double Quant = prd.Quantity;
int refNo = prd.StockReferenceNo;
updateSQL = "update MRNDetail set " +
" QuantityReturned=" + "( (select QuantityReturned from MRNDetail where RowID = " + refNo + ")+" + Quant + ")" +
" where RowID=" + refNo;
utString = utString + updateSQL + Main.QueryDelimiter;
utString = utString +
ActivityLogDB.PrepareActivityLogQquerString("update", "MRNDetail", "", updateSQL) +
Main.QueryDelimiter;
}
}
if (!UpdateTable.UT(utString))
{
status = false;
}
}
catch (Exception)
{
status = false;
}
return(status);
}
public List <purchasereturnheader> getFilteredPRHeader(string userList, int opt, string userCommentStatusString)
{
purchasereturnheader prh;
List <purchasereturnheader> PRHeaders = new List <purchasereturnheader>();
try
{
//approved user comment status string
string acStr = "";
try
{
acStr = userCommentStatusString.Substring(0, userCommentStatusString.Length - 2) + "1" + Main.delimiter2;
}
catch (Exception ex)
{
acStr = "";
}
//-----
string query1 = "select RowID, DocumentID, DocumentName,TemporaryNo,TemporaryDate,PurchaseReturnNo,PurchaseReturnDate," +
" MRNNo,MRNDate,CustomerID,CustomerName,ProductValue,TaxAmount,PurchaseReturnValue," +
" Remarks , CommentStatus,CreateUser,ForwardUser,ApproveUser,CreatorName,CreateTime,ForwarderName,ApproverName," +
"ForwarderList,status,DocumentStatus " +
" from ViewPurchaseReturnHeader" +
" where ((ForwardUser='******' and DocumentStatus between 2 and 98) " +
" or (CreateUser='******' and DocumentStatus=1)" +
" or (CommentStatus like '%" + userCommentStatusString + "%' and DocumentStatus between 1 and 98)) order by PurchaseReturnDate desc,DocumentID asc,PurchaseReturnNo desc";
string query2 = "select RowID, DocumentID, DocumentName,TemporaryNo,TemporaryDate,PurchaseReturnNo,PurchaseReturnDate," +
" MRNNo,MRNDate,CustomerID,CustomerName,ProductValue,TaxAmount,PurchaseReturnValue," +
" Remarks , CommentStatus,CreateUser,ForwardUser,ApproveUser,CreatorName,CreateTime,ForwarderName,ApproverName," +
"ForwarderList,status,DocumentStatus " +
" from ViewPurchaseReturnHeader" +
" where ((createuser='******' and DocumentStatus between 2 and 98 ) " +
" or (ForwarderList like '%" + userList + "%' and DocumentStatus between 2 and 98 and ForwardUser <> '" + Login.userLoggedIn + "')" +
" or (commentStatus like '%" + acStr + "%' and DocumentStatus between 1 and 98)) order by TemporaryDate desc,DocumentID asc,TemporaryNo desc";
string query3 = "select RowID, DocumentID, DocumentName,TemporaryNo,TemporaryDate,PurchaseReturnNo,PurchaseReturnDate," +
" MRNNo,MRNDate,CustomerID,CustomerName,ProductValue,TaxAmount,PurchaseReturnValue," +
" Remarks , CommentStatus,CreateUser,ForwardUser,ApproveUser,CreatorName,CreateTime,ForwarderName,ApproverName," +
"ForwarderList,status,DocumentStatus " +
" from ViewPurchaseReturnHeader" +
" where ((createuser='******'" +
" or ForwarderList like '%" + userList + "%'" +
" or commentStatus like '%" + acStr + "%'" +
" or approveUser='******')" +
" and DocumentStatus = 99) order by PurchaseReturnDate desc,DocumentID asc,PurchaseReturnNo desc";
string query6 = "select RowID, DocumentID, DocumentName,TemporaryNo,TemporaryDate,PurchaseReturnNo,PurchaseReturnDate," +
" MRNNo,MRNDate,CustomerID,CustomerName,ProductValue,TaxAmount,PurchaseReturnValue," +
" Remarks , CommentStatus,CreateUser,ForwardUser,ApproveUser,CreatorName,CreateTime,ForwarderName,ApproverName," +
"ForwarderList,status,DocumentStatus " +
" from ViewPurchaseReturnHeader" +
" where DocumentStatus = 99 order by PurchaseReturnDate desc,DocumentID asc,PurchaseReturnNo desc";
SqlConnection conn = new SqlConnection(Login.connString);
string query = "";
switch (opt)
{
case 1:
query = query1;
break;
case 2:
query = query2;
break;
case 3:
query = query3;
break;
case 6:
query = query6;
break;
default:
query = "";
break;
}
SqlCommand cmd = new SqlCommand(query, conn);
conn.Open();
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
try
{
prh = new purchasereturnheader();
prh.RowID = reader.GetInt32(0);
prh.DocumentID = reader.GetString(1);
prh.DocumentName = reader.GetString(2);
prh.TemporaryNo = reader.GetInt32(3);
prh.TemporaryDate = reader.GetDateTime(4);
prh.PRNo = reader.GetInt32(5);
prh.PRDate = reader.GetDateTime(6);
prh.MRNNo = reader.GetInt32(7);
prh.MRNDate = reader.GetDateTime(8);
prh.CustomerID = reader.GetString(9);
prh.CustomerName = reader.GetString(10);
prh.ProductValue = reader.GetDouble(11);
prh.TaxAmount = reader.GetDouble(12);
prh.PRValue = reader.GetDouble(13);
prh.Remarks = reader.GetString(14);
if (!reader.IsDBNull(15))
{
prh.CommentStatus = reader.GetString(15);
}
else
{
prh.CommentStatus = "";
}
prh.CreateUser = reader.GetString(16);
prh.ForwardUser = reader.GetString(17);
prh.ApproveUser = reader.GetString(18);
prh.CreatorName = reader.GetString(19);
prh.CreateTime = reader.GetDateTime(20);
prh.ForwarderName = reader.GetString(21);
prh.ApproverName = reader.GetString(22);
if (!reader.IsDBNull(23))
{
prh.ForwarderList = reader.GetString(23);
}
else
{
prh.ForwarderList = "";
}
prh.status = reader.GetInt32(24);
prh.DocumentStatus = reader.GetInt32(25);
PRHeaders.Add(prh);
}
catch (Exception ex)
{
}
}
conn.Close();
}
catch (Exception ex)
{
MessageBox.Show("Error querying Purchase return Header Details");
}
return(PRHeaders);
}