protected void RG_EmpOrgSpnsCoursesform_NeedDataSource(object source, Telerik.Web.UI.GridNeedDataSourceEventArgs e)
{
try
{
_obj_smhr_courses = new SMHR_EMPORGSPNSCOURSES();
_obj_smhr_courses.OPERATION = operation.Select;
_obj_smhr_courses.EMPORGSPNSRCRS_ORGID = Convert.ToInt32(Session["ORG_ID"]);
_obj_smhr_courses.LOGIN_ID = Convert.ToInt32(Session["USER_ID"]);
DataTable dt = BLL.get_orgspnsdcourses(_obj_smhr_courses);
if (dt.Rows.Count != 0)
{
RG_EmpOrgSpnsCoursesform.DataSource = dt;
}
else
{
DataTable dt1 = new DataTable();
RG_EmpOrgSpnsCoursesform.DataSource = dt1;
}
}
catch (Exception ex)
{
SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_EmpOrgSpnsdCourses", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}
protected void btn_Update_Click(object sender, EventArgs e)
{
try
{
bool result = true;
validateInputs(out result);
if (result)
{
_obj_smhr_courses = new SMHR_EMPORGSPNSCOURSES();
_obj_smhr_courses.EMPORGSPNSRCRS_ID = Convert.ToInt32(lbl_id.Text);
_obj_smhr_courses.EMPORGSPNSRCRS_BUSINESSUNIT = Convert.ToInt32(BUFilter1.BusinessUnitID);
_obj_smhr_courses.EMPORGSPNSRCRS_DIRECTORATEID = Convert.ToInt32(BUFilter1.DirectorateID);
_obj_smhr_courses.EMPORGSPNSRCRS_DEPARTMENTID = Convert.ToInt32(BUFilter1.DepartmentID);
_obj_smhr_courses.EMPORGSPNSRCRS_EMPID = Convert.ToInt32(BUFilter1.EmployeeID);
_obj_smhr_courses.EMPORGSPNSRCRS_ORGID = Convert.ToInt32(Session["ORG_ID"].ToString());
_obj_smhr_courses.EMPORGSPNSRCRS_COURSENAME = Pms_Bll.ReplaceQuote(Convert.ToString(txtbx_CourseName.Text));
_obj_smhr_courses.EMPORGSPNSRCRS_OUTCOME = Pms_Bll.ReplaceQuote(Convert.ToString(txtbx_Outcome.Text));
_obj_smhr_courses.EMPORGSPNSRCRS_FROMDATE = Convert.ToDateTime(rdtp_fromdate.SelectedDate);
_obj_smhr_courses.EMPORGSPNSRCRS_TODATE = Convert.ToDateTime(rdtp_todate.SelectedDate);
if (FUpload.HasFile)
{
string filename = Convert.ToString(FUpload.FileName.Trim().Replace("'", "''"));
if (!string.IsNullOrEmpty(filename))
{
FUpload.PostedFile.SaveAs(System.IO.Path.Combine(Server.MapPath("~/EmpUploads/DocUploads/"), "Courses" + "_" + BUFilter1.EmployeeID + "_" + filename));
}
_obj_smhr_courses.EMPORGSPNSRCRS_CERTDOCNAME = filename;
_obj_smhr_courses.EMPORGSPNSRCRS_CERTDOCUPLOAD = "~/EmpUploads/DocUploads/" + "Courses" + "_" + BUFilter1.EmployeeID + "_" + filename;
}
_obj_smhr_courses.LASTMDFBY = Convert.ToInt32(Session["USER_ID"]); // ### Need to Get the Session
_obj_smhr_courses.LASTMDFDATE = DateTime.Now;
_obj_smhr_courses.OPERATION = operation.Update;
bool status = BLL.set_orgspnsdcourses(_obj_smhr_courses);
if (status == true)
{
Pms_Bll.ShowMessage(this, "Course Updated Succesfully");
loadgrid();
btn_Update.Visible = true;
RM_EmpOrgSpnsCoursesform.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_EmpOrgSpnsdCourses", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}
protected void lnk_Edit_Commnad(object sender, CommandEventArgs e)
{
try
{
clearfields();
_obj_smhr_courses = new SMHR_EMPORGSPNSCOURSES();
_obj_smhr_courses.OPERATION = operation.Update;
_obj_smhr_courses.EMPORGSPNSRCRS_ID = Convert.ToInt32(e.CommandArgument);
DataTable DT = BLL.get_orgspnsdcourses(_obj_smhr_courses);
if (DT.Rows.Count != 0)
{
lbl_id.Text = Convert.ToString(DT.Rows[0]["EMPORGSPNSRCRS_ID"]);
BUFilter1.BusinessUnitID = Convert.ToInt32(DT.Rows[0]["EMPORGSPNSRCRS_BUSINESSUNIT"]);
BUFilter1.DirectorateID = Convert.ToInt32(DT.Rows[0]["EMPORGSPNSRCRS_DIRECTORATEID"]);
BUFilter1.DepartmentID = Convert.ToInt32(DT.Rows[0]["EMPORGSPNSRCRS_DEPARTMENTID"]);
BUFilter1.EmployeeID = Convert.ToInt32(DT.Rows[0]["EMPORGSPNSRCRS_EMPID"]);
txtbx_CourseName.Text = Pms_Bll.ReplaceQuote(Convert.ToString(DT.Rows[0]["EMPORGSPNSRCRS_COURSENAME"]));
txtbx_Outcome.Text = Pms_Bll.ReplaceQuote(Convert.ToString(DT.Rows[0]["EMPORGSPNSRCRS_OUTCOME"]));
rdtp_fromdate.SelectedDate = Convert.ToDateTime(DT.Rows[0]["EMPORGSPNSRCRS_FROMDATE"]);
rdtp_todate.SelectedDate = Convert.ToDateTime(DT.Rows[0]["EMPORGSPNSRCRS_TODATE"]);
RM_EmpOrgSpnsCoursesform.SelectedIndex = 1;
btn_SAVE.Visible = true;
btn_SAVE.Visible = false;
btn_Update.Visible = true;
txtbx_Outcome.Enabled = true;
txtbx_CourseName.Enabled = true;
BUFilter1.DisableBusinessUnit = false;
BUFilter1.DisableDirectorate = false;
BUFilter1.DisableDepartment = false;
BUFilter1.DisableEmployee = false;
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_EmpOrgSpnsdCourses", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}
