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); } }