public static List <paymentvoucherdetail> getVoucherDetail(paymentvoucher vh) { paymentvoucherdetail vd; List <paymentvoucherdetail> VDetail = new List <paymentvoucherdetail>(); try { string query = ""; SqlConnection conn = new SqlConnection(Login.connString); query = "select RowID,DocumentID,TemporaryNo, TemporaryDate,AccountCode,AccountName,AmountDebit,AmountDebitINR,AmountCredit,AmountCreditINR, " + "ChequeNo,ChequeDate" + " from ViewPaymentVoucher " + "where DocumentID='" + vh.DocumentID + "'" + " and TemporaryNo=" + vh.TemporaryNo + " and TemporaryDate='" + vh.TemporaryDate.ToString("yyyy-MM-dd") + "'"; SqlCommand cmd = new SqlCommand(query, conn); conn.Open(); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { vd = new paymentvoucherdetail(); vd.RowID = reader.GetInt32(0); vd.DocumentID = reader.GetString(1); vd.TemporaryNo = reader.GetInt32(2); vd.TemporaryDate = reader.GetDateTime(3); vd.AccountCode = reader.GetString(4); vd.AccountName = reader.IsDBNull(5)?"":reader.GetString(5); vd.AmountDebit = reader.GetDecimal(6); vd.AmountDebitINR = reader.GetDecimal(7); vd.AmountCredit = reader.GetDecimal(8); vd.AmountCreditINR = reader.GetDecimal(9); vd.ChequeNo = reader.GetString(10); vd.ChequeDate = reader.IsDBNull(11) ? DateTime.Parse("1900-01-01") : reader.GetDateTime(11); VDetail.Add(vd); } conn.Close(); } catch (Exception ex) { MessageBox.Show("Error querying MRN Details"); } return(VDetail); }
public static List <paymentvoucherdetail> getVoucherDetail(paymentvoucher vh) { paymentvoucherdetail vd; List <paymentvoucherdetail> VDetail = new List <paymentvoucherdetail>(); try { string query = ""; SqlConnection conn = new SqlConnection(Login.connString); query = "select RowID,DocumentID,TemporaryNo, TemporaryDate,AccountCodeDebit,AccountNameDebit,AmountDebit,BillNo,BillDate, " + "ChequeNo,ChequeDate" + " from ViewPaymentVoucher " + "where DocumentID='" + vh.DocumentID + "'" + " and TemporaryNo=" + vh.TemporaryNo + " and TemporaryDate='" + vh.TemporaryDate.ToString("yyyy-MM-dd") + "'"; SqlCommand cmd = new SqlCommand(query, conn); conn.Open(); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { vd = new paymentvoucherdetail(); vd.RowID = reader.GetInt32(0); vd.DocumentID = reader.GetString(1); vd.TemporaryNo = reader.GetInt32(2); vd.TemporaryDate = reader.GetDateTime(3).Date; vd.AccountCodeDebit = reader.GetString(4); vd.AccountNameDebit = reader.GetString(5); vd.AmountDebit = reader.GetDecimal(6); vd.BillNo = reader.GetString(7); vd.BillDate = reader.GetDateTime(8); vd.ChequeNo = reader.GetString(9); vd.ChequeDate = reader.GetDateTime(10); VDetail.Add(vd); } conn.Close(); } catch (Exception ex) { MessageBox.Show(System.Reflection.MethodBase.GetCurrentMethod().Name + "() : Error"); } return(VDetail); }