public static int InsertInformation(A2ZBUDGETDTO dto)
{
int result = Helper.SqlHelper.ExecuteNonQuery(DataAccessLayer.Constants.DBConstants.GetConnectionString("A2ZACGMS"), "Sp_CSInsertBudgetAmt", new object[] { dto.BranchNo, dto.BudgetYear, dto.GLACCNO, dto.DrCrFlag, dto.Amount1, dto.Amount2, dto.Amount3, dto.Amount4, dto.Amount5, dto.Amount6, dto.Amount7, dto.Amount8, dto.Amount9, dto.Amount10, dto.Amount11, dto.Amount12, dto.BudgetAmount });
if (result == 0)
{
return(0);
}
else
{
return(1);
}
}
public static A2ZBUDGETDTO GetInformation(int BranchNo, int BudgetYear, int GLACCNO, Int16 DrCrFlag)
{
var prm = new object[4];
prm[0] = BranchNo;
prm[1] = BudgetYear;
prm[2] = GLACCNO;
prm[3] = DrCrFlag;
DataTable dt = BLL.CommonManager.Instance.GetDataTableBySpWithParams("Sp_CSGetBudgetAmt", prm, "A2ZACGMS");
var p = new A2ZBUDGETDTO();
if (dt.Rows.Count > 0)
{
p.ID = Converter.GetInteger(dt.Rows[0]["Id"]);
p.BranchNo = Converter.GetInteger(dt.Rows[0]["BranchNo"]);
p.BudgetYear = Converter.GetSmallInteger(dt.Rows[0]["BudgetYear"]);
p.GLACCNO = Converter.GetInteger(dt.Rows[0]["GLACCNO"]);
p.DrCrFlag = Converter.GetSmallInteger(dt.Rows[0]["DrCrFlag"]);
p.Amount1 = Converter.GetInteger(dt.Rows[0]["Amount1"]);
p.Amount2 = Converter.GetInteger(dt.Rows[0]["Amount2"]);
p.Amount3 = Converter.GetInteger(dt.Rows[0]["Amount3"]);
p.Amount4 = Converter.GetInteger(dt.Rows[0]["Amount4"]);
p.Amount5 = Converter.GetInteger(dt.Rows[0]["Amount5"]);
p.Amount6 = Converter.GetInteger(dt.Rows[0]["Amount6"]);
p.Amount7 = Converter.GetInteger(dt.Rows[0]["Amount7"]);
p.Amount8 = Converter.GetInteger(dt.Rows[0]["Amount8"]);
p.Amount9 = Converter.GetInteger(dt.Rows[0]["Amount9"]);
p.Amount10 = Converter.GetInteger(dt.Rows[0]["Amount10"]);
p.Amount11 = Converter.GetInteger(dt.Rows[0]["Amount11"]);
p.Amount12 = Converter.GetInteger(dt.Rows[0]["Amount12"]);
p.BudgetAmount = Converter.GetInteger(dt.Rows[0]["BudgetAmount"]);
return(p);
}
return(p);
}
