/// <summary>
/// Insert_IncrementCycles
/// </summary>
/// <param name="_obj_smhr_IncrementCycle"></param>
/// <returns></returns>
public static bool Insert_IncrementCycles(SMHR_INCREMENTCYCLE _obj_smhr_IncrementCycle)
{
bool status = false;
int result = 0;
List <SqlParameter> lstParameters = new List <SqlParameter>();
lstParameters.Add(new SqlParameter("@INCREMENTCYCLE_PERIOD_ID", _obj_smhr_IncrementCycle.INCREMENTCYCLE_PERIODID));
lstParameters.Add(new SqlParameter("@INCREMENTCYCLE_ORG_ID", _obj_smhr_IncrementCycle.ORGANISATION_ID));
lstParameters.Add(new SqlParameter("@PERIOD_INCREMENT", _obj_smhr_IncrementCycle.INCREMENTCYCLE_MONTH));
lstParameters.Add(new SqlParameter("@TBLINCREMENTCYCLES", _obj_smhr_IncrementCycle.TBLINCREMENTCYCLES));
lstParameters.Add(new SqlParameter("@INCREMENTCYCLE_CREATEDBY", _obj_smhr_IncrementCycle.CREATEDBY));
lstParameters.Add(new SqlParameter("@INCREMENTCYCLE_CREATEDDATE", _obj_smhr_IncrementCycle.CREATEDDATE));
lstParameters.Add(new SqlParameter("@Operation", "Insert"));
result = ExecuteNonQuery("USP_SMHR_INCREMENTCYCLE", lstParameters.ToArray());
if (result > 0)
{
status = true;
}
else
{
status = false;
}
return(status);
}
protected void btn_Save_Click(object sender, EventArgs e)
{
try
{
SMHR_INCREMENTCYCLE _obj_IncrementCycle = new SMHR_INCREMENTCYCLE();
_obj_IncrementCycle.INCREMENTCYCLE_PERIODID = Convert.ToInt32(rcmb_FinPeriod.SelectedValue);
_obj_IncrementCycle.INCREMENTCYCLE_MONTH = rcmb_Cycles.SelectedValue;
_obj_IncrementCycle.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
_obj_IncrementCycle.CREATEDBY = Convert.ToInt32(Session["USER_ID"]); // ### Need to Get the Session
_obj_IncrementCycle.CREATEDDATE = DateTime.Now;
RadNumericTextBox rtxt_SlabAmountGrid = new RadNumericTextBox();
DataTable dtIncrementCycles = new DataTable();
dtIncrementCycles.Columns.Add("PERIODID", typeof(int));
dtIncrementCycles.Columns.Add("STARTMONTH", typeof(string));
dtIncrementCycles.Columns.Add("ENDMONTH", typeof(string));
dtIncrementCycles.Columns.Add("INCREMENTCYCLE_SRNO", typeof(string));
dtIncrementCycles.Columns.Add("STARTMONTH_ID", typeof(int));
dtIncrementCycles.Columns.Add("ENDMONTH_ID", typeof(int));
for (int index = 0; index <= rg_FinCycles.Items.Count - 1; index++)
{
int PERIODID = rg_FinCycles.Items[index]["PERIODID"].Text != " " ? Convert.ToInt32(rg_FinCycles.Items[index]["PERIODID"].Text) : 0;
string StartMonth = rg_FinCycles.Items[index]["StartMonth"].Text != " " ? rg_FinCycles.Items[index]["StartMonth"].Text : string.Empty;
string EndMonth = rg_FinCycles.Items[index]["EndMonth"].Text != " " ? rg_FinCycles.Items[index]["EndMonth"].Text : string.Empty;
string SRNO = rg_FinCycles.Items[index]["SRNO"].Text != " " ? rg_FinCycles.Items[index]["SRNO"].Text : string.Empty;
int STARTMONTH_ID = rg_FinCycles.Items[index]["STARTMONTH_ID"].Text != " " ? Convert.ToInt32(rg_FinCycles.Items[index]["STARTMONTH_ID"].Text) : 0;
int ENDMONTH_ID = rg_FinCycles.Items[index]["ENDMONTH_ID"].Text != " " ? Convert.ToInt32(rg_FinCycles.Items[index]["ENDMONTH_ID"].Text) : 0;
dtIncrementCycles.Rows.Add(PERIODID, StartMonth, EndMonth, SRNO, STARTMONTH_ID, ENDMONTH_ID);
}
_obj_IncrementCycle.TBLINCREMENTCYCLES = dtIncrementCycles;
if (BLL.Insert_IncrementCycles(_obj_IncrementCycle))
{
BLL.ShowMessage(this, "Increment Cycles Saved Successfully");
}
else
{
BLL.ShowMessage(this, "Increment Cycles Failed");
}
Rm_CY_page.SelectedIndex = 0;
Rg_IncrementCycle.DataSource = BindIncrementCycleGrid();
Rg_IncrementCycle.DataBind();
}
catch (Exception ex)
{
SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_IncrementCycle", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}
private DataTable BindIncrementCycleGrid()
{
SMHR_INCREMENTCYCLE _obj_IncrementCycle = new SMHR_INCREMENTCYCLE();
try
{
_obj_IncrementCycle.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
_obj_IncrementCycle.OPERATION = operation.Select;
}
catch (Exception ex)
{
SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_IncrementCycle", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
return(BLL.Get_FinancialPeriodDetails(_obj_IncrementCycle));
}
protected void lnk_Edit_Command(object sender, CommandEventArgs e)
{
try
{
ClearControls();
rcmb_FinPeriod.Enabled = false;
rcmb_Cycles.Enabled = false;
btn_Generate.Enabled = false;
btn_Save.Enabled = false;
rg_FinCycles.Enabled = false;
LoadFinancialPeriodCombos("Edit");
LinkButton lnkEdit = sender as LinkButton;
GridDataItem item = lnkEdit.NamingContainer as GridDataItem;
rcmb_FinPeriod.SelectedValue = e.CommandArgument.ToString();
if (item["INCREMENTCYCLE_MONTH"].Text != " ")
{
rcmb_Cycles.SelectedValue = item["INCREMENTCYCLE_MONTH"].Text;
//btnGenerate_Click(null, null);
tr_GenerateCycles.Visible = true;
SMHR_INCREMENTCYCLE _obj_IncrementCycle = new SMHR_INCREMENTCYCLE();
_obj_IncrementCycle.INCREMENTCYCLE_PERIODID = Convert.ToInt32(rcmb_FinPeriod.SelectedValue);
_obj_IncrementCycle.INCREMENTCYCLE_MONTH = rcmb_Cycles.SelectedValue;
_obj_IncrementCycle.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
_obj_IncrementCycle.OPERATION = operation.IncrementCycles;
DataTable dtFinPeriodData = BLL.Get_FinancialPeriodDetails(_obj_IncrementCycle);
rg_FinCycles.DataSource = dtFinPeriodData;
rg_FinCycles.DataBind();
}
Rm_CY_page.SelectedIndex = 1;
}
catch (Exception ex)
{
SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_IncrementCycle", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}
protected void btnGenerate_Click(object sender, EventArgs e)
{
try
{
tr_GenerateCycles.Visible = true;
SMHR_INCREMENTCYCLE _obj_IncrementCycle = new SMHR_INCREMENTCYCLE();
_obj_IncrementCycle.INCREMENTCYCLE_PERIODID = Convert.ToInt32(rcmb_FinPeriod.SelectedValue);
_obj_IncrementCycle.INCREMENTCYCLE_MONTH = rcmb_Cycles.SelectedValue;
_obj_IncrementCycle.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
_obj_IncrementCycle.OPERATION = operation.Get;
DataTable dtFinPeriodData = BLL.Get_FinancialPeriodDetails(_obj_IncrementCycle);
ViewState["FinCycles"] = dtFinPeriodData;
rg_FinCycles.DataSource = dtFinPeriodData;
rg_FinCycles.DataBind();
}
catch (Exception ex)
{
SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_IncrementCycle", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}
/// <summary>
/// Get Financial Period Details
/// </summary>
/// <param name="_obj_smhr_IncrementCycle"></param>
/// <returns></returns>
public static DataTable Get_FinancialPeriodDetails(SMHR_INCREMENTCYCLE _obj_smhr_IncrementCycle)
{
if (_obj_smhr_IncrementCycle.OPERATION == operation.Select)
{
return(ExecuteQuery("EXEC USP_SMHR_INCREMENTCYCLE @Operation = 'Select', @INCREMENTCYCLE_PERIOD_ID = '" + _obj_smhr_IncrementCycle.INCREMENTCYCLE_PERIODID + "', @PERIOD_INCREMENT = '" + _obj_smhr_IncrementCycle.INCREMENTCYCLE_MONTH + "', @INCREMENTCYCLE_ORG_ID = '" + _obj_smhr_IncrementCycle.ORGANISATION_ID + "'"));
}
else if (_obj_smhr_IncrementCycle.OPERATION == operation.IncrementCycles)
{
return(ExecuteQuery("EXEC USP_SMHR_INCREMENTCYCLE @Operation = 'SELECTCYLCLES', @INCREMENTCYCLE_PERIOD_ID = '" + _obj_smhr_IncrementCycle.INCREMENTCYCLE_PERIODID + "', @PERIOD_INCREMENT = '" + _obj_smhr_IncrementCycle.INCREMENTCYCLE_MONTH + "', @INCREMENTCYCLE_ORG_ID = '" + _obj_smhr_IncrementCycle.ORGANISATION_ID + "'"));
}
else if (_obj_smhr_IncrementCycle.OPERATION == operation.FINANCIALPERIODSINCLUDED)
{
return(ExecuteQuery("EXEC USP_SMHR_INCREMENTCYCLE @Operation = 'FINANCIALPERIODSINCLUDED', @INCREMENTCYCLE_PERIOD_ID = '" + _obj_smhr_IncrementCycle.INCREMENTCYCLE_PERIODID + "', @PERIOD_INCREMENT = '" + _obj_smhr_IncrementCycle.INCREMENTCYCLE_MONTH + "', @INCREMENTCYCLE_ORG_ID = '" + _obj_smhr_IncrementCycle.ORGANISATION_ID + "'"));
}
else if (_obj_smhr_IncrementCycle.OPERATION == operation.FINANCIALPERIODSEXCLUDED)
{
return(ExecuteQuery("EXEC USP_SMHR_INCREMENTCYCLE @Operation = 'FINANCIALPERIODSEXCLUDED', @INCREMENTCYCLE_PERIOD_ID = '" + _obj_smhr_IncrementCycle.INCREMENTCYCLE_PERIODID + "', @PERIOD_INCREMENT = '" + _obj_smhr_IncrementCycle.INCREMENTCYCLE_MONTH + "', @INCREMENTCYCLE_ORG_ID = '" + _obj_smhr_IncrementCycle.ORGANISATION_ID + "'"));
}
else
{
return(ExecuteQuery("EXEC USP_SMHR_INCREMENTCYCLE @Operation = 'INCREMENTCYCLES', @INCREMENTCYCLE_PERIOD_ID = '" + _obj_smhr_IncrementCycle.INCREMENTCYCLE_PERIODID + "', @PERIOD_INCREMENT = '" + _obj_smhr_IncrementCycle.INCREMENTCYCLE_MONTH + "', @INCREMENTCYCLE_ORG_ID = '" + _obj_smhr_IncrementCycle.ORGANISATION_ID + "'"));
}
}
