/// <summary> /// Insert incident record /// </summary> /// <param name="_obj_Smhr_Grievance"></param> /// <returns></returns> public static bool record_Incident(SMHR_GRIEVANCE _obj_Smhr_Grievance) { bool status = false; switch (_obj_Smhr_Grievance.OPERATION) { case operation.Insert: if (ExecuteNonQuery("EXEC USP_SMHR_GRIEVANCE @Operation = 'Insert', @GRIEVANCE_ID='" + _obj_Smhr_Grievance.GRIEVANCE_ID + "', @GRIEVANCE_ORGANISATION_ID = '" + _obj_Smhr_Grievance.ORGANISATION_ID + "', @GRIEVANCE_REPORTEDBY='" + _obj_Smhr_Grievance.GRIEVANCE_REPORTEDBY + "', @GRIEVANCE_REPORTEDON='" + _obj_Smhr_Grievance.GRIEVANCE_REPORTEDON + "', @GRIEVANCE_INCIDENTID='" + Convert.ToString(_obj_Smhr_Grievance.GRIEVANCE_INCIDENTID) + " ', @GRIEVANCE_INCIDENT='" + Convert.ToString(_obj_Smhr_Grievance.GRIEVANCE_INCIDENT) + "', @GRIEVANCE_INCIDENTTYPE_ID='" + _obj_Smhr_Grievance.GRIEVANCE_INCIDENTTYPE_ID + "', @GRIEVANCE_REPORTEDDATE='" + _obj_Smhr_Grievance.GRIEVANCE_REPORTEDDATE + "', @GRIEVANCE_INCIDENTDESCRIPTION='" + _obj_Smhr_Grievance.GRIEVANCE_INCIDENTDESCRIPTION + "', @GRIEVANCE_COMMITTEEID='" + _obj_Smhr_Grievance.GRIEVANCE_COMMITTEEID + " ', @GRIEVANCE_CREATEDBY= '" + Convert.ToString(_obj_Smhr_Grievance.CREATEDBY) + " ', @GRIEVANCE_CREATEDDATE='" + _obj_Smhr_Grievance.CREATEDDATE.ToString("MM/dd/yyyy") + "', @GRIEVANCE_LASTMDFBY ='" + Convert.ToString(_obj_Smhr_Grievance.LASTMDFBY) + "' , @GRIEVANCE_LASTMDFDATE ='" + _obj_Smhr_Grievance.LASTMDFDATE.ToString("MM/dd/yyyy") + "'")) { status = true; } else { status = false; } break; case operation.Update: if (ExecuteNonQuery("EXEC USP_SMHR_GRIEVANCE @Operation = 'Update', @GRIEVANCE_ID='" + _obj_Smhr_Grievance.GRIEVANCE_ID + "', @GRIEVANCE_ORGANISATION_ID = '" + _obj_Smhr_Grievance.ORGANISATION_ID + "', @GRIEVANCE_INCIDENTDESCRIPTION='" + _obj_Smhr_Grievance.GRIEVANCE_INCIDENTDESCRIPTION + "', @GRIEVANCE_LASTMDFBY ='" + Convert.ToString(_obj_Smhr_Grievance.LASTMDFBY) + "' , @GRIEVANCE_LASTMDFDATE ='" + _obj_Smhr_Grievance.LASTMDFDATE.ToString("MM/dd/yyyy") + "'")) { status = true; } else { status = false; } break; default: break; } return(status); }
private DataTable LoadIncidentGrid() { SMHR_GRIEVANCE _obj_Smhr_Grievance = new SMHR_GRIEVANCE(); try { _obj_Smhr_Grievance.GRIEVANCE_ID = 0; _obj_Smhr_Grievance.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]); _obj_Smhr_Grievance.OPERATION = operation.Select; } catch (Exception ex) { SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "RecordIncident", ex.StackTrace, DateTime.Now); Response.Redirect("~/Frm_ErrorPage.aspx"); } return(BLL.get_Incidents(_obj_Smhr_Grievance)); }
/// <summary> /// Get Recorded Incidents /// </summary> /// <param name="_obj_Smhr_Grievance"></param> /// <returns></returns> public static DataTable get_Incidents(SMHR_GRIEVANCE _obj_Smhr_Grievance) { if (_obj_Smhr_Grievance.OPERATION == operation.Select) { if (_obj_Smhr_Grievance.GRIEVANCE_ID.ToString() == "0") { return(ExecuteQuery("EXEC USP_SMHR_GRIEVANCE @Operation = 'select',@GRIEVANCE_ORGANISATION_ID = '" + _obj_Smhr_Grievance.ORGANISATION_ID + "'")); } else { return(ExecuteQuery("EXEC USP_SMHR_GRIEVANCE @Operation = 'select', @GRIEVANCE_ID =" + Convert.ToString(_obj_Smhr_Grievance.GRIEVANCE_ID) + ",@GRIEVANCE_ORGANISATION_ID = '" + _obj_Smhr_Grievance.ORGANISATION_ID + "'")); } } else if (_obj_Smhr_Grievance.OPERATION == operation.Check) { return(ExecuteQuery("EXEC USP_SMHR_GRIEVANCE @Operation = 'Check', @GRIEVANCE_INCIDENTTYPE_ID =" + Convert.ToString(_obj_Smhr_Grievance.GRIEVANCE_INCIDENTTYPE_ID) + ",@GRIEVANCE_ORGANISATION_ID = '" + _obj_Smhr_Grievance.ORGANISATION_ID + "'")); } else { return(new DataTable()); } }
protected void btn_Save_Click(object sender, EventArgs e) { try { SMHR_GRIEVANCE _obj_Smhr_Grievance = new SMHR_GRIEVANCE(); _obj_Smhr_Grievance.GRIEVANCE_INCIDENT = rcmb_Incident.SelectedItem.Text; _obj_Smhr_Grievance.GRIEVANCE_INCIDENTID = rtxt_IncidentID.Text; _obj_Smhr_Grievance.GRIEVANCE_INCIDENTTYPE_ID = Convert.ToInt32(rcmb_IncidentType.SelectedValue); _obj_Smhr_Grievance.GRIEVANCE_REPORTEDDATE = rdp_ReportedDate.SelectedDate; _obj_Smhr_Grievance.GRIEVANCE_INCIDENTDESCRIPTION = rtxt_Description.Text; if (Convert.ToString(rcmb_ReportedByEmployee.SelectedValue) == string.Empty) { BLL.ShowMessage(this, "Plrase select Complaint By clearly"); return; } else { _obj_Smhr_Grievance.GRIEVANCE_REPORTEDBY = Convert.ToInt32(rcmb_ReportedByEmployee.SelectedValue); } if (Convert.ToString(rcmb_ReportedOnEmployee.SelectedValue) == string.Empty) { BLL.ShowMessage(this, "Plrase select Complaint On clearly"); return; } else { _obj_Smhr_Grievance.GRIEVANCE_REPORTEDON = Convert.ToInt32(rcmb_ReportedOnEmployee.SelectedValue); } if ((Convert.ToString(rcmb_ReportedByEmployee.SelectedValue) != string.Empty) && (Convert.ToString(rcmb_ReportedOnEmployee.SelectedValue) != string.Empty)) { if ((Convert.ToString(rcmb_ReportedByEmployee.SelectedValue)) == (Convert.ToString(rcmb_ReportedOnEmployee.SelectedValue))) { BLL.ShowMessage(this, "Complaint By and Complaint On cannot be same"); return; } } _obj_Smhr_Grievance.GRIEVANCE_COMMITTEEID = Convert.ToInt32(rcmb_Committee.SelectedValue); _obj_Smhr_Grievance.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]); _obj_Smhr_Grievance.CREATEDBY = Convert.ToInt32(Session["USER_ID"]); // ### Need to Get the Session _obj_Smhr_Grievance.CREATEDDATE = DateTime.Now; _obj_Smhr_Grievance.LASTMDFBY = Convert.ToInt32(Session["USER_ID"]); // ### Need to Get the Session _obj_Smhr_Grievance.LASTMDFDATE = DateTime.Now; SMHR_EMPLOYEE _obj_employee = new SMHR_EMPLOYEE(); _obj_employee.EMP_ID = Convert.ToInt32(rcmb_ReportedOnEmployee.SelectedValue); _obj_employee.OPERATION = operation.Select; DataTable dt_employee = BLL.get_Employeedetail(_obj_employee); if (rdp_ReportedDate.SelectedDate < Convert.ToDateTime(dt_employee.Rows[0]["EMP_DOJ"])) { BLL.ShowMessage(this, "Report Date Should not be less than complaint On employee join date"); return; } switch (((Button)sender).ID.ToUpper()) { case "BTN_UPDATE": _obj_Smhr_Grievance.GRIEVANCE_ID = Convert.ToInt32(ViewState["GRIEVANCE_ID"]); _obj_Smhr_Grievance.GRIEVANCE_INCIDENTDESCRIPTION = rtxt_Description.Text; _obj_Smhr_Grievance.OPERATION = operation.Update; if (BLL.record_Incident(_obj_Smhr_Grievance)) { BLL.ShowMessage(this, "Record Complaint Updated Successfully"); } else { BLL.ShowMessage(this, "Record Complaint Not Updated"); } break; case "BTN_SAVE": _obj_Smhr_Grievance.OPERATION = operation.Insert; if (BLL.record_Incident(_obj_Smhr_Grievance)) { BLL.ShowMessage(this, "Record Complaint Saved Successfully"); } else { BLL.ShowMessage(this, "Record Complaint Not Saved"); } break; default: break; } Rm_CY_page.SelectedIndex = 0; Rg_RecordIncident.DataSource = LoadIncidentGrid(); Rg_RecordIncident.DataBind(); ViewState["GRIEVANCE_ID"] = null; Rm_CY_page.SelectedIndex = 0; // Response.Redirect("RecordIncident.aspx"); } catch (Exception ex) { SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "RecordIncident", ex.StackTrace, DateTime.Now); Response.Redirect("~/Frm_ErrorPage.aspx"); } }