public static string ManageUpdate(NameValueCollection querystring)
{
decimal decimalParser;
int intparser;
UserProfile userProfile = WebCommon.GetUserProfile();
string isInsert = querystring.Get("transType");
var BnkRecon = new GeneralLedgerIndividualSubsidiaryAccountDetail
{
ID = int.TryParse(querystring.Get("sID"), out intparser) ? intparser : 0,
intIDAccGeneralBalanceCOAIndSub = int.TryParse(querystring.Get("sintIDAccGeneralBalanceCOAIndSub"), out intparser) ? intparser : 0,
intIDMasCOAIndSub = int.TryParse(querystring.Get("sintIDMasCOAIndSub"), out intparser) ? intparser : 0,
strAccountCOAIndSub = querystring.Get("sstrAccountCOAIndSub"),
curBegBal = decimal.TryParse(querystring.Get("scurBegBal"), out decimalParser) ? decimalParser : 0,
curTranDebit = decimal.TryParse(querystring.Get("scurTranDebit"), out decimalParser) ? decimalParser : 0,
curTranCredit = decimal.TryParse(querystring.Get("scurTranCredit"), out decimalParser) ? decimalParser : 0,
curUnadjustedDebit = decimal.TryParse(querystring.Get("scurUnadjustedDebit"), out decimalParser) ? decimalParser : 0,
curUnadjustedCredit = decimal.TryParse(querystring.Get("scurUnadjustedCredit"), out decimalParser) ? decimalParser : 0
};
string param = WebCommon.ToXML(BnkRecon);
//return "";
return(frmAccGeneralBalanceIndividualSubsidiaryDAL.ManageUpdate(param, isInsert));
}
public static List <GeneralLedgerIndividualSubsidiaryAccountDetail> GetSubsidiaryAccount(string intFiscal, string strBranch, string intMonth, string intSub)
{
var dbUtil = new DatabaseManager();
var SubsidiaryItems = new List <GeneralLedgerIndividualSubsidiaryAccountDetail>();
using (var conn = new SqlConnection(dbUtil.getSQLConnectionString("MainDB")))
{
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "spAccGeneralBalanceGetIndividualSubsidiaryAccount";
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));
cmd.Parameters.AddWithValue("@intIndSubID", Convert.ToInt32(intSub));
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 GeneralLedgerIndividualSubsidiaryAccountDetail
{
ID = ReferenceEquals(reader["IDdtl"], DBNull.Value) ? 0 : Convert.ToInt32(reader["IDdtl"]),
intIDAccGeneralBalanceCOAIndSub = ReferenceEquals(reader["IDhdr"], DBNull.Value) ? 0 : Convert.ToInt32(reader["IDhdr"]),
intIDMasCOAIndSub = ReferenceEquals(reader["intIDMasCOAIndSub"], DBNull.Value) ? 0 : Convert.ToInt32(reader["intIDMasCOAIndSub"]),
strAccountCOAIndSub = ReferenceEquals(reader["strAccountCOAIndSub"], DBNull.Value) ? string.Empty : Convert.ToString(reader["strAccountCOAIndSub"]),
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);
}
}
}
}
