protected void LoadEquipmentsGrid()
{
try
{
_obj_smhr_equipment = new SMHR_EQUIPMENT();
_obj_smhr_equipment.OPERATION = operation.GET_ALLEQUIPMENTS;
_obj_smhr_equipment.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
Rg_Equipment.DataSource = BLL.get_AllEquipments(_obj_smhr_equipment);
//Rg_Equipment.DataBind();
}
catch (Exception ex)
{
SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_Equipment", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}
protected void lnk_Edit(object sender, CommandEventArgs e)
{
try
{
ClearControls();
rcmb_EmpReg_BU.Enabled = false;
rad_Directorate.Enabled = false;
rad_Department.Enabled = false;
rad_SubDepartment.Enabled = false;
rad_EquipmentName.Enabled = false;
rdtp_ExpiryDate.Enabled = true;
rad_IsActive.Enabled = true;
_obj_smhr_equipment = new SMHR_EQUIPMENT();
_obj_smhr_equipment.EQUIPMENT_ID = Convert.ToInt32(e.CommandArgument);
DataTable dt = BLL.get_Equipment(_obj_smhr_equipment);
ViewState["buID"] = Convert.ToInt32(dt.Rows[0]["BUSINESSUNIT_ID"]);
ViewState["dirID"] = Convert.ToInt32(dt.Rows[0]["EQUIPMENT_DIRECTORATE_ID"]);
ViewState["depID"] = Convert.ToInt32(dt.Rows[0]["EQUIPMENT_DEPARTMENT_ID"]);
ViewState["sdpID"] = Convert.ToInt32(dt.Rows[0]["EQUIPMENT_SUBDEPARTMNET"]);
ViewState["Mode"] = 1;
LoadBusinessUnit();
lbl_EquipmentID.Text = Convert.ToString(dt.Rows[0]["EQUIPMENT_ID"]);
rad_EquipmentName.Text = Convert.ToString(dt.Rows[0]["EQUIPMENT_NAME"]);
rad_IsActive.Checked = Convert.ToBoolean(dt.Rows[0]["EQUIPMENT_ISACTIVE"]);
rcmb_EmpReg_BU.SelectedValue = Convert.ToString(dt.Rows[0]["BUSINESSUNIT_ID"]);
Load_Directorate();
rad_Directorate.SelectedValue = Convert.ToString(dt.Rows[0]["EQUIPMENT_DIRECTORATE_ID"]);
LoadDepartment();
rad_Department.SelectedValue = Convert.ToString(dt.Rows[0]["EQUIPMENT_DEPARTMENT_ID"]);
LoadDivision();
rad_SubDepartment.SelectedValue = Convert.ToString(dt.Rows[0]["EQUIPMENT_SUBDEPARTMNET"]);
rdtp_ExpiryDate.SelectedDate = Convert.ToDateTime(dt.Rows[0]["EQUIPMENT_EXPIRYDATE"]);
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_Equipment", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}
public static DataTable checkEquipmentexistsbyBuID(SMHR_EQUIPMENT _obj_smhr_equipment)
{
return(ExecuteQuery("EXEC USP_SMHR_EQUIPMENT_MASTER @Operation = 'CHECKEXISTS_BY_BU_ID',@EQUIPMENT_NAME = '" + _obj_smhr_equipment.EQUIPMENT_NAME + "'" + ",@EQUIPMENT_BU_ID=" + _obj_smhr_equipment.BUID));
}
protected void BTN_SAVE_Click(object sender, EventArgs e)
{
try
{
bool status = false;
bool checkExists = false;
_obj_smhr_equipment = new SMHR_EQUIPMENT();
DataTable dtEqpmntExists = new DataTable();
int buID = Convert.ToInt32(rcmb_EmpReg_BU.SelectedValue);
switch (((Button)sender).ID.ToUpper())
{
case "BTN_SAVE":
_obj_smhr_equipment.OPERATION = operation.Insert;
_obj_smhr_equipment.EQUIPMENT_NAME = Convert.ToString(rad_EquipmentName.Text);
_obj_smhr_equipment.EQUIPMENT_EXPIRYDATE = Convert.ToDateTime(rdtp_ExpiryDate.SelectedDate);
_obj_smhr_equipment.EQUIPMENT_DIRECTORATE_ID = Convert.ToInt32(rad_Directorate.SelectedValue);
if (rad_Department.SelectedIndex > 0)
{
_obj_smhr_equipment.EQUIPMENT_DEPARTMENT_ID = Convert.ToInt32(rad_Department.SelectedValue);
}
else
{
_obj_smhr_equipment.EQUIPMENT_DEPARTMENT_ID = 0;
}
if (rad_SubDepartment.SelectedIndex > 0)
{
_obj_smhr_equipment.EQUIPMENT_SUBDEPARTMNET = Convert.ToInt32(rad_SubDepartment.SelectedValue);
}
else
{
_obj_smhr_equipment.EQUIPMENT_SUBDEPARTMNET = 0;
}
if (buID != 0)
{
_obj_smhr_equipment.BUID = buID;
}
else
{
BLL.ShowMessage(this, "Please Select Business Unit");
return;
}
_obj_smhr_equipment.EQUIPMENT_CREATEDBY = Convert.ToInt32(Session["USER_ID"]);
_obj_smhr_equipment.EQUIPMENT_CREATEDDATE = DateTime.Now;
_obj_smhr_equipment.EQUIPMENT_ISACTIVE = Convert.ToBoolean(rad_IsActive.Checked);
dtEqpmntExists = BLL.checkEquipmentexistsbyBuID(_obj_smhr_equipment);
if (dtEqpmntExists.Rows.Count == 0)
{
status = BLL.set_EquipmentMaster(_obj_smhr_equipment);
if (status == true)
{
BLL.ShowMessage(this, "Information Successfully Saved");
}
}
else
{
BLL.ShowMessage(this, "This Equipment Already Exists");
return;
}
break;
case "BTN_UPDATE":
_obj_smhr_equipment.OPERATION = operation.Update;
_obj_smhr_equipment.EQUIPMENT_NAME = Convert.ToString(rad_EquipmentName.Text);
_obj_smhr_equipment.EQUIPMENT_EXPIRYDATE = Convert.ToDateTime(rdtp_ExpiryDate.SelectedDate);
_obj_smhr_equipment.EQUIPMENT_DIRECTORATE_ID = Convert.ToInt32(rad_Directorate.SelectedValue);
if (rad_Department.SelectedIndex > 0)
{
_obj_smhr_equipment.EQUIPMENT_DEPARTMENT_ID = Convert.ToInt32(rad_Department.SelectedValue);
}
else
{
_obj_smhr_equipment.EQUIPMENT_DEPARTMENT_ID = 0;
}
if (rad_SubDepartment.SelectedIndex > 0)
{
_obj_smhr_equipment.EQUIPMENT_SUBDEPARTMNET = Convert.ToInt32(rad_SubDepartment.SelectedValue);
}
else
{
_obj_smhr_equipment.EQUIPMENT_SUBDEPARTMNET = 0;
}
_obj_smhr_equipment.EQUIPMENT_MODIFIEDBY = Convert.ToInt32(Session["USER_ID"]);
_obj_smhr_equipment.EQUIPMENT_MODIFIEDDATE = DateTime.Now;
_obj_smhr_equipment.EQUIPMENT_ID = Convert.ToInt32(lbl_EquipmentID.Text);
_obj_smhr_equipment.EQUIPMENT_ISACTIVE = Convert.ToBoolean(rad_IsActive.Checked);
if (buID != 0)
{
_obj_smhr_equipment.BUID = buID;
}
else
{
BLL.ShowMessage(this, "Please Select Business Unit");
return;
}
status = BLL.set_EquipmentMaster(_obj_smhr_equipment);
if (status == true)
{
BLL.ShowMessage(this, "Information Updated Successfully");
}
break;
}
Rm_HDPT_page.SelectedIndex = 0;
LoadEquipmentsGrid();
Rg_Equipment.DataBind();
}
catch (Exception ex)
{
SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_Equipment", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}
