public int insertActs(ComplianceXref compliance)
{
ComplianceXrefHelper helper = new ComplianceXrefHelper();
compliance.Is_Active = true;
compliance.Is_Header = true;
compliance.level = 1;
compliance.Comp_Category = "Act";
compliance.Comp_Order = 1;
compliance.Version = 1;
compliance.Compliance_Parent_ID = 0;
return(helper.insertupdateComplianceXref(compliance, 'I'));
}
// MySqlConnection connection = new MySqlConnection(ConfigurationManager.ConnectionStrings["MySqlConnectionString"].ConnectionString);
public int insertupdateComplianceXref(ComplianceXref xref, char Flag)
{
int ComplianceXref = 0;
try
{
if (xref != null)
{
conn.Open();
MySqlCommand cmd = new MySqlCommand("sp_insertupdateComplianceXref", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("p_Flag", Flag);
cmd.Parameters.AddWithValue("p_Compliance_Xref_ID", xref.Compliance_Xref_ID);
cmd.Parameters.AddWithValue("p_Compliance_Parent_ID", xref.Compliance_Parent_ID);
cmd.Parameters.AddWithValue("p_Compliance_Title", xref.Compliance_Title);
cmd.Parameters.AddWithValue("p_Comp_Category", xref.Comp_Category);
cmd.Parameters.AddWithValue("p_Comp_Description", xref.Comp_Description);
cmd.Parameters.AddWithValue("p_compl_def_consequence", xref.compl_def_consequence);
cmd.Parameters.AddWithValue("p_Is_Header", xref.Is_Header);
cmd.Parameters.AddWithValue("p_level", xref.level);
// cmd.Parameters.AddWithValue("p_Comp_Order", xref.Comp_Order);
cmd.Parameters.AddWithValue("p_Risk_Category", xref.Risk_Category);
cmd.Parameters.AddWithValue("p_Risk_Description", xref.Risk_Description);
cmd.Parameters.AddWithValue("p_Periodicity", xref.Periodicity);
//cmd.Parameters.AddWithValue("p_Form", xref.Form);
//cmd.Parameters.AddWithValue("p_Type", xref.Type);
//cmd.Parameters.AddWithValue("p_Is_Best_Practice", xref.Is_Best_Practice);
cmd.Parameters.AddWithValue("p_Version", xref.Version);
cmd.Parameters.AddWithValue("p_Effective_Start_Date", xref.Effective_Start_Date);
cmd.Parameters.AddWithValue("p_Effective_End_Date", xref.Effective_End_Date);
cmd.Parameters.AddWithValue("p_Country_ID", xref.Country_ID);
cmd.Parameters.AddWithValue("p_State_ID", xref.State_ID);
cmd.Parameters.AddWithValue("p_City_ID", xref.City_ID);
cmd.Parameters.AddWithValue("p_User_ID", xref.User_ID);
cmd.Parameters.AddWithValue("p_Is_Active", xref.Is_Active);
ComplianceXref = Convert.ToInt32(cmd.ExecuteScalar());
}
}
catch
{
throw;
}
finally
{
conn.Close();
}
return(ComplianceXref);
}
public int insertRules(ComplianceXref compliance)
{
ComplianceXrefHelper helper = new ComplianceXrefHelper();
compliance.Is_Active = true;
compliance.Is_Header = false;
compliance.level = 2;
//compliance.Comp_Category = "Rule";
compliance.Version = 1;
int complianeid = helper.insertupdateComplianceXref(compliance, 'I');
DataSet ds = helper.GetxrefComplianceMapping(0, compliance.Compliance_Parent_ID);
if (ds.Tables.Count > 0)
{
foreach (System.Data.DataRow row in ds.Tables[0].Rows)
{
helper.insertxreftypemapping(complianeid, Convert.ToInt32(row["Compliance_Type_ID"]), "Rule");
}
}
return(complianeid);
}
public int UpdateRules(ComplianceXref compliance)
{
ComplianceXrefHelper helper = new ComplianceXrefHelper();
return(helper.insertupdateComplianceXref(compliance, 'U'));
}
public int insertCustomxref(ComplianceXref compliance)
{
ComplianceXrefHelper helper = new ComplianceXrefHelper();
return(helper.insertupdateCustomComplianceXref(compliance));
}
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));
}
