public bool insertCustomAuditEntries(ComplianceAudit auditdata)
{
bool result = false;
ComplianceAuditHelper complianceAuditHelper = new ComplianceAuditHelper();
result = complianceAuditHelper.insertupdatecustomAuditentries(auditdata);
return(result);
}
public bool UpdatetAuditEntries(ComplianceAudit auditdata)
{
bool result = false;
ComplianceAuditHelper complianceAuditHelper = new ComplianceAuditHelper();
result = complianceAuditHelper.updateAuditentries(auditdata);
return(result);
}
private string bindBranchStatusACTReport(int BranchID, string status, int VendorID)
{
ComplianceAudit auditReport = new ComplianceAudit();
ReportHelper reportHelper = new ReportHelper();
DataSet dsBranchReport = reportHelper.getComplianceStatusBranchACTAuditReport(BranchID, status, VendorID);
UtilityHelper utilityHelper = new UtilityHelper();
dsBranchReport = utilityHelper.ConvertNullsToEmptyString(dsBranchReport);
string xmlBranchReport = dsBranchReport.GetXml();
return(xmlBranchReport);
}
private string bindBranchStatusReport(int BranchID, string status, DateTime StartDate, DateTime EndDate, int ComplianceID, int VendorID)
{
ComplianceAudit auditReport = new ComplianceAudit();
ReportHelper reportHelper = new ReportHelper();
DataSet dsBranchReport = reportHelper.getBranchStatusComlianceAuditReport(BranchID, status, StartDate, EndDate, ComplianceID, VendorID);
UtilityHelper utilityHelper = new UtilityHelper();
dsBranchReport = utilityHelper.ConvertNullsToEmptyString(dsBranchReport);
string xmlBranchReport = dsBranchReport.GetXml();
return(xmlBranchReport);
}
private string bindNonCompliantBranchCount(int Org_Hier_ID, DateTime StartDate, DateTime EndDate, int ComplianceTypeID)
{
ComplianceAudit auditReport = new ComplianceAudit();
ReportHelper reportHelper = new ReportHelper();
DataSet dsBranchReport = reportHelper.getNonCompliantBranchCount(Org_Hier_ID, StartDate, EndDate, ComplianceTypeID);
UtilityHelper utilityHelper = new UtilityHelper();
dsBranchReport = utilityHelper.ConvertNullsToEmptyString(dsBranchReport);
string xmlBranchReport = dsBranchReport.GetXml();
return(xmlBranchReport);
}
private string bindBranchCount(int BranchID)
{
ComplianceAudit auditReport = new ComplianceAudit();
ReportHelper reportHelper = new ReportHelper();
DataSet dsBranchReport = reportHelper.getBranchCount(BranchID);
UtilityHelper utilityHelper = new UtilityHelper();
dsBranchReport = utilityHelper.ConvertNullsToEmptyString(dsBranchReport);
string xmlBranchReport = dsBranchReport.GetXml();
return(xmlBranchReport);
}
public ActionResult SubmitAudit(AuditentryViewModel model, string sdate, string edate)
{
AudService.AuditServiceClient client = new AudService.AuditServiceClient();
ComplianceAudit audit = new ComplianceAudit();
audit.Audit_Remarks = model.Overallremarks;
audit.Auditor_Id = Convert.ToInt32(Session["UserId"]);
audit.Org_Hier_Id = Convert.ToInt32(Session["BranchID"]);
audit.Vendor_Id = Convert.ToInt32(Session["Vendorid"]);
audit.Version = 1;
audit.Start_Date = Convert.ToDateTime(sdate);
audit.End_Date = Convert.ToDateTime(edate);
client.UpdatetAuditEntries(audit);
return(View());
}
public bool insertupdateAuditentries(ComplianceAudit audit, char Flag)
{
bool ComplianceAuditResult = false;
try
{
if (audit != null)
{
conn.Open();
MySqlCommand cmd = new MySqlCommand("sp_insertupdateComplianceAudit", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("p_Flag", Flag);
cmd.Parameters.AddWithValue("p_Compliance_Audit_ID", audit.Compliance_Audit_Id);
cmd.Parameters.AddWithValue("p_Xref_Comp_Type_Map_ID", audit.Xref_Comp_Type_Map_ID);
cmd.Parameters.AddWithValue("p_Org_Hier_ID", audit.Org_Hier_Id);
cmd.Parameters.AddWithValue("p_Auditor_ID", audit.Auditor_Id);
cmd.Parameters.AddWithValue("p_Audit_Followup_Date", audit.Audit_Followup_Date);
cmd.Parameters.AddWithValue("p_Audit_Remarks", audit.Audit_Remarks);
cmd.Parameters.AddWithValue("p_Is_Active", audit.Is_Active);
cmd.Parameters.AddWithValue("p_Version", audit.Version);
cmd.Parameters.AddWithValue("p_Compliance_Status", audit.Audit_Status);
cmd.Parameters.AddWithValue("p_Applicability", audit.Applicability);
cmd.Parameters.AddWithValue("p_Start_Date", audit.Start_Date);
cmd.Parameters.AddWithValue("p_End_Date", audit.End_Date);
cmd.Parameters.AddWithValue("p_Risk_Category", audit.Risk_Category);
cmd.Parameters.AddWithValue("p_Vendor_ID", audit.Vendor_Id);
cmd.Parameters.AddWithValue("p_Evidences", audit.Evidences);
cmd.Parameters.AddWithValue("p_Periodicity", audit.Periodicity);
int objcomplianceauditid = cmd.ExecuteNonQuery();
if (objcomplianceauditid > 0)
{
ComplianceAuditResult = true;
}
}
}
catch
{
throw;
}
finally
{
conn.Close();
}
return(ComplianceAuditResult);
}
public bool updateAuditentries(ComplianceAudit audit)
{
bool ComplianceAuditResult = false;
try
{
if (audit != null)
{
conn.Open();
MySqlCommand cmd = new MySqlCommand("sp_update_compliance_audit", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("p_Compliance_Audit_ID", audit.Compliance_Audit_Id);
cmd.Parameters.AddWithValue("p_Version", audit.Version);
cmd.Parameters.AddWithValue("p_Auditor_ID", audit.Auditor_Id);
cmd.Parameters.AddWithValue("p_Vendor_ID", audit.Vendor_Id);
cmd.Parameters.AddWithValue("p_Start_Date", audit.Start_Date);
cmd.Parameters.AddWithValue("p_End_Date", audit.End_Date);
cmd.Parameters.AddWithValue("p_Audit_Remarks", audit.Audit_Remarks);
cmd.Parameters.AddWithValue("p_Is_Active", audit.Is_Active);
int objcomplianceauditid = cmd.ExecuteNonQuery();
if (objcomplianceauditid > 0)
{
ComplianceAuditResult = true;
}
}
}
catch
{
throw;
}
finally
{
conn.Close();
}
return(ComplianceAuditResult);
}
public ActionResult addComplianceAudit(FormCollection formCollection, HttpPostedFileBase file, string submit)
{
if (ModelState.IsValid)
{
//AuditViewModel auditViewModel = new AuditViewModel();
//auditViewModel.complianceAudit = new ComplianceAudit();
//for(int i =0; i< formCollection.Count; i++ )
//{
// var str = formCollection["complianceAuditList[1].Audit_Status"];
//}
//DataTable dt = new DataTable();
//DataSet ds = new DataSet();
int counter = 0;
List <ComplianceAudit> auditdata = new List <ComplianceAudit>();
ComplianceAudit audit = null;
//foreach(var item in formCollection)
//{
//}
int key = formCollection.Count;
string str = Convert.ToString(key - 1);
int rulecount = Convert.ToInt32(Session["rulecount"]);
// int rulecount1 = Convert.ToInt32(formCollection[str]);
for (int index = 0; index < rulecount; index++)
//{
// if (formCollection[index].ToString().Contains("complianceAuditList"))
{
//if (formCollection[index].Contains("complianceAuditList"))
//{
audit = new ComplianceAudit();
AuditViewModel auditm = new AuditViewModel();
auditm.complianceAudit = new ComplianceAudit();
//string str = formCollection["complianceAuditList["+ counter + "].Audit_Status"];
// auditm.complianceAudit.Audit_Status = formCollection["complianceAuditList[" + counter + "].Audit_Status"];
audit.Audit_Status = formCollection["complianceAuditList[" + index + "].Audit_Status"];
audit.Audit_Date = Convert.ToDateTime(formCollection["complianceAuditList[" + index + "].Audit_Date"]);
audit.Audit_Remarks = formCollection["complianceAuditList[" + index + "].Audit_Remarks"];
audit.Penalty_nc = formCollection["complianceAuditList[" + index + "].Penalty_nc"];
audit.Compliance_Xref_Id = Convert.ToInt32(formCollection["complianceAuditList[" + index + "].Compliance_Xref_ID"]);
audit.Auditor_Id = Convert.ToInt32(Session["AuditorID"]);//1;// Convert.ToInt32(formCollection["complianceAuditList[" + counter + "].Auditor_ID"]);
if (file != null)
{
CommonController common = new CommonController();
audit.Audit_ArteFacts = Path.GetFileName(file.FileName);
string filePath = Path.Combine(Server.MapPath(ConfigurationManager.AppSettings["FilePath"].ToString()), Path.GetFileName(file.FileName));
string message = common.UploadFile(file, filePath);
// ModelState.AddModelError("org_hier.logo", message);
}
audit.Audit_ArteFacts = formCollection["complianceAuditList[" + index + "].Audit_ArteFacts"];
audit.Compliance_Audit_Id = Convert.ToInt32(formCollection["complianceAuditList[" + index + "].Compliance_Audit_Id"]);
// audit.Compliance_Options_Id = 1;// Convert.ToInt32(formCollection["complianceAuditList[" + counter + "].Compliance_Options_Id"]);
audit.Compliance_Schedule_Instance = Convert.ToInt32(formCollection["complianceAuditList[" + index + "].Compliance_Schedule_Instance"]);
// audit.Is_Active = Convert.ToBoolean(formCollection["complianceAuditList[" + counter + "].Compliance_Schedule_Instance"]);
//audit.Last_Update_dDate = Convert.ToDateTime(formCollection["complianceAuditList[" + counter + "].Compliance_Schedule_Instance"]);
audit.Org_Hier_Id = Convert.ToInt32(Session["ComplianceBranchID"]);// 17; // Convert.ToInt32(formCollection["complianceAuditList[" + counter + "].Compliance_Schedule_Instance"]);
audit.Reviewer_Comments = formCollection["complianceAuditList[" + index + "].Compliance_Schedule_Instance"];
audit.Reviewer_Id = Convert.ToInt32(formCollection["complianceAuditList[" + index + "].Compliance_Schedule_Instance"]);
audit.User_Id = 1; // Convert.ToInt32(formCollection["complianceAuditList[" + counter + "].Compliance_Schedule_Instance"]);
audit.Is_Active = true; //formCollection["complianceAuditList[" + index + "].Is_Active"];
audit.Version = Convert.ToInt32(formCollection["complianceAuditList[" + index + "].Compliance_Schedule_Instance"]);
switch (submit)
{
case "Save as Draft":
audit.Version = 0;
ViewBag.Message = "Saved as draft";
break;
case "Submit":
audit.Version = 1;
ViewBag.Message = "Subitted successfully";
break;
}
auditdata.Add(audit);
//counter++;
//}
}
bool result = false;
AuditService.AuditServiceClient auditServiceClient = new AuditService.AuditServiceClient();
string compliancedata = Convert.ToString(auditServiceClient.insertComplianceAudit(auditdata.ToArray()));
if (compliancedata != null)
{
result = true;
}
else
{
result = false;
}
}
return(View("View"));
}
public ActionResult addCompanyBranch()
{
string selectedcompanyid = "0";
int AuditorID = 1;
ComplianceAudit complianceAudit = new ComplianceAudit();
AuditService.AuditServiceClient auditServiceClient = new AuditService.AuditServiceClient();
List <AuditViewModel> auditViewModelsList = new List <AuditViewModel>();
AuditViewModel auditViewModel = new AuditViewModel();
string strxmlCompany = auditServiceClient.getAllCompanyBrnachAssignedtoAuditor(AuditorID);
DataSet dsCompany = new DataSet();
dsCompany.ReadXml(new StringReader(strxmlCompany));
auditViewModel.MappedCompany = new List <SelectListItem>();
auditViewModel.MappedCompany.Add(new SelectListItem {
Text = "--Select Company--", Value = "0"
});
if (dsCompany.Tables.Count > 0)
{
foreach (System.Data.DataRow row in dsCompany.Tables[0].Rows)
{
if (row["level"].ToString() == "2")
{
auditViewModel.MappedCompany.Add(new SelectListItem()
{
Text = row["Company_Name"].ToString(), Value = row["Org_Hier_ID"].ToString()
});
}
}
}
string strxmlBranch = auditServiceClient.getAllCompanyBrnachAssignedtoAuditor(AuditorID);
DataSet dsBranch = new DataSet();
dsBranch.ReadXml(new StringReader(strxmlBranch));
auditViewModel.MappedBranch = new List <SelectListItem>();
auditViewModel.MappedBranch.Add(new SelectListItem {
Text = "--Select Branch--", Value = "0"
});
if (dsCompany.Tables.Count > 0)
{
foreach (System.Data.DataRow row in dsCompany.Tables[0].Rows)
{
if (row["Parent_Company_ID"].ToString() == selectedcompanyid)
{
auditViewModel.MappedBranch.Add(new SelectListItem()
{
Text = row["Company_Name"].ToString(), Value = row["Org_Hier_ID"].ToString()
});
}
}
}
auditViewModel.complianceAudit = new ComplianceAudit();
auditViewModel.complianceAudit.Auditor_Id = AuditorID;
return(View(auditViewModel));
}
public JsonResult EditAuditdata(FormCollection form, HttpPostedFileBase file)
{
ComplianceAudit model = new ComplianceAudit();
string evidinces = form["Evidences"];
HttpPostedFileBase httpfile = Request.Files["Evidences"];
// HttpFileCollection httpFile = Request.Files["Evidences"];
model.Auditor_Id = Convert.ToInt32(form["auditid"]);
model.Applicability = form["Applicability"];
model.Start_Date = Convert.ToDateTime(form["Start_Date"]);
model.End_Date = Convert.ToDateTime(form["End_Date"]);
model.Audit_Followup_Date = Convert.ToDateTime(form["Audit_Followup_Date"]);
model.Audit_Status = form["Audit_Status"];
model.Audit_Remarks = form["Audit_Remarks"];
model.Auditor_Id = Convert.ToInt32(Session["UserId"]);
model.Org_Hier_Id = Convert.ToInt32(Session["BranchID"]);
model.Vendor_Id = Convert.ToInt32(Session["Vendorid"]);
model.Periodicity = form["Periodicity"];
model.Version = 0;
string option = form["oper"];
AudService.AuditServiceClient client = new AudService.AuditServiceClient();
if (option == "add")
{
ComplianceXref custom = new ComplianceXref();
custom.Compliance_Parent_ID = Convert.ToInt32(Session["Actid"]);
custom.Compliance_Title = form["Compliance_Title"];
custom.Compliance_Type_ID = Convert.ToInt32(Session["CompliancetypeID"]);
custom.compl_def_consequence = form["Non_compliance"];
custom.Comp_Category = "Rule";
custom.Comp_Description = form["Description"];
custom.Risk_Description = form["Details"];
//custom.Country_ID = Convert.ToInt32(form[""]);
//custom.State_ID = Convert.ToInt32(form[""]);
//custom.City_ID = Convert.ToInt32(form[""]);
custom.Country_ID = 0;
custom.State_ID = 0;
custom.City_ID = 0;
custom.Effective_Start_Date = Convert.ToDateTime(form["Start_Date"]);
custom.Effective_End_Date = Convert.ToDateTime(form["End_Date"]);
custom.Periodicity = form["Periodicity"];
custom.Is_Header = false;
custom.Comp_Order = 2;
custom.level = 2;
custom.Is_Best_Practice = true;
custom.Version = 1;
ComplianceXrefService.ComplianceXrefServiceClient service = new ComplianceXrefService.ComplianceXrefServiceClient();
model.Xref_Comp_Type_Map_ID = service.insertCustomxref(custom);
client.insertCustomAuditEntries(model);
}
else
{
int compliancexrefid = Convert.ToInt32(form["compliance_Xref_id"]);
ComplianceXrefService.ComplianceXrefServiceClient serviceClient = new ComplianceXrefService.ComplianceXrefServiceClient();
string xmldata = serviceClient.GetXrefComplainceTypemapping(Convert.ToInt32(Session["CompliancetypeID"]), compliancexrefid);
DataSet ds = new DataSet();
ds.ReadXml(new StringReader(xmldata));
model.Xref_Comp_Type_Map_ID = Convert.ToInt32(ds.Tables[0].Rows[0]["Xref_Comp_Type_Map_ID"]);
// client.insertAuditEntries(model);
}
//int compliancexrefid=Convert.ToInt32(form["ID"]);
var result = "Success";
return(Json(result));
}
public JsonResult GetAuditData(string sidx, string sord, int page, int rows, int actid)
{
actid = Convert.ToInt32(Session["Actid"]);
int pageIndex = Convert.ToInt32(page) - 1;
int pageSize = rows;
AuditentryViewModel model = new AuditentryViewModel();
model.auditentries = new List <Auditentry>();
AudService.AuditServiceClient client = new AudService.AuditServiceClient();
// int actid = Convert.ToInt32(form["actid"]);
int branchid = Convert.ToInt32(Session["BranchID"]);
int vendorid = Convert.ToInt32(Session["Vendorid"]);
int compliancetypeid = Convert.ToInt32(Session["CompliancetypeID"]);
string xmldata = client.getComplianceXref(branchid, vendorid, compliancetypeid, actid);
DataSet ds = new DataSet();
ds.ReadXml(new StringReader(xmldata));
xmldata = client.getcomplianceonorg(branchid, vendorid, 0, Convert.ToDateTime(Session["Sdate"]), Convert.ToDateTime(Session["Edate"]));
model.SDate = Convert.ToDateTime(Session["Sdate"]);
model.EDate = Convert.ToDateTime(Session["Edate"]);
DataSet dsaudit = new DataSet();
dsaudit.ReadXml(new StringReader(xmldata));
if (ds.Tables.Count > 0)
{
foreach (System.Data.DataRow row in ds.Tables[0].Rows)
{
Auditentry auditentry = new Auditentry
{
Compliance_Title = Convert.ToString(row["Compliance_Title"]),
Description = Convert.ToString(row["Comp_Description"]),
Non_compliance = Convert.ToString(row["Consequence"]),
Periodicity = Convert.ToString(row["Periodicity"]),
Details = Convert.ToString(row["Details"]),
compliance_Xref_id = Convert.ToInt32(row["Compliance_Xref_ID"]),
Start_Date = Convert.ToDateTime(Session["Sdate"]),
End_Date = Convert.ToDateTime(Session["Edate"]),
Compliance_Audit_Id = 0
};
ComplianceAudit audit = new ComplianceAudit();
if (dsaudit.Tables.Count > 0)
{
for (int i = 0; i < dsaudit.Tables[0].Rows.Count; i++)
//foreach (System.Data.DataRow item in dsaudit.Tables[0].Rows)
{
if (auditentry.compliance_Xref_id == Convert.ToInt32(dsaudit.Tables[1].Rows[i]["Compliance_Xref_ID"]))
{
auditentry.Applicability = Convert.ToString(dsaudit.Tables[0].Rows[i]["Applicability"]);
auditentry.Audit_Followup_Date = Convert.ToDateTime(dsaudit.Tables[0].Rows[i]["Audit_Followup_Date"]);
auditentry.Risk_Category = Convert.ToString(dsaudit.Tables[0].Rows[i]["Risk_Category"]);
auditentry.Audit_Remarks = Convert.ToString(dsaudit.Tables[0].Rows[i]["Audit_Remarks"]);
auditentry.Audit_Status = Convert.ToString(dsaudit.Tables[0].Rows[i]["Compliance_Status"]);
auditentry.Compliance_Audit_Id = Convert.ToInt32(dsaudit.Tables[0].Rows[i]["Compliance_Audit_ID"]);
audit.Xref_Comp_Type_Map_ID = Convert.ToInt32(dsaudit.Tables[0].Rows[i]["Xref_Comp_Type_Map_ID"]);
break;
}
}
}
auditentry.audits = audit;
model.auditentries.Add(auditentry);
}
}
var Results = model.auditentries;
int totalRecords = Results.Count();
var totalPages = (int)Math.Ceiling((float)totalRecords / (float)rows);
//if (sord.ToUpper() == "DESC")
//{
// Results = Results.OrderByDescending(s => s.Id);
// Results = Results.Skip(pageIndex * pageSize).Take(pageSize);
//}
//else
//{
// Results = Results.OrderBy(s => s.Id);
// Results = Results.Skip(pageIndex * pageSize).Take(pageSize);
//}
var jsonData = new
{
total = totalPages,
page,
records = totalRecords,
rows = Results
};
return(Json(jsonData, JsonRequestBehavior.AllowGet));
}
