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"); } }