protected void LoadInspectedBy() { try { if (Convert.ToInt32(Session["EMP_ID"]) == 0) { _obj_smhr_Inspection_Schedule = new SMHR_INSPECTION_SCHEDULE(); _obj_smhr_Inspection_Schedule.LOGIN_EMP_ID = 0; DataTable dt_InspectedBy = BLL.get_InspectedBy(_obj_smhr_Inspection_Schedule); rad_InspectedBy.DataSource = dt_InspectedBy; rad_InspectedBy.DataTextField = "EMP_NAME"; rad_InspectedBy.DataValueField = "EMP_ID"; rad_InspectedBy.DataBind(); rad_InspectedBy.Items.Insert(0, new Telerik.Web.UI.RadComboBoxItem("Select")); } else { _obj_smhr_Inspection_Schedule = new SMHR_INSPECTION_SCHEDULE(); _obj_smhr_Inspection_Schedule.LOGIN_EMP_ID = Convert.ToInt32(Session["EMP_ID"]); DataTable dt_InspectedBy = BLL.get_InspectedBy(_obj_smhr_Inspection_Schedule); rad_InspectedBy.DataSource = dt_InspectedBy; rad_InspectedBy.DataTextField = "EMP_NAME"; rad_InspectedBy.DataValueField = "EMP_ID"; rad_InspectedBy.DataBind(); rad_InspectedBy.Items.Insert(0, new Telerik.Web.UI.RadComboBoxItem("Select")); rad_InspectedBy.SelectedValue = Convert.ToString(dt_InspectedBy.Rows[0]["Emp_Id"]); } } catch (Exception ex) { SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_InspectionIsCompliant", ex.StackTrace, DateTime.Now); Response.Redirect("~/Frm_ErrorPage.aspx"); } }
protected void LoadGridbyInsID(int inspID) { try { _obj_smhr_Inspection_Schedule = new SMHR_INSPECTION_SCHEDULE(); _obj_smhr_Inspection_Schedule.INSPECTION_SCHEDULE_INSPECTION_ID = inspID; _obj_smhr_Inspection_Schedule.INSPECTION_SCHEDULE_ASSIGNED_TO = Convert.ToInt32(Session["EMP_ID"]); _obj_smhr_Inspection_Schedule.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]); DataTable dt_getInspection = BLL.GET_INSPECTIONSCHEDULE_ISCOMPLIANT(_obj_smhr_Inspection_Schedule); if (dt_getInspection != null) { if (dt_getInspection.Rows.Count > 0) { Rg_Areas_To_Inspected.DataSource = dt_getInspection; //Rg_Areas_To_Inspected.DataBind(); rdtp_FromDate.SelectedDate = Convert.ToDateTime(dt_getInspection.Rows[0]["INSPECTION_SCHEDULE_FROMDATE"].ToString()); rdtp_ToDate.SelectedDate = Convert.ToDateTime(dt_getInspection.Rows[0]["INSPECTION_SCHEDULE_TODATE"].ToString()); rtp_FromTime.SelectedDate = Convert.ToDateTime(dt_getInspection.Rows[0]["INSPECTION_SCHEDULE_FROMTIME"].ToString()); rtp_ToTime.SelectedDate = Convert.ToDateTime(dt_getInspection.Rows[0]["INSPECTION_SCHEDULE_TOTIME"].ToString()); divControls.Visible = true; btn_Submit.Visible = true; btn_Cancel.Visible = true; //LoadGrid(); } } } catch (Exception ex) { SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_InspectionIsCompliant", ex.StackTrace, DateTime.Now); Response.Redirect("~/Frm_ErrorPage.aspx"); } }
public static DataTable Get_MainInspectionsIds(SMHR_INSPECTION_SCHEDULE _obj_smhr_Inspection_Schedule, int inspID) { return(ExecuteQuery("EXEC USP_SMHR_INSPECTION_SCHEDULE @Operation = 'GET_INSPECIONDATA_FINAL'" + ",@INSPECTION_SCHEDULE_ASSIGNED_TO = " + _obj_smhr_Inspection_Schedule.LOGIN_EMP_ID + ",@ORG_ID = " + _obj_smhr_Inspection_Schedule.ORGANISATION_ID + ",@INSPECTION_SCHEDULE_INSPECTION_ID = " + inspID)); }
public static DataTable Get_Past_Inspection_Data(SMHR_INSPECTION_SCHEDULE _obj_smhr_Inspection_Schedule, int empID) { return(ExecuteQuery("EXEC USP_SMHR_INSPECTION_SCHEDULE @Operation = 'GET_PAST_INSPECTION_DATA'" + ", @INSPECTION_SCHEDULE_FROMDATE='" + _obj_smhr_Inspection_Schedule.INSPECTION_SCHEDULE_FROMDATE + "',@INSPECTION_SCHEDULE_TODATE='" + _obj_smhr_Inspection_Schedule.INSPECTION_SCHEDULE_TODATE + "',@EMP_ID=" + empID + " ,@ORG_ID=" + _obj_smhr_Inspection_Schedule.ORGANISATION_ID)); }
private void ReLoadGrid(int inspID) { try { int rowCount = 0; _obj_smhr_Inspection_Schedule = new SMHR_INSPECTION_SCHEDULE(); _obj_smhr_Inspection_Schedule.INSPECTION_SCHEDULE_INSPECTION_ID = inspID; _obj_smhr_Inspection_Schedule.INSPECTION_SCHEDULE_ASSIGNED_TO = Convert.ToInt32(Session["EMP_ID"]); _obj_smhr_Inspection_Schedule.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]); DataTable dt_getInspection = BLL.GET_INSPECTIONSCHEDULE_ISCOMPLIANT(_obj_smhr_Inspection_Schedule); if (dt_getInspection.Rows.Count > 0) { Rg_Areas_To_Inspected.DataSource = dt_getInspection; } Rg_Areas_To_Inspected.DataBind(); for (int i = 0; i < dt_getInspection.Rows.Count; i++) { string isSelect = Convert.ToString(dt_getInspection.Rows[i]["INSPECTION_AREA_ISCOMPLIANT"]); string isComent = Convert.ToString(dt_getInspection.Rows[i]["INSPECTION_AREA_COMMENTS"]); if ((isSelect == string.Empty) && (isComent == string.Empty)) { rowCount++; } } //for (int index = 0; index <= Rg_Areas_To_Inspected.Items.Count - 1; index++) //{ // CheckBox chkSelect = Rg_Areas_To_Inspected.Items[index].FindControl("chk_Choose") as CheckBox; // if ((chkSelect.Checked) && (Rg_Areas_To_Inspected.Items[index].Enabled == true)) // rowCount++; //} if (rowCount > 0) { btn_Submit.Enabled = true; } else { btn_Submit.Enabled = false; } } catch (Exception ex) { SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_InspectionIsCompliant", ex.StackTrace, DateTime.Now); Response.Redirect("~/Frm_ErrorPage.aspx"); } }
private void LoadGrid() { try { _obj_smhr_inspection_schedule = new SMHR_INSPECTION_SCHEDULE(); dtInspectionGrid = new DataTable(); _obj_smhr_inspection_schedule.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]); if (rdtp_FromDate.SelectedDate != null) { _obj_smhr_inspection_schedule.INSPECTION_SCHEDULE_FROMDATE = Convert.ToDateTime(rdtp_FromDate.SelectedDate); } else { BLL.ShowMessage(this, "Please Select From Date"); rdtp_FromDate.Focus(); } if (rdtp_ToDate.SelectedDate != null) { _obj_smhr_inspection_schedule.INSPECTION_SCHEDULE_TODATE = Convert.ToDateTime(rdtp_ToDate.SelectedDate); } else { BLL.ShowMessage(this, "Please Select To Date"); rdtp_ToDate.Focus(); } empID = Convert.ToInt32(Session["EMP_ID"]); if ((empID != 0) && ((rdtp_FromDate.SelectedDate != null)) && ((rdtp_ToDate.SelectedDate != null))) { dtInspectionGrid = BLL.Get_Past_Inspection_Data(_obj_smhr_inspection_schedule, empID); } else { BLL.ShowMessage(this, "There is No Employee to show Records.."); return; } Rg_Areas_To_Inspected.DataSource = dtInspectionGrid; Rg_Areas_To_Inspected.DataBind(); } catch (Exception ex) { SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_PastInspections", ex.StackTrace, DateTime.Now); Response.Redirect("~/Frm_ErrorPage.aspx"); } }
protected void LoadInspectionsWhileSubmitting() { try { _obj_smhr_Inspection_Schedule = new SMHR_INSPECTION_SCHEDULE(); _obj_smhr_Inspection_Schedule.LOGIN_EMP_ID = Convert.ToInt32(Session["EMP_ID"]); _obj_smhr_Inspection_Schedule.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]); //DataTable dt_FinalInspectionValues = BLL.Get_FinalInspectionsData(_obj_smhr_Inspection_Schedule, finalInspIDs); } catch (Exception ex) { SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_InspectionIsCompliant", ex.StackTrace, DateTime.Now); Response.Redirect("~/Frm_ErrorPage.aspx"); } }
protected void LoadInspections() { try { rad_InspectionName.Items.Clear(); string finalInspIDs = string.Empty; _obj_smhr_Inspection_Schedule = new SMHR_INSPECTION_SCHEDULE(); if (Convert.ToInt32(Session["EMP_ID"]) == 0) { _obj_smhr_Inspection_Schedule.OPERATION = operation.GET_INSPECTIONS_ASSIGNEDTO; _obj_smhr_Inspection_Schedule.LOGIN_EMP_ID = 0; DataTable dt_Inspections = BLL.get_AllInspectionSchedules(_obj_smhr_Inspection_Schedule); rad_InspectionName.DataSource = dt_Inspections; rad_InspectionName.DataTextField = "INSPECTION_NAME"; rad_InspectionName.DataValueField = "INSPECTION_ID"; rad_InspectionName.DataBind(); rad_InspectionName.Items.Insert(0, new Telerik.Web.UI.RadComboBoxItem("Select")); } else { //Commented by Eshwar_Dev on 20131116 due to change of Inspecitons to load below grid _obj_smhr_Inspection_Schedule.LOGIN_EMP_ID = Convert.ToInt32(Session["EMP_ID"]); _obj_smhr_Inspection_Schedule.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]); DataTable dt_Inspections_InspectedBy = BLL.get_Inspections_InspectedBy(_obj_smhr_Inspection_Schedule); //if (Convert.ToInt32(dt_Inspections_InspectedBy.Rows.Count) > 0) //{ for (int i = 0; i < dt_Inspections_InspectedBy.Rows.Count; i++) { int inspID = Convert.ToInt32(dt_Inspections_InspectedBy.Rows[i]["INSPECTION_SCHEDULE_INSPECTION_ID"]); DataTable dt_GetInspIDsforRecords = BLL.Get_MainInspectionsIds(_obj_smhr_Inspection_Schedule, inspID); //if (Convert.ToInt32(dt_GetInspIDsforRecords.Rows.Count) > 0) //{ for (int j = 0; j < dt_GetInspIDsforRecords.Rows.Count; j++) { finalInspIDs = finalInspIDs + Convert.ToString(inspID) + ","; } //} } //} if (finalInspIDs != string.Empty) { finalInspIDs = finalInspIDs.Remove(finalInspIDs.Length - 1); DataTable dt_FinalInspectionValues = BLL.Get_FinalInspectionsData(_obj_smhr_Inspection_Schedule, finalInspIDs); rad_InspectionName.DataSource = dt_FinalInspectionValues; rad_InspectionName.DataTextField = "INSPECTION_NAME"; rad_InspectionName.DataValueField = "INSPECTION_SCHEDULE_INSPECTION_ID"; rad_InspectionName.DataBind(); } rad_InspectionName.Items.Insert(0, new Telerik.Web.UI.RadComboBoxItem("Select")); //rad_InspectionName.Enabled = false; //LoadGrid(); //LoadInspectionNames(Convert.ToInt32(Session["EMP_ID"])); } } catch (Exception ex) { SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_InspectionIsCompliant", ex.StackTrace, DateTime.Now); Response.Redirect("~/Frm_ErrorPage.aspx"); } }
public static DataTable get_Identity_value(SMHR_INSPECTION_SCHEDULE _obj_smhr_Inspection_schedule) { return(ExecuteQuery("EXEC USP_SMHR_INSPECTION_SCHEDULE @Operation = 'GETIDENTITY',@INSPECTION_SCHEDULE_ASSIGNED_TO='" + _obj_smhr_Inspection_schedule.INSPECTION_SCHEDULE_ASSIGNED_TO + "'" + ",@INSPECTION_SCHEDULE_FROMDATE='" + _obj_smhr_Inspection_schedule.INSPECTION_SCHEDULE_FROMDATE + "',@INSPECTION_SCHEDULE_TODATE='" + _obj_smhr_Inspection_schedule.INSPECTION_SCHEDULE_TODATE + "'")); }
public static DataTable GET_INSPECTIONS_ASSIGNEDTO(SMHR_INSPECTION_SCHEDULE _obj_smhr_Inspection_schedule) { return(ExecuteQuery("EXEC USP_SMHR_INSPECTION_MASTER @Operation = 'GET_INSPECTIONS_ASSIGNEDTO'" + ", @EMP_ID=" + _obj_smhr_Inspection_schedule.LOGIN_EMP_ID)); }
public static DataTable get_InspectedBy(SMHR_INSPECTION_SCHEDULE _obj_smhr_Inspection_schedule) { return(ExecuteQuery("EXEC USP_SMHR_INSPECTION_SCHEDULE @Operation = 'GET_INSPECTEDBY'" + ", @EMP_ID=" + _obj_smhr_Inspection_schedule.LOGIN_EMP_ID)); }
public static DataTable checkInspectionScheduleexistsbyBuID(SMHR_INSPECTION_SCHEDULE _obj_smhr_inspection_schedule) { return(ExecuteQuery("EXEC USP_SMHR_INSPECTION_SCHEDULE @Operation = 'CHECKEXISTS_BY_BU_ID',@INSPECTION_SCHEDULE_BU_ID = '" + _obj_smhr_inspection_schedule.BUID + "'" + ",@INSPECTION_SCHEDULE_INSPECTION_ID=" + _obj_smhr_inspection_schedule.INSPECTION_SCHEDULE_INSPECTION_ID)); }
public static DataTable Get_FinalInspectionsData(SMHR_INSPECTION_SCHEDULE _obj_smhr_Inspection_Schedule, string inspIDs) { return(ExecuteQuery("EXEC USP_SMHR_INSPECTION_SCHEDULE @Operation = 'GET_INSPECTIONS_GRID_DATA_FINAL'" + ",@INSPECTION_SCHEDULE_ASSIGNED_TO=" + _obj_smhr_Inspection_Schedule.LOGIN_EMP_ID + ",@INSPECTION_IDS='" + inspIDs + "'")); }
public static DataTable get_AllInspectionSchedules2(SMHR_INSPECTION_SCHEDULE _obj_smhr_Inspection_Schedule) { return(ExecuteQuery("EXEC USP_SMHR_INSPECTION_SCHEDULE @Operation = 'GET_ALLINSPECTIONSSCHEDULES2'" + ", @EMP_ID=" + _obj_smhr_Inspection_Schedule.LOGIN_EMP_ID + ",@INSPECTION_SCHEDULE_INSPECTION_ID=" + _obj_smhr_Inspection_Schedule.INSPECTION_SCHEDULE_INSPECTION_ID)); }