internal DataTable LoadFinancialYear(BudgetYearActivationModel ObjBudgetYearActivationModel)
{
try
{
ClsCon.cmd = new SqlCommand();
ClsCon.cmd.CommandType = CommandType.StoredProcedure;
ClsCon.cmd.CommandText = "SPBudgetFinancialYear";
ClsCon.cmd.Parameters.AddWithValue("@Ind", ObjBudgetYearActivationModel.Ind);
con = ClsCon.SqlConn();
ClsCon.cmd.Connection = con;
dtFinancialYear = new DataTable();
ClsCon.da = new SqlDataAdapter(ClsCon.cmd);
ClsCon.da.Fill(dtFinancialYear);
dtFinancialYear.TableName = "success";
}
catch (Exception)
{
dtFinancialYear = new DataTable();
dtFinancialYear.TableName = "error";
return(dtFinancialYear);
}
finally
{
con.Close();
con.Dispose();
ClsCon.da.Dispose();
ClsCon.cmd.Dispose();
}
return(dtFinancialYear);
}
internal DataTable SaveFinancialYear(BudgetYearActivationModel ObjBudgetYearActivationModel)
{
try
{
ClsCon.cmd = new SqlCommand();
ClsCon.cmd.CommandType = CommandType.StoredProcedure;
ClsCon.cmd.CommandText = "SPBudgetFinancialYear";
ClsCon.cmd.Parameters.AddWithValue("@Ind", ObjBudgetYearActivationModel.Ind);
ClsCon.cmd.Parameters.AddWithValue("@YrCode", ObjBudgetYearActivationModel.YrCode);
ClsCon.cmd.Parameters.AddWithValue("@YearFromTo", ObjBudgetYearActivationModel.YearFromTo);
ClsCon.cmd.Parameters.AddWithValue("@ActiveID", ObjBudgetYearActivationModel.ActiveID);
ClsCon.cmd.Parameters.AddWithValue("@UserID", ObjBudgetYearActivationModel.UserID);
ClsCon.cmd.Parameters.AddWithValue("@IPAddress", ObjBudgetYearActivationModel.IPAddress);
ClsCon.cmd.Parameters.AddWithValue("@AccountInd ", ObjBudgetYearActivationModel.AccountInd);
ClsCon.cmd.Parameters.AddWithValue("@BudgetInd", ObjBudgetYearActivationModel.BudgetInd);
ClsCon.cmd.Parameters.AddWithValue("@YrStartDate", ObjBudgetYearActivationModel.YrStartDate);
ClsCon.cmd.Parameters.AddWithValue("@YrEndDate", ObjBudgetYearActivationModel.YrEndDate);
ClsCon.cmd.Parameters.AddWithValue("@BudgetOrderNumber", ObjBudgetYearActivationModel.BudgetOrderNumber);
ClsCon.cmd.Parameters.AddWithValue("@BudgetOrderDate", ObjBudgetYearActivationModel.BudgetOrderDate);
ClsCon.cmd.Parameters.AddWithValue("@BudgetEntryDate", ObjBudgetYearActivationModel.BudgetEntryDate);
ClsCon.cmd.Parameters.AddWithValue("@AccountingOrderNumber", ObjBudgetYearActivationModel.AccountingOrderNumber);
ClsCon.cmd.Parameters.AddWithValue("@AccountingOrderDate", ObjBudgetYearActivationModel.AccountingOrderDate);
ClsCon.cmd.Parameters.AddWithValue("@AccountingEntryDate", ObjBudgetYearActivationModel.AccountingEntryDate);
con = ClsCon.SqlConn();
ClsCon.cmd.Connection = con;
dtFinancialYear = new DataTable();
ClsCon.da = new SqlDataAdapter(ClsCon.cmd);
ClsCon.da.Fill(dtFinancialYear);
dtFinancialYear.TableName = "success";
}
catch (Exception)
{
dtFinancialYear = new DataTable();
dtFinancialYear.TableName = "error";
return(dtFinancialYear);
}
finally
{
con.Close();
con.Dispose();
ClsCon.da.Dispose();
ClsCon.cmd.Dispose();
}
return(dtFinancialYear);
}
protected void btnSave_Click(object sender, EventArgs e)
{
try
{
objBudgetYearActivation = new BudgetYearActivationModel();
objBudgetYearActivation.Ind = 1;
objBudgetYearActivation.YrCode = 18;
objBudgetYearActivation.YearFromTo = ddlFinancialYr.SelectedValue;
objBudgetYearActivation.ActiveID = 1;
objBudgetYearActivation.UserID = GlobalSession.UserID;
objBudgetYearActivation.IPAddress = GlobalSession.IP;
objBudgetYearActivation.AccountInd = 0;
objBudgetYearActivation.BudgetInd = 1;
objBudgetYearActivation.YrStartDate = CommonCls.ConvertToDate("01/04/2018");
objBudgetYearActivation.YrEndDate = CommonCls.ConvertToDate("31/03/2019");
objBudgetYearActivation.BudgetOrderNumber = txtOrderNo.Text;
objBudgetYearActivation.BudgetOrderDate = CommonCls.ConvertToDate(txtOrderDate.Text);
objBudgetYearActivation.AccountingOrderDate = "";
objBudgetYearActivation.AccountingOrderNumber = "";
objBudgetYearActivation.AccountingEntryDate = "";
string uri = string.Format("BudgetYearActivation/SaveFinancialYear");
DataTable dtYear = CommonCls.ApiPostDataTable(uri, objBudgetYearActivation);
if (dtYear.Rows.Count > 0)
{
if (dtYear.Rows[0][0].ToString() == "1")
{
ShowMessage("Financial Year is Activated For Year" + ddlFinancialYr.SelectedValue, true);
}
}
else
{
ShowMessage("Data is not saved successfully", false);
}
}
catch (Exception ex)
{
ShowMessage(ex.Message, false);
}
}
private void LoadFinancialYear()
{
try
{
objBudgetYearActivation = new BudgetYearActivationModel();
objBudgetYearActivation.Ind = 11;
string uri = string.Format("BudgetYearActivation/LoadFinancialYear");
DataTable dtFinancialYear = CommonCls.ApiPostDataTable(uri, objBudgetYearActivation);
if (dtFinancialYear.Rows.Count > 0)
{
txtOrderNo.Text = dtFinancialYear.Rows[0]["BudgetOrderNumber"].ToString();
txtOrderDate.Text = CommonCls.ConvertDateDB(dtFinancialYear.Rows[0]["BudgetOrderDate"].ToString());
ddlFinancialYr.SelectedValue = dtFinancialYear.Rows[0]["YearFromTo"].ToString();
}
}
catch (Exception ex)
{
ShowMessage(ex.Message, false);
}
}
public DataTable LoadFinancialYear(BudgetYearActivationModel ObjBudgetYearActivationModel)
{
DataTable dtAmountModel = ObjBudgetYearActivationDA.LoadFinancialYear(ObjBudgetYearActivationModel);
return(dtAmountModel);
}
