public ActionResult Auditentry(int compliancetypeid, int branchid, int vendorid, DateTime sdate, DateTime edate)
{
AuditentryViewModel model = new AuditentryViewModel();
model.ActList = new List <SelectListItem>();
AudService.AuditServiceClient client = new AudService.AuditServiceClient();
string xmldata = client.getComplianceActList(branchid, vendorid, compliancetypeid);
DataSet ds = new DataSet();
ds.ReadXml(new StringReader(xmldata));
if (ds.Tables.Count > 0)
{
model.actid = Convert.ToInt32(ds.Tables[0].Rows[0]["Compliance_Xref_ID"]);
Session["Actid"] = Convert.ToInt32(ds.Tables[0].Rows[0]["Compliance_Xref_ID"]);
foreach (System.Data.DataRow row in ds.Tables[0].Rows)
{
model.ActList.Add(new SelectListItem()
{
Text = Convert.ToString(row["Compliance_Title"]), Value = Convert.ToString(row["Compliance_Xref_ID"])
});
}
}
Session["CompliancetypeID"] = compliancetypeid;
Session["BranchID"] = branchid;
Session["Vendorid"] = vendorid;
Session["Sdate"] = sdate;
Session["Edate"] = edate;
return(View("_auuditentry", model));
}
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 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));
}
