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