protected void loadgrid()
{
try
{
_obj_cmp = new PMS_CMP();
_obj_cmp.OPERATION = operation.Select;
_obj_cmp.CMP_ORG_ID = Convert.ToInt32(Session["ORG_ID"]);
_obj_cmp.LOGIN_ID = Convert.ToInt32(Session["USER_ID"]);
DataTable dt = Pms_Bll.get_cmp(_obj_cmp);
if (dt.Rows.Count != 0)
{
RG_CMPform.DataSource = dt;
RG_CMPform.DataBind();
}
else
{
DataTable dt1 = new DataTable();
RG_CMPform.DataSource = dt1;
}
}
catch (Exception ex)
{
SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_CMPform", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}
protected void lnk_Edit_Commnad(object sender, CommandEventArgs e)
{
try
{
clearfields();
LoadCombos();
_obj_cmp = new PMS_CMP();
_obj_cmp.OPERATION = operation.Get;
_obj_cmp.CMP_ID = Convert.ToInt32(e.CommandArgument);
_obj_cmp.CMP_ORG_ID = Convert.ToInt32(Session["ORG_ID"]);
DataTable DT = Pms_Bll.get_cmp(_obj_cmp);
if (DT.Rows.Count != 0)
{
lbl_id.Text = Convert.ToString(DT.Rows[0]["CMP_ID"]);
txt_cmpname.Text = Pms_Bll.ReplaceQuote(Convert.ToString(DT.Rows[0]["CMP_NAME"]));
txt_description.Text = Pms_Bll.ReplaceQuote(Convert.ToString(DT.Rows[0]["CMP_DESCRIPTION"]));
rcmb_BUI.SelectedIndex = rcmb_BUI.Items.FindItemIndexByValue(Convert.ToString(DT.Rows[0]["CMP_BU_ID"]));
if (Convert.ToInt32(DT.Rows[0]["CMP_STATUS"]) == 0)
{
chkbx_status.Checked = true;
}
else if (Convert.ToInt32(DT.Rows[0]["CMP_STATUS"]) == 1)
{
chkbx_status.Checked = false;
}
RM_CMPform.SelectedIndex = 1;
btn_SAVE.Visible = true;
btn_SAVE.Visible = false;
btn_Update.Visible = true;
txt_description.Enabled = true;
txt_cmpname.Enabled = false;
//rtxt_KRAID.Enabled = false;
//txt_Measure.Enabled = true;
rcmb_BUI.Enabled = false;
lbl_status.Visible = true;
cln_status.Visible = true;
chkbx_status.Visible = true;
if (Convert.ToInt32(Session["WRITEFACILITY"]) == 2)
{
btn_Update.Visible = false;
}
else
{
btn_Update.Visible = true;
}
}
}
catch (Exception ex)
{
SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_CMPform", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}
protected void btn_Update_Click(object sender, EventArgs e)
{
try
{
_obj_cmp = new PMS_CMP();
_obj_cmp.CMP_ID = Convert.ToInt32(lbl_id.Text);
_obj_cmp.CMP_NAME = Pms_Bll.ReplaceQuote(Convert.ToString(txt_cmpname.Text));
_obj_cmp.CMP_DESCRIPTION = Pms_Bll.ReplaceQuote(Convert.ToString(txt_description.Text));
_obj_cmp.CMP_BU_ID = Convert.ToInt32(rcmb_BUI.SelectedValue);
//_obj_cmp.KRA_MEASURE = Convert.ToString(txt_Measure.Text.Replace("'", "''"));
_obj_cmp.LASTMDFBY = Convert.ToInt32(Session["USER_ID"]); // ### Need to Get the Session
_obj_cmp.LASTMDFDATE = DateTime.Now;
_obj_cmp.OPERATION = operation.Update;
//_obj_cmp.KRA_KRAID = Pms_Bll.ReplaceQuote(Convert.ToString(rtxt_KRAID.Text));
//_obj_kra.KRA_WEIGHTAGE = Convert.ToInt32(RNT_KraWeightage.Value);
if (chkbx_status.Checked == true)
{
_obj_cmp.CMP_STATUS = 0;
}
else if (chkbx_status.Checked == false)
{
_obj_cmp.CMP_STATUS = 1;
}
bool status = Pms_Bll.set_cmp(_obj_cmp);
if (status == true)
{
Pms_Bll.ShowMessage(this, "Competency Updated Successfully");
loadgrid();
btn_Update.Visible = true;
RM_CMPform.SelectedIndex = 0;
}
else
{
Pms_Bll.ShowMessage(this, "Unable to Update the record,Execption Occured");
return;
}
}
catch (Exception ex)
{
SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_CMPform", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}
protected void btn_SAVE_Click1(object sender, EventArgs e)
{
try
{
string s = Convert.ToString(txt_description.Text);
if (s.Length > 1000)
{
Pms_Bll.ShowMessage(this, "Description Cannot Greater Than 1000 Characters");
return;
}
_obj_cmp = new PMS_CMP();
_obj_cmp.OPERATION = operation.Check;
_obj_cmp.CMP_NAME = Pms_Bll.ReplaceQuote(Convert.ToString(txt_cmpname.Text));
_obj_cmp.CMP_BU_ID = Convert.ToInt32(rcmb_BUI.SelectedValue);
_obj_cmp.CMP_ORG_ID = Convert.ToInt32(Session["ORG_ID"]);
DataTable dt = Pms_Bll.get_cmp(_obj_cmp);
if (Convert.ToInt32(dt.Rows[0]["Count"]) != 0)
{
Pms_Bll.ShowMessage(this, "Competency Already Exist");
return;
}
else
{
_obj_cmp = new PMS_CMP();
_obj_cmp.OPERATION = operation.Insert;
_obj_cmp.CMP_ORG_ID = Convert.ToInt32(Session["ORG_ID"]);
_obj_cmp.CMP_NAME = Pms_Bll.ReplaceQuote(Convert.ToString(txt_cmpname.Text));
_obj_cmp.CMP_DESCRIPTION = Pms_Bll.ReplaceQuote(Convert.ToString(txt_description.Text));
_obj_cmp.CMP_BU_ID = Convert.ToInt32(rcmb_BUI.SelectedItem.Value);
_obj_cmp.LASTMDFBY = Convert.ToInt32(Session["USER_ID"]); // ### Need to Get the Session
_obj_cmp.LASTMDFDATE = DateTime.Now;
_obj_cmp.CREATEDBY = Convert.ToInt32(Session["USER_ID"]); // ### Need to Get the Session
_obj_cmp.CREATEDDATE = DateTime.Now;
if (chkbx_status.Checked)
{
_obj_cmp.CMP_STATUS = 0;
}
else
{
_obj_cmp.CMP_STATUS = 1;
}
// _obj_cmp.CMP_STATUS = true;
//_obj_cmp.KRA_KRAID = Pms_Bll.ReplaceQuote(Convert.ToString(rtxt_KRAID.Text));
//_obj_kra.KRA_WEIGHTAGE = Convert.ToInt32(RNT_KraWeightage.Value);
bool status = Pms_Bll.set_cmp(_obj_cmp);
if (status == true)
{
Pms_Bll.ShowMessage(this, "Competency Inserted Successfully");
loadgrid();
clearfields();
RM_CMPform.SelectedIndex = 0;
return;
}
else
{
Pms_Bll.ShowMessage(this, "Unable to Update the record,Execption Occured");
return;
}
}
}
catch (Exception ex)
{
SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_CMPform", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}
