public static bool set_Inspection_Area(SMHR_INSPECTION_AREA _obj_smhr_Inspection_Area)
{
bool status = false;
if (_obj_smhr_Inspection_Area.OPERATION == operation.Insert)
{
if (ExecuteNonQuery("EXEC USP_SMHR_INSPECTION_AREA @OPERATION = 'INSERT',@INSPECTION_AREA_SCHEDULE_ID = " + _obj_smhr_Inspection_Area.INSPECTION_AREA_SCHEDULE_ID +
" ,@AREA_ID=" + _obj_smhr_Inspection_Area.AREA_ID +
" ,@INSPECTION_AREA_ISCOMPLIANT=" + Convert.ToBoolean(_obj_smhr_Inspection_Area.INSPECTION_AREA_ISCOMPLIANT) +
" ,@INSPECTION_AREA_COMMENTS ='" + Convert.ToString(_obj_smhr_Inspection_Area.INSPECTION_AREA_COMMENTS) +
"' ,@INSPECTION_AREA_CREATED_BY =" + Convert.ToInt32(_obj_smhr_Inspection_Area.INSPECTION_AREA_CREATED_BY) +
" ,@INSPECTION_AREA_CREATEDDATE ='" + Convert.ToDateTime(_obj_smhr_Inspection_Area.INSPECTION_AREA_CREATEDDATE) + "'"))
{
status = true;
}
else
{
status = false;
}
}
if (_obj_smhr_Inspection_Area.OPERATION == operation.Update)
{
if (ExecuteNonQuery("EXEC USP_SMHR_INSPECTION_AREA @OPERATION = 'UPDATE',@INSPECTION_AREA_SCHEDULE_ID = " + _obj_smhr_Inspection_Area.INSPECTION_AREA_SCHEDULE_ID +
",@AREA_ID=" + _obj_smhr_Inspection_Area.AREA_ID +
" ,@INSPECTION_AREA_ISCOMPLIANT=" + Convert.ToBoolean(_obj_smhr_Inspection_Area.INSPECTION_AREA_ISCOMPLIANT) +
" ,@INSPECTION_AREA_COMMENTS='" + Convert.ToString(_obj_smhr_Inspection_Area.INSPECTION_AREA_COMMENTS) +
"' ,@INSPECTION_AREA_MODIFIED_BY =" + Convert.ToInt32(_obj_smhr_Inspection_Area.INSPECTION_AREA_MODIFIED_BY) +
" ,@INSPECTION_AREA_MODIFIEDDATE ='" + Convert.ToDateTime(_obj_smhr_Inspection_Area.INSPECTION_AREA_MODIFIEDDATE) + "'"))
{
status = true;
}
else
{
status = false;
}
}
if (_obj_smhr_Inspection_Area.OPERATION == operation.ISCOMPLIANT)
{
if (ExecuteNonQuery("EXEC USP_SMHR_INSPECTION_AREA @OPERATION = 'ISCOMPLIANT',@INSPECTION_AREA_SCHEDULE_ID = " + _obj_smhr_Inspection_Area.INSPECTION_AREA_SCHEDULE_ID +
",@AREA_ID=" + _obj_smhr_Inspection_Area.AREA_ID +
" ,@INSPECTION_AREA_ISCOMPLIANT=" + Convert.ToBoolean(_obj_smhr_Inspection_Area.INSPECTION_AREA_ISCOMPLIANT) +
" ,@INSPECTION_AREA_COMMENTS='" + Convert.ToString(_obj_smhr_Inspection_Area.INSPECTION_AREA_COMMENTS) +
"' ,@INSPECTION_AREA_MODIFIED_BY =" + Convert.ToInt32(_obj_smhr_Inspection_Area.INSPECTION_AREA_MODIFIED_BY) +
" ,@INSPECTION_AREA_MODIFIEDDATE ='" + Convert.ToDateTime(_obj_smhr_Inspection_Area.INSPECTION_AREA_MODIFIEDDATE) + "'"))
{
status = true;
}
else
{
status = false;
}
}
return(status);
}
public static bool delete_Inspection_Area(SMHR_INSPECTION_AREA _obj_smhr_Inspection_Area)
{
bool status = false;
if (ExecuteNonQuery("EXEC USP_SMHR_INSPECTION_AREA @OPERATION = 'DELETEAREADETAILS',@INSPECTION_AREA_SCHEDULE_ID = " + _obj_smhr_Inspection_Area.INSPECTION_AREA_SCHEDULE_ID))
{
status = true;
}
else
{
status = false;
}
return(status);
}
//protected void LoadInspectionNames(int empID)
//{
// try
// {
// if (Convert.ToInt32(Session["EMP_ID"]) != 0)
// {
// _obj_smhr_Inspection_Schedule = new SMHR_INSPECTION_SCHEDULE();
// _obj_smhr_Inspection_Schedule.INSPECTION_SCHEDULE_ASSIGNED_TO = empID;
// DataTable dtInspNames = BLL.GetInspectionsbyEmpID(_obj_smhr_Inspection_Schedule);
// if (dtInspNames.Rows.Count > 0)
// {
// rad_InspectedBy.DataSource = dtInspNames;
// rad_InspectedBy.DataTextField = "INSPECTION_NAME";
// rad_InspectedBy.DataValueField = "INSPECTION_ID";
// rad_InspectedBy.DataBind();
// }
// rad_InspectedBy.Items.Insert(0, new Telerik.Web.UI.RadComboBoxItem("Select Inspeciton Name"));
// }
// }
// catch (Exception ex)
// {
// throw ex;
// }
//}
protected void btn_Submit_Click(object sender, EventArgs e)
{
try
{
int count = 0;
bool status = false;
_obj_smhr_inspection_area = new SMHR_INSPECTION_AREA();
RadioButtonList radbuttonlist;
RadTextBox radtextbox;
Label lblAreaID;
Label lbl_IA_ID;
CheckBox chkSelect;
RequiredFieldValidator rfv_IsCompliant;
RequiredFieldValidator rfv_Comments;
for (int index = 0; index <= Rg_Areas_To_Inspected.Items.Count - 1; index++)
{
radbuttonlist = Rg_Areas_To_Inspected.Items[index].FindControl("rbl_IsCompliant") as RadioButtonList;
radtextbox = Rg_Areas_To_Inspected.Items[index].FindControl("Comments") as RadTextBox;
lblAreaID = Rg_Areas_To_Inspected.Items[index].FindControl("lbl_Area_Id") as Label;
lbl_IA_ID = Rg_Areas_To_Inspected.Items[index].FindControl("lbl_IA_ID") as Label;
chkSelect = Rg_Areas_To_Inspected.Items[index].FindControl("chk_Choose") as CheckBox;
rfv_IsCompliant = Rg_Areas_To_Inspected.Items[index].FindControl("rfv_IsCompliant") as RequiredFieldValidator;
rfv_Comments = Rg_Areas_To_Inspected.Items[index].FindControl("rfv_Comments") as RequiredFieldValidator;
_obj_smhr_inspection_area.OPERATION = operation.ISCOMPLIANT;
//if (chkSelect.Checked)
if ((chkSelect.Checked) && (Rg_Areas_To_Inspected.Items[index].Enabled == true))
{
count++;
rfv_IsCompliant.Enabled = true;
rfv_Comments.Enabled = true;
if (radbuttonlist.SelectedIndex > -1)
{
_obj_smhr_inspection_area.OPERATION = operation.FeedBack;
_obj_smhr_inspection_area.AREA_ID = Convert.ToInt32(lblAreaID.Text);
_obj_smhr_inspection_area.INSPECTION_AREA_ID = Convert.ToInt32(lbl_IA_ID.Text);
_obj_smhr_inspection_area.INSPECTION_AREA_MODIFIED_BY = Convert.ToInt32(Session["USER_ID"]);
_obj_smhr_inspection_area.INSPECTION_AREA_MODIFIEDDATE = DateTime.Now;
if (radbuttonlist.SelectedItem.Text == "Yes")
{
_obj_smhr_inspection_area.INSPECTION_AREA_ISCOMPLIANT = true;
}
else if (radbuttonlist.SelectedItem.Text == "No")
{
_obj_smhr_inspection_area.INSPECTION_AREA_ISCOMPLIANT = false;
}
if (Convert.ToString(radtextbox.Text) != string.Empty)
{
_obj_smhr_inspection_area.INSPECTION_AREA_COMMENTS = Convert.ToString(radtextbox.Text);
}
else
{
BLL.ShowMessage(this, "Please Enter Comments");
radtextbox.Focus();
return;
}
//status = BLL.set_Inspection_Area(_obj_smhr_inspection_area);
status = BLL.set_Inspection_Area_FeedBack(_obj_smhr_inspection_area);
}
else
{
BLL.ShowMessage(this, "Please Choose Area Name");
return;
}
}
}
if (count == 0)
{
BLL.ShowConfirmMessage(this, "Please Choose atleast one area");
return;
}
if (status)
{
BLL.ShowMessage(this, "Inspection Area Information Successfully Saved");
}
ReLoadGrid(Convert.ToInt32(ViewState["inspID"]));
rad_InspectionName.SelectedValue = Convert.ToString(ViewState["inspID"]);
}
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_ALLINSPECTION_SCHEDULEAREA(SMHR_INSPECTION_AREA _obj_smhr_Inspection_Schedule)
{
return(ExecuteQuery("EXEC USP_SMHR_INSPECTION_AREA @Operation = 'GET_ALLINSPECTION_SCHEDULEAREA'"));
}
public static DataTable get_INSPECTION_SCHEDULEAREA(SMHR_INSPECTION_AREA _obj_smhr_Inspection_Schedule)
{
return(ExecuteQuery("EXEC USP_SMHR_INSPECTION_AREA @Operation = 'GET_INSPECTION_SCHEDULEAREA'" + ", @INSPECTION_AREA_SCHEDULE_ID=" + _obj_smhr_Inspection_Schedule.INSPECTION_AREA_SCHEDULE_ID));
}
