public static DataTable GET_AREA_BU_WISE(SMHR_AREA _obj_smhr_Area)
{
return(ExecuteQuery("EXEC USP_SMHR_AREA @Operation = 'GET_AREA_BU_WISE'" +
",@AREA_BU= " + _obj_smhr_Area.AREA_BUSINESSUNIT_ID +
",@ORG_ID= " + _obj_smhr_Area.ORGANISATION_ID));
//",@AREA_ID= " + _obj_smhr_Area.AREA_ID
}
public static DataTable GET_AREA_BU_DI_DP_SD_WISE(SMHR_AREA _obj_smhr_Area)
{
return(ExecuteQuery("EXEC USP_SMHR_AREA @Operation = 'GET_AREA_BU_DI_DP_SD_WISE'" +
",@AREA_BU= " + _obj_smhr_Area.AREA_BUSINESSUNIT_ID +
",@ORG_ID= " + _obj_smhr_Area.ORGANISATION_ID +
//",@AREA_ID= " + _obj_smhr_Area.AREA_ID +
",@AREA_DIRECTORATE_ID= " + _obj_smhr_Area.AREA_DIRECTORATE_ID +
",@AREA_DEPARTMENT_ID= " + _obj_smhr_Area.AREA_DEPARTMENT_ID +
",@AREA_SUBDEPARTMENT_ID= " + _obj_smhr_Area.AREA_SUBDEPARTMENT_ID));
}
protected void LoadAreasGrid()
{
try
{
_obj_Smhr_Area = new SMHR_AREA();
_obj_Smhr_Area.OPERATION = operation.GET_ALLAREAS;
_obj_Smhr_Area.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
Rg_Areas.DataSource = BLL.get_AllAreas(_obj_Smhr_Area);
//Rg_Areas.DataBind();
}
catch (Exception ex)
{
SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_Areas", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}
protected void lnk_Edit(object sender, CommandEventArgs e)
{
try
{
ClearControls();
_obj_Smhr_Area = new SMHR_AREA();
rcmb_EmpReg_BU.Enabled = false;
rad_Directorate.Enabled = false;
rad_Department.Enabled = false;
rad_SubDepartment.Enabled = false;
rad_AreaName.Enabled = false;
rad_Description.Enabled = true;
rad_IsActive.Enabled = true;
_obj_Smhr_Area.AREA_ID = Convert.ToInt32(e.CommandArgument);
DataTable dt = BLL.get_Area(_obj_Smhr_Area);
LoadBusinessUnit();
lbl_AreaID.Text = Convert.ToString(dt.Rows[0]["AREA_ID"]);
rad_AreaName.Text = Convert.ToString(dt.Rows[0]["Area_Name"]);
rad_IsActive.Checked = Convert.ToBoolean(dt.Rows[0]["Area_IS_ACTIVE"]);
rcmb_EmpReg_BU.SelectedValue = Convert.ToString(dt.Rows[0]["BUSINESSUNIT_ID"]);
Load_Directorate();
if (Convert.ToInt32(dt.Rows[0]["AREA_DIRECTORATE_ID"]) != 0)
{
rad_Directorate.SelectedValue = Convert.ToString(dt.Rows[0]["AREA_DIRECTORATE_ID"]);
}
else
{
rad_Directorate.SelectedValue = Convert.ToString(0);
}
LoadDepartment();
rad_Department.SelectedValue = Convert.ToString(dt.Rows[0]["AREA_DEPARTMENT_ID"]);
LoadDivision();
rad_SubDepartment.SelectedValue = Convert.ToString(dt.Rows[0]["AREA_SUBDEPARTMENT_ID"]);
rad_Description.Text = Convert.ToString(dt.Rows[0]["AREA_DESCRIPTION"]);
Rm_HDPT_page.SelectedIndex = 1;
rad_IsActive.Enabled = true;
BTN_SAVE.Visible = false;
btn_Update.Visible = true;
}
catch (Exception ex)
{
SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_Areas", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}
protected void BTN_SAVE_Click(object sender, EventArgs e)
{
try
{
bool status = false;
int buID = Convert.ToInt32(rcmb_EmpReg_BU.SelectedValue);
DataTable dtAreaExists = new DataTable();
switch (((Button)sender).ID.ToUpper())
{
case "BTN_SAVE":
_obj_Smhr_Area = new SMHR_AREA();
_obj_Smhr_Area.OPERATION = operation.Insert;
_obj_Smhr_Area.AREA_NAME = Convert.ToString(rad_AreaName.Text);
_obj_Smhr_Area.AREA_DESCRIPTION = rad_Description.Text;
_obj_Smhr_Area.AREA_CREATED_BY = Convert.ToInt32(Session["USER_ID"]);
_obj_Smhr_Area.AREA_CREATED_DATE = DateTime.Now;
_obj_Smhr_Area.AREA_IS_ACTIVE = Convert.ToBoolean(rad_IsActive.Checked);
if (buID != 0)
{
_obj_Smhr_Area.AREA_BUSINESSUNIT_ID = buID;
}
else
{
BLL.ShowMessage(this, "Please Select Business Unit");
return;
}
if (rad_Directorate.SelectedIndex > 0)
{
_obj_Smhr_Area.AREA_DIRECTORATE_ID = Convert.ToInt32(rad_Directorate.SelectedValue);
}
else
{
_obj_Smhr_Area.AREA_DIRECTORATE_ID = 0;
}
if (rad_Department.SelectedIndex > 0)
{
_obj_Smhr_Area.AREA_DEPARTMENT_ID = Convert.ToInt32(rad_Department.SelectedValue);
}
else
{
_obj_Smhr_Area.AREA_DEPARTMENT_ID = 0;
}
if (rad_SubDepartment.SelectedIndex > 0)
{
_obj_Smhr_Area.AREA_SUBDEPARTMENT_ID = Convert.ToInt32(rad_SubDepartment.SelectedValue);
}
else
{
_obj_Smhr_Area.AREA_SUBDEPARTMENT_ID = 0;
}
_obj_Smhr_Area.AREA_BUSINESSUNIT_ID = Convert.ToInt32(rcmb_EmpReg_BU.SelectedValue);
dtAreaExists = BLL.checkAreaexistsbyBuID(_obj_Smhr_Area);
if (dtAreaExists.Rows.Count == 0)
{
status = BLL.set_Areas(_obj_Smhr_Area);
if (status == true)
{
BLL.ShowMessage(this, "Information Successfully Saved");
}
}
else
{
BLL.ShowMessage(this, "This Area Already Exists");
return;
}
break;
case "BTN_UPDATE":
_obj_Smhr_Area = new SMHR_AREA();;
_obj_Smhr_Area.OPERATION = operation.Update;
_obj_Smhr_Area.AREA_NAME = Convert.ToString(rad_AreaName.Text);
_obj_Smhr_Area.AREA_DESCRIPTION = rad_Description.Text;
_obj_Smhr_Area.AREA_DIRECTORATE_ID = Convert.ToInt32(rad_Directorate.SelectedValue);
if (rad_Department.SelectedIndex > 0)
{
_obj_Smhr_Area.AREA_DEPARTMENT_ID = Convert.ToInt32(rad_Department.SelectedValue);
}
else
{
_obj_Smhr_Area.AREA_DEPARTMENT_ID = 0;
}
if (rad_SubDepartment.SelectedIndex > 0)
{
_obj_Smhr_Area.AREA_SUBDEPARTMENT_ID = Convert.ToInt32(rad_SubDepartment.SelectedValue);
}
else
{
_obj_Smhr_Area.AREA_SUBDEPARTMENT_ID = 0;
}
_obj_Smhr_Area.AREA_MODIFIED_BY = Convert.ToInt32(Session["USER_ID"]);
_obj_Smhr_Area.AREA_MODIFIED_DATE = DateTime.Now;
_obj_Smhr_Area.AREA_ID = Convert.ToInt32(lbl_AreaID.Text);
_obj_Smhr_Area.AREA_IS_ACTIVE = Convert.ToBoolean(rad_IsActive.Checked);
_obj_Smhr_Area.AREA_DIRECTORATE_ID = Convert.ToInt32(rad_Directorate.SelectedValue);
if (Convert.ToString(rad_Department.SelectedValue) != "")
{
_obj_Smhr_Area.AREA_DEPARTMENT_ID = Convert.ToInt32(rad_Department.SelectedValue);
}
else
{
_obj_Smhr_Area.AREA_DEPARTMENT_ID = 0;
}
_obj_Smhr_Area.AREA_SUBDEPARTMENT_ID = Convert.ToInt32(rad_SubDepartment.SelectedValue);
_obj_Smhr_Area.AREA_BUSINESSUNIT_ID = Convert.ToInt32(rcmb_EmpReg_BU.SelectedValue);
if (buID != 0)
{
_obj_Smhr_Area.AREA_BUSINESSUNIT_ID = buID;
}
else
{
BLL.ShowMessage(this, "Please Select Business Unit");
return;
}
status = BLL.set_Areas(_obj_Smhr_Area);
if (status == true)
{
BLL.ShowMessage(this, "Information Updated Successfully");
}
break;
}
Rm_HDPT_page.SelectedIndex = 0;
LoadAreasGrid();
Rg_Areas.DataBind();
}
catch (Exception ex)
{
SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_Areas", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}
public static DataTable checkAreaexistsbyBuID(SMHR_AREA _obj_smhr_areas_master)
{
return(ExecuteQuery("EXEC USP_SMHR_AREA @Operation = 'CHECKEXISTS_BY_BU_ID',@AREA_NAME = '" + _obj_smhr_areas_master.AREA_NAME + "'" + ",@AREA_BU=" + _obj_smhr_areas_master.AREA_BUSINESSUNIT_ID));
}
public static DataTable get_allareas_by_buID(SMHR_AREA _obj_smhr_area)
{
return(ExecuteQuery("EXEC USP_SMHR_AREA @Operation = 'GET_ALLAREAS_BY_BUID'" + ", @AREA_BU=" + _obj_smhr_area.AREA_BUSINESSUNIT_ID));
}
