public static List <AccountOBdetail> getAccountOBDetail(AccountOBheader Acchr)
{
AccountOBdetail Accd;
List <AccountOBdetail> AccDetail = new List <AccountOBdetail>();
try
{
string query = "";
SqlConnection conn = new SqlConnection(Login.connString);
query = "select RowID,DocumentID,DocumentNo,DocumentDate,SerialNo, " +
"AccountCode,AccountName,BalanceDebit,BalanceCredit " +
"from ViewAccountOB " +
" 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 AccountOBdetail();
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);
}
public static List <AccountOBdetail> getAccountOBListForPericualrFY(string fy)
{
AccountOBdetail Accd;
List <AccountOBdetail> AccDetail = new List <AccountOBdetail>();
try
{
string query = "";
SqlConnection conn = new SqlConnection(Login.connString);
query = "select RowID,DocumentID,DocumentNo,DocumentDate,SerialNo, " +
"AccountCode,AccountName,BalanceDebit,BalanceCredit,(BalanceDebit - BalanceCredit) as OB " +
"from ViewAccountOB " +
" where FYID='" + fy.Trim() + "' and AcStatus=1";
SqlCommand cmd = new SqlCommand(query, conn);
conn.Open();
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
Accd = new AccountOBdetail();
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);
Accd.OBValue = reader.GetDecimal(9);
AccDetail.Add(Accd);
}
conn.Close();
}
catch (Exception ex)
{
MessageBox.Show(System.Reflection.MethodBase.GetCurrentMethod().Name + "() : Error");
}
return(AccDetail);
}
