public static List <CustomerOBdetail> getCustomerOBDetail(CustomerOBheader Acchr) { CustomerOBdetail Accd; List <CustomerOBdetail> AccDetail = new List <CustomerOBdetail>(); try { string query = ""; SqlConnection conn = new SqlConnection(Login.connString); query = "select RowID,DocumentID,DocumentNo,DocumentDate,SerialNo, " + "CustomerID,CustomerName,BalanceDebit,BalanceCredit " + "from ViewCustomerOB " + " where DocumentID='" + Acchr.DocumentID + "'" + " and DocumentNo=" + Acchr.DocumentNo + " and DocumentDate='" + Acchr.DocumentDate.ToString("yyyy-MM-dd") + "'" + " order by SerialNo"; SqlCommand cmd = new SqlCommand(query, conn); conn.Open(); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { Accd = new CustomerOBdetail(); Accd.RowID = reader.GetInt32(0); Accd.DocumentID = reader.GetString(1); Accd.DocumentNo = reader.GetInt32(2); Accd.DocumentDate = reader.GetDateTime(3).Date; if (!reader.IsDBNull(4)) { Accd.SerialNo = reader.GetInt32(4); } Accd.AccountCode = reader.GetString(5); Accd.AccountName = reader.GetString(6); Accd.BalanceDebit = reader.GetDecimal(7); Accd.BalanceCredit = reader.GetDecimal(8); AccDetail.Add(Accd); } conn.Close(); } catch (Exception ex) { MessageBox.Show(System.Reflection.MethodBase.GetCurrentMethod().Name + "() : Error"); } return(AccDetail); }
/////////Subledger modification public static List <CustomerOBdetail> getCustomerOBListForPericualrFY(string fy) { CustomerOBdetail cust; List <CustomerOBdetail> CustDetail = new List <CustomerOBdetail>(); try { string query = ""; SqlConnection conn = new SqlConnection(Login.connString); query = "select RowID,DocumentID,DocumentNo,DocumentDate,SerialNo, " + "CustomerID,CustomerName,BalanceDebitINR,BalanceCreditINR,(BalanceDebitINR-BalanceCreditINR) " + "from ViewCustomerOB " + " where FYID='" + fy.Trim() + "' and status = 1"; SqlCommand cmd = new SqlCommand(query, conn); conn.Open(); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { cust = new CustomerOBdetail(); cust.RowID = reader.GetInt32(0); cust.DocumentID = reader.GetString(1); cust.DocumentNo = reader.GetInt32(2); cust.DocumentDate = reader.GetDateTime(3).Date; if (!reader.IsDBNull(4)) { cust.SerialNo = reader.GetInt32(4); } cust.AccountCode = reader.GetString(5); cust.AccountName = reader.GetString(6); cust.BalanceDebit = reader.GetDecimal(7); cust.BalanceCredit = reader.GetDecimal(8); cust.OBValue = reader.GetDecimal(9); CustDetail.Add(cust); } conn.Close(); } catch (Exception ex) { MessageBox.Show(System.Reflection.MethodBase.GetCurrentMethod().Name + "() : Error"); } return(CustDetail); }