public DataTable CheckBudgetAmount(NewBudgetAmountModel ObjNewBudgetAmountModel)
{
DataTable dtAmountModel = ObjNewBudgetAmountDA.CheckBudgetAmount(ObjNewBudgetAmountModel);
return(dtAmountModel);
}
public DataTable SaveBudget(NewBudgetAmountModel ObjNewBudgetAmountModel)
{
DataTable dtAmountModel = ObjNewBudgetAmountDA.SaveBudgetAmount(ObjNewBudgetAmountModel);
return(dtAmountModel);
}
protected void btnSave_Click(object sender, EventArgs e)
{
try
{
if (string.IsNullOrEmpty(txtSectionName.Text))
{
ShowMessage("Select Section Name.", false);
txtSectionName.Focus();
return;
}
if (string.IsNullOrEmpty(txtSubSection.Text))
{
ShowMessage("Select Sub-Section Name.", false);
txtSubSection.Focus();
return;
}
if (string.IsNullOrEmpty(txtBudgetHead.Text))
{
ShowMessage("Select Budget Head Name.", false);
txtBudgetHead.Focus();
return;
}
CalCulateRevisedBudgetAmt();
objNewBudgetAmountModel = new NewBudgetAmountModel();
objNewBudgetAmountModel.Ind = 21;
objNewBudgetAmountModel.OrgID = GlobalSession.OrgID;
objNewBudgetAmountModel.BrID = GlobalSession.BrID;
objNewBudgetAmountModel.YrCode = GlobalSession.BudgetYrCD;
objNewBudgetAmountModel.SectionCD = CommonCls.ConvertIntZero(SectionID);
objNewBudgetAmountModel.SubSectionCD = CommonCls.ConvertIntZero(SubSectionID);
objNewBudgetAmountModel.BudgetHeadCD = CommonCls.ConvertIntZero(BudgetHeadID);
objNewBudgetAmountModel.SecCode = 0;
objNewBudgetAmountModel.UserID = GlobalSession.UserID;
objNewBudgetAmountModel.IP = "";
//Current Year Capital
if (txtPropBudgetCapitalAmtDr.Text == "" && txtPropBudgetCapitalAmtDr.Enabled == true)
{
objNewBudgetAmountModel.PropBudgetCapitalAmtDr = -1;
}
else
{
objNewBudgetAmountModel.PropBudgetCapitalAmtDr = CommonCls.ConvertDecimalZero(txtPropBudgetCapitalAmtDr.Text);
}
if (txtPropBudgetCapitalAmtCr.Text == "" && txtPropBudgetCapitalAmtCr.Enabled == true)
{
objNewBudgetAmountModel.PropBudgetCapitalAmtCr = -1;
}
else
{
objNewBudgetAmountModel.PropBudgetCapitalAmtCr = CommonCls.ConvertDecimalZero(txtPropBudgetCapitalAmtCr.Text);
}
//Current Year Revenue
if (txtPropBudgetRevenueAmtDr.Text == "" && txtPropBudgetRevenueAmtDr.Enabled == true)
{
objNewBudgetAmountModel.PropBudgetRevenueAmtDr = -1;
}
else
{
objNewBudgetAmountModel.PropBudgetRevenueAmtDr = CommonCls.ConvertDecimalZero(txtPropBudgetRevenueAmtDr.Text);
}
if (txtPropBudgetRevenueAmtCr.Text == "" && txtPropBudgetRevenueAmtCr.Enabled == true)
{
objNewBudgetAmountModel.PropBudgetRevenueAmtCr = -1;
}
else
{
objNewBudgetAmountModel.PropBudgetRevenueAmtCr = CommonCls.ConvertDecimalZero(txtPropBudgetRevenueAmtCr.Text);
}
// Propose Budget Amt
if (txtProp2BudgetAmtDr.Text == "" && txtProp2BudgetAmtDr.Enabled == true)
{
objNewBudgetAmountModel.Prop2BudgetAmtDr = -1;
}
else
{
objNewBudgetAmountModel.Prop2BudgetAmtDr = CommonCls.ConvertDecimalZero(txtProp2BudgetAmtDr.Text);
}
if (txtProp2BudgetAmtCr.Text == "" && txtProp2BudgetAmtCr.Enabled == true)
{
objNewBudgetAmountModel.Prop2BudgetAmtCr = -1;
}
else
{
objNewBudgetAmountModel.Prop2BudgetAmtCr = CommonCls.ConvertDecimalZero(txtProp2BudgetAmtCr.Text);
}
//Actual Busget Amt
if (txtActualUptoBudgetAmtCr.Text == "" && txtActualUptoBudgetAmtCr.Enabled == true)
{
objNewBudgetAmountModel.ActualUptoBudgetAmtCr = -1;
}
else
{
objNewBudgetAmountModel.ActualUptoBudgetAmtCr = CommonCls.ConvertDecimalZero(txtActualUptoBudgetAmtCr.Text);
}
if (txtActualUptoBudgetAmtDr.Text == "" && txtActualUptoBudgetAmtDr.Enabled == true)
{
objNewBudgetAmountModel.ActualUptoBudgetAmtDr = -1;
}
else
{
objNewBudgetAmountModel.ActualUptoBudgetAmtDr = CommonCls.ConvertDecimalZero(txtActualUptoBudgetAmtDr.Text);
}
//Qtr Amt
if (txtPropLastQtrBudgetAmtCr.Text == "" && txtPropLastQtrBudgetAmtCr.Enabled == true)
{
objNewBudgetAmountModel.PropLastQtrBudgetAmtCr = -1;
}
else
{
objNewBudgetAmountModel.PropLastQtrBudgetAmtCr = CommonCls.ConvertDecimalZero(txtPropLastQtrBudgetAmtCr.Text);
}
if (txtPropLastQtrBudgetAmtDr.Text == "" && txtPropLastQtrBudgetAmtDr.Enabled == true)
{
objNewBudgetAmountModel.PropLastQtrBudgetAmtDr = -1;
}
else
{
objNewBudgetAmountModel.PropLastQtrBudgetAmtDr = CommonCls.ConvertDecimalZero(txtPropLastQtrBudgetAmtDr.Text);
}
//Revised
//if (txtSanc2BudgetAmtCr.Text == "" && txtSanc2BudgetAmtCr.Enabled == true)
// objNewBudgetAmountModel.Sanc2BudgetAmtCr = -1;
//else
// objNewBudgetAmountModel.Sanc2BudgetAmtCr = CommonCls.ConvertDecimalZero(txtSanc2BudgetAmtCr.Text);
//if (txtSanc2BudgetAmtDr.Text == "" && txtSanc2BudgetAmtDr.Enabled == true)
// objNewBudgetAmountModel.Sanc2BudgetAmtDr = -1;
//else
// objNewBudgetAmountModel.Sanc2BudgetAmtDr = CommonCls.ConvertDecimalZero(txtSanc2BudgetAmtDr.Text);
objNewBudgetAmountModel.Sanc2BudgetAmtCr = (CommonCls.ConvertDecimalZero(objNewBudgetAmountModel.ActualUptoBudgetAmtCr) + CommonCls.ConvertDecimalZero(objNewBudgetAmountModel.PropLastQtrBudgetAmtCr));
objNewBudgetAmountModel.Sanc2BudgetAmtDr = (CommonCls.ConvertDecimalZero(objNewBudgetAmountModel.ActualUptoBudgetAmtDr) + CommonCls.ConvertDecimalZero(objNewBudgetAmountModel.PropLastQtrBudgetAmtDr));
if (txtPropBudgetCapitalAmtCr.Text == "" && txtPropBudgetRevenueAmtCr.Text == "" && txtPropBudgetCapitalAmtCr.Enabled == true && txtPropBudgetRevenueAmtCr.Enabled == true)
{
objNewBudgetAmountModel.PropBudgetAmtCr = -1;
}
else
{
decimal PropBudgetAmtCr = (CommonCls.ConvertDecimalZero(txtPropBudgetCapitalAmtCr.Text) + CommonCls.ConvertDecimalZero(txtPropBudgetRevenueAmtCr.Text));
objNewBudgetAmountModel.PropBudgetAmtCr = CommonCls.ConvertDecimalZero(PropBudgetAmtCr);
}
if (txtPropBudgetCapitalAmtDr.Text == "" && txtPropBudgetRevenueAmtDr.Text == "" && txtPropBudgetCapitalAmtDr.Enabled == true && txtPropBudgetRevenueAmtDr.Enabled == true)
{
objNewBudgetAmountModel.PropBudgetAmtDr = -1;
}
else
{
decimal PropBudgetAmtDr = (CommonCls.ConvertDecimalZero(txtPropBudgetCapitalAmtDr.Text) + CommonCls.ConvertDecimalZero(txtPropBudgetRevenueAmtDr.Text));
objNewBudgetAmountModel.PropBudgetAmtDr = CommonCls.ConvertDecimalZero(PropBudgetAmtDr);
}
//objNewBudgetAmountModel.PropBudgetAmtCr = CommonCls.ConvertDecimalZero(txtPropBudgetCapitalAmtCr.Text + txtPropBudgetRevenueAmtCr.Text);
//objNewBudgetAmountModel.PropBudgetAmtDr = CommonCls.ConvertDecimalZero(txtPropBudgetCapitalAmtDr.Text + txtPropBudgetRevenueAmtDr.Text);
string uri = string.Format("NewBudgetAmount/SaveBudget");
DataTable dtOpeningBalance = CommonCls.ApiPostDataTable(uri, objNewBudgetAmountModel);
if (dtOpeningBalance.Rows.Count > 0)
{
ShowMessage("Record Save successfully.", true);
ClearAll();
}
else
{
ShowMessage("Record Not Save successfully.", false);
}
}
catch (Exception ex)
{
ShowMessage(ex.Message, false);
}
}
public DataSet BindAll(NewBudgetAmountModel ObjNewBudgetAmountModel)
{
DataSet dsAmountModel = ObjNewBudgetAmountDA.BindAll(ObjNewBudgetAmountModel);
return(dsAmountModel);
}
internal DataTable SaveBudgetAmount(NewBudgetAmountModel ObjNewBudgetAmountModel)
{
try
{
ClsCon.cmd = new SqlCommand();
ClsCon.cmd.CommandType = CommandType.StoredProcedure;
ClsCon.cmd.CommandText = "SPBudgetAmount";
ClsCon.cmd.Parameters.AddWithValue("@Ind", ObjNewBudgetAmountModel.Ind);
ClsCon.cmd.Parameters.AddWithValue("@OrgID", ObjNewBudgetAmountModel.OrgID);
ClsCon.cmd.Parameters.AddWithValue("@BrID", ObjNewBudgetAmountModel.BrID);
ClsCon.cmd.Parameters.AddWithValue("@YrCD", ObjNewBudgetAmountModel.YrCode);
ClsCon.cmd.Parameters.AddWithValue("@SectionCD", ObjNewBudgetAmountModel.SectionCD);
ClsCon.cmd.Parameters.AddWithValue("@SubSectionCD", ObjNewBudgetAmountModel.SubSectionCD);
ClsCon.cmd.Parameters.AddWithValue("@BudgetHeadCD", ObjNewBudgetAmountModel.BudgetHeadCD);
ClsCon.cmd.Parameters.AddWithValue("@SecCode", ObjNewBudgetAmountModel.SecCode);
ClsCon.cmd.Parameters.AddWithValue("@ActualUptoBudgetAmtDr", ObjNewBudgetAmountModel.ActualUptoBudgetAmtDr);
ClsCon.cmd.Parameters.AddWithValue("@ActualUptoBudgetAmtCr ", ObjNewBudgetAmountModel.ActualUptoBudgetAmtCr);
ClsCon.cmd.Parameters.AddWithValue("@Prop2BudgetAmtDr", ObjNewBudgetAmountModel.Prop2BudgetAmtDr);
ClsCon.cmd.Parameters.AddWithValue("@Prop2BudgetAmtCr", ObjNewBudgetAmountModel.Prop2BudgetAmtCr);
ClsCon.cmd.Parameters.AddWithValue("@Sanc2BudgetAmtDr", ObjNewBudgetAmountModel.Sanc2BudgetAmtDr);
ClsCon.cmd.Parameters.AddWithValue("@Sanc2BudgetAmtCr", ObjNewBudgetAmountModel.Sanc2BudgetAmtCr);
ClsCon.cmd.Parameters.AddWithValue("@PropLastQtrBudgetAmtDr", ObjNewBudgetAmountModel.PropLastQtrBudgetAmtDr);
ClsCon.cmd.Parameters.AddWithValue("@PropLastQtrBudgetAmtCr", ObjNewBudgetAmountModel.PropLastQtrBudgetAmtCr);
ClsCon.cmd.Parameters.AddWithValue("@PropBudgetAmtDr", ObjNewBudgetAmountModel.PropBudgetAmtDr);
ClsCon.cmd.Parameters.AddWithValue("@PropBudgetAmtCr", ObjNewBudgetAmountModel.PropBudgetAmtCr);
ClsCon.cmd.Parameters.AddWithValue("@PropBudgetCapitalAmtCr", ObjNewBudgetAmountModel.PropBudgetCapitalAmtCr);
ClsCon.cmd.Parameters.AddWithValue("@PropBudgetCapitalAmtDr", ObjNewBudgetAmountModel.PropBudgetCapitalAmtDr);
ClsCon.cmd.Parameters.AddWithValue("@PropBudgetRevenueAmtCr", ObjNewBudgetAmountModel.PropBudgetRevenueAmtCr);
ClsCon.cmd.Parameters.AddWithValue("@PropBudgetRevenueAmtDr", ObjNewBudgetAmountModel.PropBudgetRevenueAmtDr);
ClsCon.cmd.Parameters.AddWithValue("@UserID", ObjNewBudgetAmountModel.UserID);
ClsCon.cmd.Parameters.AddWithValue("@IPAddr", ObjNewBudgetAmountModel.IP);
con = ClsCon.SqlConn();
ClsCon.cmd.Connection = con;
dtBudgetAmount = new DataTable();
ClsCon.da = new SqlDataAdapter(ClsCon.cmd);
ClsCon.da.Fill(dtBudgetAmount);
dtBudgetAmount.TableName = "success";
}
catch (Exception)
{
dtBudgetAmount = new DataTable();
dtBudgetAmount.TableName = "error";
return dtBudgetAmount;
}
finally
{
con.Close();
con.Dispose();
ClsCon.da.Dispose();
ClsCon.cmd.Dispose();
}
return dtBudgetAmount;
}
