protected void lnk_Edit_Command(object sender, CommandEventArgs e)
{
try
{
clearControls();
_obj_Smhr_Committee = new SMHR_COMMITTEE();
_obj_Smhr_Committee.COMMITTEE_ID = Convert.ToInt32(Convert.ToString(e.CommandArgument));
_obj_Smhr_Committee.COMMITTEE_ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
DataSet dt = BLL.get_Committee(_obj_Smhr_Committee);
rtxt_CommiteeName.Enabled = false;
lbl_CommiteeID.Text = Convert.ToString(dt.Tables[0].Rows[0]["COMMITTEE_ID"]);
rtxt_CommiteeName.Text = Convert.ToString(dt.Tables[0].Rows[0]["COMMITTEE_CODE"]);
rtxt_CommitteeDesc.Text = Convert.ToString(dt.Tables[0].Rows[0]["COMMITTEE_DESC"]);
rcmb_CommitteeEmployees.SelectedValue = Convert.ToString(dt.Tables[0].Rows[0]["COMMITTEE_EMP_ID"]);
rtxt_CommitteeReason.Text = Convert.ToString(dt.Tables[0].Rows[0]["COMMITTEE_REASON"]);
rtxt_Review.Text = Convert.ToString(dt.Tables[0].Rows[0]["COMMITTEE_REVIEW"]);
rtxt_CommitteeOutcome.Text = Convert.ToString(dt.Tables[0].Rows[0]["COMMITTEE_OUTCOME"]);
rcmb_Status.SelectedValue = Convert.ToBoolean(dt.Tables[0].Rows[0]["COMMITTEE_STATUS"]) == true ? "1" : "0";
if (dt.Tables[0].Rows[0]["COMMITTEE_STARTDATE"] != string.Empty)
{
rdtp_CommitteeStartDate.SelectedDate = Convert.ToDateTime(dt.Tables[0].Rows[0]["COMMITTEE_STARTDATE"]);
}
if (dt.Tables[0].Rows[0]["COMMITTEE_ENDDATE"] != string.Empty)
{
rdtp_CommitteeEndDate.SelectedDate = Convert.ToDateTime(dt.Tables[0].Rows[0]["COMMITTEE_ENDDATE"]);
}
lstEmployees.DataSource = dt.Tables[1];
lstEmployees.DataBind();
//code for security
if (Convert.ToInt32(Session["WRITEFACILITY"]) == 2)
{
btn_Update.Visible = false;
}
else
{
btn_Update.Visible = true;
}
Rm_CY_page.SelectedIndex = 1;
}
catch (Exception ex)
{
SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_Committee", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}
public void LoadGrid()
{
try
{
_obj_Smhr_Committee = new SMHR_COMMITTEE();
_obj_Smhr_Committee.COMMITTEE_ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
DataTable DT = BLL.get_Committee(_obj_Smhr_Committee).Tables[0];
Rg_COMMITTEE.DataSource = DT;
clearControls();
}
catch (Exception ex)
{
SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_Committee", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}
protected void btn_Save_Click(object sender, EventArgs e)
{
try
{
_obj_Smhr_Committee = new SMHR_COMMITTEE();
_obj_Smhr_Committee.COMMITTEE_CODE = BLL.ReplaceQuote(rtxt_CommiteeName.Text);
_obj_Smhr_Committee.COMMITTEE_DESC = BLL.ReplaceQuote(rtxt_CommitteeDesc.Text);
if (lstEmployees.Items.Count == 0)
{
BLL.ShowMessage(this, "Please Add Members to Committee");
return;
}
string strEMPIDs = string.Empty;
foreach (ListItem item in lstEmployees.Items)
{
strEMPIDs += item.Value + ",";
}
_obj_Smhr_Committee.COMMITTEE_EMP_ID = strEMPIDs;
_obj_Smhr_Committee.COMMITTEE_REASON = BLL.ReplaceQuote(rtxt_CommitteeReason.Text);
_obj_Smhr_Committee.COMMITTEE_REVIEW = BLL.ReplaceQuote(rtxt_Review.Text);
_obj_Smhr_Committee.COMMITTEE_OUTCOME = BLL.ReplaceQuote(rtxt_CommitteeOutcome.Text);
_obj_Smhr_Committee.COMMITTEE_STATUS = rcmb_Status.SelectedValue == "1" ? true : false;
_obj_Smhr_Committee.COMMITTEE_STARTDATE = rdtp_CommitteeStartDate.SelectedDate.ToString();
_obj_Smhr_Committee.COMMITTEE_ENDDATE = rdtp_CommitteeEndDate.SelectedDate.ToString();
_obj_Smhr_Committee.COMMITTEE_ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
//_obj_Smhr_Committee.COMMITTEE_COMMITTEE_ID = Convert.ToInt32(rcmb_Country.SelectedValue);
_obj_Smhr_Committee.COMMITTEE_CREATEDBY = Convert.ToInt32(Session["USER_ID"]); // ### Need to Get the Session
_obj_Smhr_Committee.COMMITTEE_CREATEDDATE = DateTime.Now.ToShortDateString();
_obj_Smhr_Committee.COMMITTEE_LASTMDFBY = Convert.ToInt32(Session["USER_ID"]); // ### Need to Get the Session
_obj_Smhr_Committee.COMMITTEE_LASTMDFDATE = DateTime.Now.ToShortDateString();
switch (((Button)sender).ID.ToUpper())
{
case "BTN_UPDATE":
_obj_Smhr_Committee.COMMITTEE_ID = Convert.ToInt32(lbl_CommiteeID.Text);
_obj_Smhr_Committee.OPERATION = operation.Update;
if (BLL.set_Committee(_obj_Smhr_Committee))
{
BLL.ShowMessage(this, "Information Updated Successfully");
}
else
{
BLL.ShowMessage(this, "Information Not Updated");
}
break;
case "BTN_SAVE":
_obj_Smhr_Committee.OPERATION = operation.Check;
if (Convert.ToString(BLL.get_Committee(_obj_Smhr_Committee).Tables[0].Rows[0]["Count"]) != "0")
{
BLL.ShowMessage(this, "Committee Name Already Exists");
return;
}
_obj_Smhr_Committee.OPERATION = operation.Insert;
if (BLL.set_Committee(_obj_Smhr_Committee))
{
BLL.ShowMessage(this, "Information Saved Successfully");
}
else
{
BLL.ShowMessage(this, "Information Not Saved");
}
break;
default:
break;
}
Rm_CY_page.SelectedIndex = 0;
LoadGrid();
Rg_COMMITTEE.DataBind();
}
catch (Exception ex)
{
SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_Committee", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}
