public Boolean ApproveIndentGeneral(indentgeneralheader igh) { Boolean status = true; string utString = ""; try { string updateSQL = "update IndentGeneralHeader set DocumentStatus=99, status=1 " + ", ApproveUser='******'" + ", commentStatus='" + igh.CommentStatus + "'" + ", DocumentNo=" + igh.DocumentNo + ", DocumentDate=convert(date, getdate())" + " where DocumentID='" + igh.DocumentID + "'" + " and TemporaryNo=" + igh.TemporaryNo + " and TemporaryDate='" + igh.TemporaryDate.ToString("yyyy-MM-dd") + "'"; utString = utString + updateSQL + Main.QueryDelimiter; utString = utString + ActivityLogDB.PrepareActivityLogQquerString("update", "IndentGeneralHeader", "", updateSQL) + Main.QueryDelimiter; if (!UpdateTable.UT(utString)) { status = false; } } catch (Exception) { status = false; } return(status); }
public Boolean reverseIndentGeneral(indentgeneralheader igh) { Boolean status = true; string utString = ""; try { string updateSQL = "update IndentGeneralHeader set DocumentStatus=" + igh.DocumentStatus + ", forwardUser='******'" + ", commentStatus='" + igh.CommentStatus + "'" + ", ForwarderList='" + igh.ForwarderList + "'" + " where DocumentID='" + igh.DocumentID + "'" + " and TemporaryNo=" + igh.TemporaryNo + " and TemporaryDate='" + igh.TemporaryDate.ToString("yyyy-MM-dd") + "'"; utString = utString + updateSQL + Main.QueryDelimiter; utString = utString + ActivityLogDB.PrepareActivityLogQquerString("update", "IndentGeneralHeader", "", updateSQL) + Main.QueryDelimiter; if (!UpdateTable.UT(utString)) { status = false; } } catch (Exception) { status = false; } return(status); }
public Boolean validateIndentGeneralHeader(indentgeneralheader igh) { Boolean status = true; try { if (igh.DocumentID.Trim().Length == 0 || igh.DocumentID == null) { return(false); } //if (igh.PurchaseSource == null || igh.PurchaseSource.Trim().Length == 0 ) //{ // return false; //} if (igh.CurrencyID.Trim().Length == 0 || igh.CurrencyID == null) { return(false); } if (igh.ReferenceNo == null || igh.ReferenceNo.Trim().Length == 0) { return(false); } if (igh.TargetDate == null || igh.TargetDate < DateTime.Now.Date) { return(false); } if (igh.ExchangeRate == 0) { return(false); } if (igh.ProductValue == 0) { return(false); } if (igh.ProductValueINR == 0) { return(false); } } catch (Exception ex) { return(false); } return(status); }
public static List <indentgeneraldetail> getIndentGeneralDetails(indentgeneralheader igh) { indentgeneraldetail igd; List <indentgeneraldetail> IGDetail = new List <indentgeneraldetail>(); try { string query = ""; SqlConnection conn = new SqlConnection(Login.connString); query = "select RowID,DocumentID,TemporaryNo, TemporaryDate,ItemDetail," + "Quantity,ExpectedPurchasePrice,WarrantyDays " + "from IndentGeneralDetail" + " where DocumentID='" + igh.DocumentID + "'" + " and TemporaryNo=" + igh.TemporaryNo + " and TemporaryDate='" + igh.TemporaryDate.ToString("yyyy-MM-dd") + "'"; SqlCommand cmd = new SqlCommand(query, conn); conn.Open(); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { igd = new indentgeneraldetail(); igd.RowID = reader.GetInt32(0); igd.DocumentID = reader.GetString(1); igd.TemporaryNo = reader.GetInt32(2); igd.TemporaryDate = reader.GetDateTime(3).Date; igd.ItemDetail = reader.IsDBNull(4) ? "" : reader.GetString(4); igd.Quantity = reader.GetDouble(5); igd.ExpectedPurchasePrice = reader.GetDouble(6); igd.WarrantyDays = reader.GetInt32(7); IGDetail.Add(igd); } conn.Close(); } catch (Exception) { MessageBox.Show("Error querying Inidentgeneral Details"); } return(IGDetail); }
////new public static List <poheader> getPurchaseOrderHeader(indentgeneralheader poh) { poheader pod; List <poheader> PODetail = new List <poheader>(); try { string query = ""; string refindent = poh.DocumentID + "(" + poh.DocumentNo + "" + Main.delimiter1 + "" + poh.DocumentDate.ToString("yyyy-MM-dd") + ");"; SqlConnection conn = new SqlConnection(Login.connString); query = "select DocumentID,DocumentName,TemporaryNo,TemporaryDate,PONo,PODate, " + "ReferenceIndent,ReferenceQuotation,CustomerID, " + "CustomerName,CurrencyID,DeliveryPeriod,ValidityPeriod, " + "TaxTerms,ModeOfPayment,PaymentTerms,TransportationMode, " + " FreightTerms,FreightCharge,DeliveryAddress,ProductValue,TaxAmount,POValue," + "ExchangeRate,ProductValueINR,TaxAmountINR " + ",POValueINR,Remarks,TermsAndCondition,Status,DocumentStatus,CreateTime," + "CreateUser,ForwardUser,ApproveUser,CreatorName " + ",ForwarderName,ApproverName,Comments,ForwarderList,CommentStatus " + "from ViewPOHeader where Status=1 and DocumentStatus=99 and ReferenceIndent like '%" + refindent + "%'"; SqlCommand cmd = new SqlCommand(query, conn); conn.Open(); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { pod = new poheader(); pod.DocumentID = reader.GetString(0); pod.DocumentName = reader.GetString(1); pod.TemporaryNo = reader.GetInt32(2); pod.TemporaryDate = reader.GetDateTime(3).Date; pod.PONo = reader.GetInt32(4); pod.PODate = reader.GetDateTime(5).Date; pod.ReferenceIndent = reader.GetString(6); pod.ReferenceQuotation = reader.GetString(7); pod.CustomerID = reader.GetString(8); pod.CustomerName = reader.GetString(9); pod.CurrencyID = reader.GetString(10); pod.DeliveryPeriod = reader.GetInt32(11); pod.validityPeriod = reader.GetInt32(12); pod.TaxTerms = reader.GetString(13); pod.ModeOfPayment = reader.GetString(14); pod.PaymentTerms = reader.GetString(15); pod.TransportationMode = reader.GetString(16); pod.FreightTerms = reader.GetString(17); pod.FreightCharge = reader.GetDouble(18); pod.DeliveryAddress = reader.GetString(19); pod.ProductValue = reader.GetDouble(20); pod.TaxAmount = reader.GetDouble(21); pod.POValue = reader.GetDouble(22); pod.ExchangeRate = reader.GetDecimal(23); pod.ProductValueINR = reader.GetDouble(24); pod.TaxAmountINR = reader.GetDouble(25); pod.POValueINR = reader.GetDouble(26); pod.Remarks = reader.GetString(27); pod.TermsAndCondition = reader.GetString(28); pod.Status = reader.GetInt32(29); pod.DocumentStatus = reader.GetInt32(30); pod.CreateTime = reader.GetDateTime(31); pod.CreateUser = reader.GetString(32); pod.ForwardUser = reader.GetString(33); pod.ApproveUser = reader.GetString(34); pod.CreatorName = reader.GetString(35); pod.ForwarderName = reader.GetString(36); pod.ApproverName = reader.GetString(37); pod.Comments = reader.GetString(38); pod.ForwarderList = reader.GetString(39); pod.CommentStatus = reader.GetString(40); PODetail.Add(pod); } conn.Close(); } catch (Exception ex) { MessageBox.Show("Error querying Work Order Details"); } return(PODetail); }
public Boolean InsertIndentGeneralHeaderAndDetail(indentgeneralheader igh, List <indentgeneraldetail> IGDetail) { Boolean status = true; string utString = ""; string updateSQL = ""; try { igh.TemporaryNo = DocumentNumberDB.getNumber(igh.DocumentID, 1); if (igh.TemporaryNo <= 0) { MessageBox.Show("Error in Creating New Number"); return(false); } updateSQL = "update DocumentNumber set TempNo =" + igh.TemporaryNo + " where FYID='" + Main.currentFY + "' and DocumentID='" + igh.DocumentID + "'"; utString = utString + updateSQL + Main.QueryDelimiter; utString = utString + ActivityLogDB.PrepareActivityLogQquerString("update", "DocumentNumber", "", updateSQL) + Main.QueryDelimiter; updateSQL = "insert into IndentGeneralHeader " + "(DocumentID,TemporaryNo,TemporaryDate,DocumentNo,DocumentDate,ReferenceNo,CurrencyID," + "ExchangeRate,ProductValue,ProductValueINR,TargetDate,PurchaseSource," + "Status,DocumentStatus,CreateTime,CreateUser, CommentStatus,Comments,ForwarderList)" + " values (" + "'" + igh.DocumentID + "'," + igh.TemporaryNo + "," + "'" + igh.TemporaryDate.ToString("yyyy-MM-dd") + "'," + igh.DocumentNo + "," + "'" + igh.DocumentDate.ToString("yyyy-MM-dd") + "'," + "'" + igh.ReferenceNo + "'," + "'" + igh.CurrencyID + "'," + igh.ExchangeRate + "," + igh.ProductValue + "," + igh.ProductValueINR + "," + "'" + igh.TargetDate.ToString("yyyy-MM-dd") + "'," + "'" + igh.PurchaseSource + "'," + igh.Status + "," + igh.DocumentStatus + "," + "GETDATE()" + "," + "'" + Login.userLoggedIn + "'," + "'" + igh.CommentStatus + "'," + "'" + igh.Comments + "'," + "'" + igh.ForwarderList + "')"; utString = utString + updateSQL + Main.QueryDelimiter; utString = utString + ActivityLogDB.PrepareActivityLogQquerString("insert", "IndentGeneralHeader", "", updateSQL) + Main.QueryDelimiter; updateSQL = "Delete from IndentGeneralDetail where DocumentID='" + igh.DocumentID + "'" + " and TemporaryNo=" + igh.TemporaryNo + " and TemporaryDate='" + igh.TemporaryDate.ToString("yyyy-MM-dd") + "'"; utString = utString + updateSQL + Main.QueryDelimiter; utString = utString + ActivityLogDB.PrepareActivityLogQquerString("delete", "IndentGeneralDetail", "", updateSQL) + Main.QueryDelimiter; foreach (indentgeneraldetail igd in IGDetail) { updateSQL = "insert into IndentGeneralDetail " + "(DocumentID,TemporaryNo,TemporaryDate,ItemDetail,Quantity,ExpectedPurchasePrice,WarrantyDays) " + "values ('" + igd.DocumentID + "'," + igh.TemporaryNo + "," + "'" + igd.TemporaryDate.ToString("yyyy-MM-dd") + "'," + "'" + igd.ItemDetail + "'," + igd.Quantity + "," + igd.ExpectedPurchasePrice + " ," + igd.WarrantyDays + ")"; utString = utString + updateSQL + Main.QueryDelimiter; utString = utString + ActivityLogDB.PrepareActivityLogQquerString("insert", "IndentGeneralDetail", "", updateSQL) + Main.QueryDelimiter; } if (!UpdateTable.UT(utString)) { status = false; } } catch (Exception ex) { status = false; MessageBox.Show("Transaction Exception Occured"); } return(status); }
public Boolean updateIndentGeneralHeaderAndDetail(indentgeneralheader igh, indentgeneralheader previgh, List <indentgeneraldetail> IGDetail) { Boolean status = true; string utString = ""; try { string updateSQL = "update IndentGeneralHeader set TemporaryNo = " + igh.TemporaryNo + ", TemporaryDate='" + igh.TemporaryDate.ToString("yyyy-MM-dd") + //"', DocumentNo=" + igh.DocumentNo + //", DocumentDate='" + igh.DocumentDate.ToString("yyyy-MM-dd") + "', ReferenceNo='" + igh.ReferenceNo + "', TargetDate='" + igh.TargetDate.ToString("yyyy-MM-dd") + "', CurrencyID='" + igh.CurrencyID + "', Comments='" + igh.Comments + "', CommentStatus='" + igh.CommentStatus + "', ExchangeRate=" + igh.ExchangeRate + ", ProductValue=" + igh.ProductValue + ", ProductValueINR=" + igh.ProductValueINR + ", PurchaseSource='" + igh.PurchaseSource + "'" + " where DocumentID='" + previgh.DocumentID + "'" + " and TemporaryNo=" + previgh.TemporaryNo + " and TemporaryDate='" + previgh.TemporaryDate.ToString("yyyy-MM-dd") + "'"; utString = utString + updateSQL + Main.QueryDelimiter; utString = utString + ActivityLogDB.PrepareActivityLogQquerString("update", "IndentGeneralHeader", "", updateSQL) + Main.QueryDelimiter; updateSQL = "Delete from IndentGeneralDetail where DocumentID='" + previgh.DocumentID + "'" + " and TemporaryNo=" + previgh.TemporaryNo + " and TemporaryDate='" + previgh.TemporaryDate.ToString("yyyy-MM-dd") + "'"; utString = utString + updateSQL + Main.QueryDelimiter; utString = utString + ActivityLogDB.PrepareActivityLogQquerString("delete", "IndentGeneralDetail", "", updateSQL) + Main.QueryDelimiter; foreach (indentgeneraldetail igd in IGDetail) { updateSQL = "insert into IndentGeneralDetail " + "(DocumentID,TemporaryNo,TemporaryDate,ItemDetail,Quantity,ExpectedPurchasePrice,WarrantyDays) " + "values ('" + igd.DocumentID + "'," + igd.TemporaryNo + "," + "'" + igd.TemporaryDate.ToString("yyyy-MM-dd") + "'," + "'" + igd.ItemDetail + "'," + igd.Quantity + "," + igd.ExpectedPurchasePrice + " ," + igd.WarrantyDays + ")"; utString = utString + updateSQL + Main.QueryDelimiter; utString = utString + ActivityLogDB.PrepareActivityLogQquerString("insert", "IndentGeneralDetail", "", updateSQL) + Main.QueryDelimiter; } if (!UpdateTable.UT(utString)) { status = false; MessageBox.Show("Transaction Exception Occured"); } } catch (Exception ex) { status = false; } return(status); }
public List <indentgeneralheader> getFilteredIndnetGeneralHeaders(string userList, int opt, string userCommentStatusString) { indentgeneralheader igh; List <indentgeneralheader> IGHeaders = new List <indentgeneralheader>(); 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," + " DocumentNo,DocumentDate,ReferenceNo,CurrencyID,CurrencyName,ExchangeRate,TargetDate,PurchaseSource," + " Status,DocumentStatus,CreateTime,CreateUser,ForwardUser,ApproveUser,CreatorName,ForwarderName,ApproverName,CommentStatus,ForwarderList,ProductValue,ProductValueINR " + " from ViewIndentGeneralHeader" + " where ((forwarduser='******' and DocumentStatus between 2 and 98) " + " or (createuser='******' and DocumentStatus=1)" + " or (commentStatus like '%" + userCommentStatusString + "%' and DocumentStatus between 1 and 98)) and Status not in (7,98) order by TemporaryDate desc,DocumentID asc,TemporaryNo desc"; string query2 = "select RowID, DocumentID, DocumentName,TemporaryNo,TemporaryDate," + " DocumentNo,DocumentDate,ReferenceNo,CurrencyID,CurrencyName,ExchangeRate,TargetDate,PurchaseSource," + " Status,DocumentStatus,CreateTime,CreateUser,ForwardUser,ApproveUser,CreatorName,ForwarderName,ApproverName,CommentStatus,ForwarderList,ProductValue,ProductValueINR " + " from ViewIndentGeneralHeader" + " 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)) and Status not in (7,98) order by TemporaryDate desc,DocumentID asc,TemporaryNo desc"; //for those who have add/edit/delete permission string query3 = "select a.RowID, a.DocumentID, a.DocumentName,a.TemporaryNo,a.TemporaryDate, " + " a.DocumentNo,a.DocumentDate,a.ReferenceNo,a.CurrencyID,a.CurrencyName,a.ExchangeRate,a.TargetDate,a.PurchaseSource, " + " a.Status,a.DocumentStatus,a.CreateTime,a.CreateUser,a.ForwardUser,a.ApproveUser,a.CreatorName,a.ForwarderName," + "a.ApproverName,a.CommentStatus,a.ForwarderList,a.ProductValue,a.ProductValueINR, COUNT(b.PONo)po " + " from ViewIndentGeneralHeader a left outer join POHeader b " + " on ReferenceIndent like CONCAT('%', a.DocumentID, '(', a.DocumentNo, CHAR(222), CONVERT(varchar, a.DocumentDate), ');%') " + " and b.Status = 1 and b.DocumentStatus = 99 " + " where ((a.createuser='******'" + " or a.ForwarderList like '%" + userList + "%'" + " or a.commentStatus like '%" + acStr + "%'" + " or a.approveUser='******')" + " and a.DocumentStatus = 99) and a.status = 1 " + " group by a.RowID, a.DocumentID, a.DocumentName,a.TemporaryNo,a.TemporaryDate, " + " a.DocumentNo,a.DocumentDate,a.ReferenceNo,a.CurrencyID,a.CurrencyName,a.ExchangeRate,a.TargetDate,a.PurchaseSource, " + " a.Status,a.DocumentStatus,a.CreateTime,a.CreateUser,a.ForwardUser,a.ApproveUser,a.CreatorName,a.ForwarderName," + "a.ApproverName,a.CommentStatus,a.ForwarderList,a.ProductValue,a.ProductValueINR order by a.DocumentDate desc,a.DocumentID asc,a.DocumentNo desc"; string query6 = "select a.RowID, a.DocumentID, a.DocumentName,a.TemporaryNo,a.TemporaryDate, " + " a.DocumentNo,a.DocumentDate,a.ReferenceNo,a.CurrencyID,a.CurrencyName,a.ExchangeRate,a.TargetDate,a.PurchaseSource, " + " a.Status,a.DocumentStatus,a.CreateTime,a.CreateUser,a.ForwardUser,a.ApproveUser,a.CreatorName,a.ForwarderName," + "a.ApproverName,a.CommentStatus,a.ForwarderList,a.ProductValue,a.ProductValueINR, COUNT(b.PONo)po " + " from ViewIndentGeneralHeader a left outer join POHeader b " + " on ReferenceIndent like CONCAT('%', a.DocumentID, '(', a.DocumentNo, CHAR(222), CONVERT(varchar, a.DocumentDate), ');%') " + " and b.Status = 1 and b.DocumentStatus = 99 " + " where a.DocumentStatus = 99 and a.status = 1" + " group by a.RowID, a.DocumentID, a.DocumentName,a.TemporaryNo,a.TemporaryDate, " + " a.DocumentNo,a.DocumentDate,a.ReferenceNo,a.CurrencyID,a.CurrencyName,a.ExchangeRate,a.TargetDate,a.PurchaseSource, " + " a.Status,a.DocumentStatus,a.CreateTime,a.CreateUser,a.ForwardUser,a.ApproveUser,a.CreatorName,a.ForwarderName," + "a.ApproverName,a.CommentStatus,a.ForwarderList,a.ProductValue,a.ProductValueINR order by a.DocumentDate desc,a.DocumentID asc,a.DocumentNo 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()) { igh = new indentgeneralheader(); igh.RowID = reader.GetInt32(0); igh.DocumentID = reader.GetString(1); igh.DocumentName = reader.GetString(2); igh.TemporaryNo = reader.GetInt32(3); igh.TemporaryDate = reader.GetDateTime(4); igh.DocumentNo = reader.GetInt32(5); igh.DocumentDate = reader.IsDBNull(6) ? DateTime.Parse("1900-01-01") : reader.GetDateTime(6); igh.ReferenceNo = reader.GetString(7); igh.CurrencyID = reader.GetString(8); igh.CurrencyName = reader.GetString(9); igh.ExchangeRate = reader.GetDecimal(10); igh.TargetDate = reader.GetDateTime(11); igh.PurchaseSource = reader.GetString(12); igh.Status = reader.GetInt32(13); igh.DocumentStatus = reader.GetInt32(14); igh.CreateTime = reader.GetDateTime(15); igh.CreateUser = reader.GetString(16); igh.ForwardUser = reader.IsDBNull(17) ? "" : reader.GetString(17); igh.ApproveUser = reader.IsDBNull(18) ? "" : reader.GetString(18); igh.CreatorName = reader.GetString(19); igh.ForwarderName = reader.IsDBNull(20) ? "" : reader.GetString(20); igh.ApproverName = reader.IsDBNull(21) ? "" : reader.GetString(21); if (!reader.IsDBNull(22)) { igh.CommentStatus = reader.GetString(22); } else { igh.CommentStatus = ""; } if (!reader.IsDBNull(23)) { igh.ForwarderList = reader.GetString(23); } else { igh.ForwarderList = ""; } igh.ProductValue = reader.IsDBNull(24) ? 0 : reader.GetDouble(24); igh.ProductValueINR = reader.IsDBNull(25) ? 0 : reader.GetDouble(25); if (opt == 3 || opt == 6) { igh.pono = reader.IsDBNull(26) ? 0 : reader.GetInt32(26); } IGHeaders.Add(igh); } conn.Close(); } catch (Exception ex) { MessageBox.Show("Error querying Indent General Header Details"); } return(IGHeaders); }
////new public static List <poheader> getPurchaseOrderHeader(indentgeneralheader iigh) { poheader poh; List <poheader> PODetail = new List <poheader>(); try { string query = ""; string refindent = iigh.DocumentID + "(" + iigh.DocumentNo + "" + Main.delimiter1 + "" + iigh.DocumentDate.ToString("yyyy-MM-dd") + ");"; SqlConnection conn = new SqlConnection(Login.connString); query = "select RowID, DocumentID, DocumentName,TemporaryNo,TemporaryDate," + " PONo,PODate,ReferenceIndent,ReferenceQuotation,CustomerID,CustomerName,CurrencyID,DeliveryPeriod,ValidityPeriod,TaxTerms,ModeOfPayment,PaymentTerms," + " FreightTerms,FreightCharge,DeliveryAddress,ProductValue,TaxAmount,POValue,Remarks, " + " TermsAndCondition,Status,DocumentStatus,CreateTime,CreateUser,ForwardUser,ApproveUser,CreatorName,ForwarderName,ApproverName ,CommentStatus,ForwarderList" + " ,ExchangeRate, ProductValueINR, POValueINR, TaxAmountINR,TransportationMode,SpecialNote,PartialShipment,Transhipment,PackingSpec,PriceBasis,DeliveryAt,CountryID " + "from ViewPOHeader where Status=1 and DocumentStatus=99 and ReferenceIndent like '%" + refindent + "%'"; SqlCommand cmd = new SqlCommand(query, conn); conn.Open(); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { poh = new poheader(); poh.RowID = reader.GetInt32(0); poh.DocumentID = reader.GetString(1); poh.DocumentName = reader.GetString(2); poh.TemporaryNo = reader.GetInt32(3); poh.TemporaryDate = reader.GetDateTime(4); poh.PONo = reader.GetInt32(5); if (!reader.IsDBNull(6)) { poh.PODate = reader.GetDateTime(6); } poh.ReferenceIndent = reader.GetString(7); poh.ReferenceQuotation = reader.GetString(8); poh.CustomerID = reader.GetString(9); poh.CustomerName = reader.GetString(10); poh.CurrencyID = reader.GetString(11); poh.DeliveryPeriod = reader.GetInt32(12); poh.validityPeriod = reader.GetInt32(13); poh.TaxTerms = reader.GetString(14); poh.ModeOfPayment = reader.GetString(15); poh.PaymentTerms = reader.GetString(16); //poh.CreditPeriod = reader.GetInt32(17); poh.FreightTerms = reader.GetString(17); poh.FreightCharge = reader.GetDouble(18); poh.DeliveryAddress = reader.GetString(19); poh.ProductValue = reader.GetDouble(20); poh.TaxAmount = reader.GetDouble(21); poh.POValue = reader.GetDouble(22); poh.Remarks = reader.GetString(23); poh.TermsAndCondition = reader.GetString(24); poh.Status = reader.GetInt32(25); poh.DocumentStatus = reader.GetInt32(26); poh.CreateTime = reader.GetDateTime(27); poh.CreateUser = reader.GetString(28); poh.ForwardUser = reader.GetString(29); poh.ApproveUser = reader.GetString(30); poh.CreatorName = reader.GetString(31); poh.ForwarderName = reader.GetString(32); poh.ApproverName = reader.GetString(33); if (!reader.IsDBNull(34)) { poh.CommentStatus = reader.GetString(34); } else { poh.CommentStatus = ""; } if (!reader.IsDBNull(35)) { poh.ForwarderList = reader.GetString(35); } else { poh.ForwarderList = ""; } poh.ExchangeRate = reader.GetDecimal(36); poh.ProductValueINR = reader.GetDouble(37); poh.POValueINR = reader.GetDouble(38); poh.TaxAmountINR = reader.GetDouble(39); poh.TransportationMode = reader.IsDBNull(40) ? "" : reader.GetString(40); poh.SpecialNote = reader.IsDBNull(41) ? "" : reader.GetString(41); poh.PartialShipment = reader.IsDBNull(42) ? "" : reader.GetString(42); poh.Transhipment = reader.IsDBNull(43) ? "" : reader.GetString(43); poh.PackingSpec = reader.IsDBNull(44) ? "" : reader.GetString(44); poh.PriceBasis = reader.IsDBNull(45) ? "" : reader.GetString(45); poh.DeliveryAt = reader.IsDBNull(46) ? "" : reader.GetString(46); poh.CountryID = reader.IsDBNull(47) ? "" : reader.GetString(47); PODetail.Add(poh); } conn.Close(); } catch (Exception ex) { MessageBox.Show("Error querying Work Order Details"); } return(PODetail); }