public static List <GeneralLedgerSubsidiaryAccountDetail> GetSubsidiaryAccount(string intFiscal, string strBranch, string intMonth)
{
var dbUtil = new DatabaseManager();
var SubsidiaryItems = new List <GeneralLedgerSubsidiaryAccountDetail>();
using (var conn = new SqlConnection(dbUtil.getSQLConnectionString("MainDB")))
{
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "spAccGeneralBalanceGetSubsidiaryAccount";
cmd.CommandTimeout = 180;
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("@datBranch", Convert.ToInt32(strBranch));
cmd.Parameters.AddWithValue("@intFiscalYear", Convert.ToInt32(intFiscal));
cmd.Parameters.AddWithValue("@intMonth", Convert.ToInt32(intMonth));
using (SqlDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
// SELECT b.ID As IDdtl, a.ID As IDhdr, d.ID As IDMasCOA, d.strName As strAcctCOA, c.ID As IDMasCOASub,
//c.strName As strAcctCOASub, b.curBegBal, b.curTranDebit, b.curTranCredit, b.curUnAdjustedDebit, b.curUnAdjustedCredit
var genSubsidiaryItems = new GeneralLedgerSubsidiaryAccountDetail
{
ID = ReferenceEquals(reader["IDdtl"], DBNull.Value) ? 0 : Convert.ToInt32(reader["IDdtl"]),
intIDAccGeneralBalanceCOASubsidiary = ReferenceEquals(reader["IDhdr"], DBNull.Value) ? 0 : Convert.ToInt32(reader["IDhdr"]),
intIDMasCOA = ReferenceEquals(reader["IDMasCOA"], DBNull.Value) ? 0 : Convert.ToInt32(reader["IDMasCOA"]),
strAccountCOA = ReferenceEquals(reader["strAcctCOA"], DBNull.Value) ? string.Empty : Convert.ToString(reader["strAcctCOA"]),
intIDMasCOASubsidiary = ReferenceEquals(reader["IDMasCOASub"], DBNull.Value) ? 0 : Convert.ToInt32(reader["IDMasCOASub"]),
strAccountSubsidiary = ReferenceEquals(reader["strAcctCOASub"], DBNull.Value) ? string.Empty : Convert.ToString(reader["strAcctCOASub"]),
curBegBal = ReferenceEquals(reader["curBegBal"], DBNull.Value) ? 0 : Convert.ToDecimal(reader["curBegBal"]),
curTranCredit = ReferenceEquals(reader["curTranCredit"], DBNull.Value) ? 0 : Convert.ToDecimal(reader["curTranCredit"]),
curTranDebit = ReferenceEquals(reader["curTranDebit"], DBNull.Value) ? 0 : Convert.ToDecimal(reader["curTranDebit"]),
curUnadjustedCredit = ReferenceEquals(reader["curUnAdjustedCredit"], DBNull.Value) ? 0 : Convert.ToDecimal(reader["curUnAdjustedCredit"]),
curUnadjustedDebit = ReferenceEquals(reader["curUnAdjustedDebit"], DBNull.Value) ? 0 : Convert.ToDecimal(reader["curUnAdjustedDebit"]),
};
SubsidiaryItems.Add(genSubsidiaryItems);
}
return(SubsidiaryItems);
}
}
}
}
private void Manage()
{
try
{
//Response.Write(frmAccGeneralBalanceSubsidiaryBAL.Manage(Request.QueryString, Request.Form));
string result = frmAccGeneralBalanceSubsidiaryBAL.Manage(Request.QueryString, Request.Form);
var requisition = new GeneralLedgerSubsidiaryAccountDetail
{
strAccountCOA = result.Split(',')[0],
};
Response.Write(requisition.ToJSON());
}
catch (Exception ex)
{
Response.Write("Error: " + ex.Message);
}
}
