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