public ClauseModel GetClauseById(string clauseId)
{
ClauseModel clauseModel = new ClauseModel();
using (MySqlConnection con = new MySqlConnection(connectionString))
{
MySqlCommand cmd = new MySqlCommand("select * from clause where clause_ID='" + clauseId + "' ; ", con);
//cmd.CommandType = CommandType.StoredProcedure;
con.Open();
MySqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
clauseModel.ClauseOldID = rdr["clause_ID_old"].ToString();
clauseModel.ClauseID = Convert.ToInt32(rdr["clause_ID"]);
clauseModel.DocumentID = Convert.ToInt32(rdr["document_ID"]);
clauseModel.ClauseNo = rdr["clause_no"].ToString();
clauseModel.ClausePage = rdr["clause_page"].ToString();
clauseModel.ClauseContent = rdr["clause_content"].ToString();
clauseModel.DocVersionID = Convert.ToInt32(rdr["doc_version_ID"]);
clauseModel.CreatedBy = rdr["creator_ID"].ToString();
//document.UpdatedBy = Convert.ToInt32(rdr["creator_ID"]);
clauseModel.CreatedAt = rdr["created_at"].ToString();
//document.UpdatedAt = rdr["updated_at"].ToString();
//document.UpdatedBy = Convert.ToInt32(rdr["updated_by"]);
//employee.Gender = rdr["Gender"].ToString();
//employee.Department = rdr["Department"].ToString();
//employee.City = rdr["City"].ToString();
}
con.Close();
}
return(clauseModel);
}
public IActionResult _Detail(string id,string actionType)
{
ClauseVM clauseVM = new ClauseVM();
ClauseModel clauseModel = new ClauseModel();
if (actionType.ToLower().Equals("insert"))
{
// Insert
clauseVM.actionType = "insert";
clauseVM.listDocument = documentDAL.GetAllDocuments();
clauseVM.listVersion = menuDAL.GetAllVersion();
}
else
{
// Update
clauseVM.actionType = "Update";
clauseVM.clauseModel = clauseDAL.GetClauseById(id);
clauseVM.listDocument = documentDAL.GetAllDocuments();
clauseVM.listVersion = menuDAL.GetAllVersion();
//clauseModel = clauseDAL.GetDocumentByID(id);
////documentVM.listDocument = documentDAL.GetAllDocuments().ToList();
//documentVM.listDocType = menuDAL.GetAllDocType();
//documentVM.listVersion = menuDAL.GetAllVersion();
//documentVM.listDocStatus = menuDAL.GetAllDocStatus();
//documentVM.documentModel = document;
}
return PartialView("_Detail", clauseVM);
}
public List <ClauseModel> GetAllClause(out int totalCount)
{
List <ClauseModel> listClause = new List <ClauseModel>();
using (MySqlConnection con = new MySqlConnection(connectionString))
{
MySqlCommand cmd = new MySqlCommand("select * from clause;", con);
//cmd.CommandType = CommandType.StoredProcedure;
con.Open();
MySqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
ClauseModel clause = new ClauseModel();
clause.ClauseID = Convert.ToInt32(rdr["clause_ID"]);
clause.DocumentID = Convert.ToInt32(rdr["document_ID"]);
clause.ClauseNo = rdr["clause_no"].ToString();
clause.ClausePage = rdr["clause_page"].ToString();
clause.ClauseContent = rdr["clause_content"].ToString();
clause.DocVersionID = Convert.ToInt32(rdr["doc_version_ID"]);
clause.CreatedBy = rdr["creator_ID"].ToString();
//document.UpdatedBy = Convert.ToInt32(rdr["creator_ID"]);
clause.CreatedAt = rdr["created_at"].ToString();
//document.UpdatedAt = rdr["updated_at"].ToString();
//document.UpdatedBy = Convert.ToInt32(rdr["updated_by"]);
//employee.Gender = rdr["Gender"].ToString();
//employee.Department = rdr["Department"].ToString();
//employee.City = rdr["City"].ToString();
listClause.Add(clause);
}
con.Close();
}
totalCount = listClause.Count;
return(listClause);
}
private OrganizationLicenseClause SetupLicenseClause(ClauseModel clause, OrganizationLicense license, LoggedInUserDetails user)
{
var clauseValue = _licenseClauses.GetClauseData(clause);
var consumerClause = new OrganizationLicenseClause
{
LicenseClauseID = clause.ClauseId,
OrganizationLicenseID = license.ID,
CreatedBy = user.ID.Value,
CreatedAt = GetDate,
ClauseData = clauseValue
};
return(consumerClause);
}
public IActionResult UpdateClause([FromBody]ClauseModel clauseModel)
{
string result = "";
try
{
result = clauseDAL.UpdateClause(clauseModel, HttpContext.User.Identity.Name);
}
catch (Exception)
{
result = "fail";
//throw;
}
return Json(result);
}
public static ClauseModel ToModel(this LicenseClauseTemplate template, int sectionId)
{
var result = new ClauseModel();
result.ClauseId = template.LicenseClauseID;
result.ClauseTemplateId = template.ID;
result.LegalText = template.LegalText;
result.SectionId = sectionId;
result.Type = template.ClauseType;
if ((ClauseType)result.Type == ClauseType.InputAndDropDown)
{
result.SetupDropDownItems();
}
return(result);
}
public String UpdateClause(ClauseModel clauseModel, string userName)
{
string result = "success";
try
{
using (MySqlConnection con = new MySqlConnection(connectionString))
{
string insert = "update clause set clause_ID_old=@clause_ID_old,document_ID=@document_ID,clause_no=@clause_no,clause_page=@clause_page,clause_content=@clause_content,doc_version_ID=@doc_version_ID" +
",updated_at=@updated_at,updated_by = (select id from aspnetusers where username = '******') where clause_ID=@clause_ID;";
con.Open();
MySqlCommand cmd = new MySqlCommand(insert, con);
cmd.Prepare();
cmd.Parameters.AddWithValue("@clause_ID", clauseModel.ClauseID.ToString());
cmd.Parameters.AddWithValue("@clause_ID_old", clauseModel.ClauseOldID.ToString());
cmd.Parameters.AddWithValue("@document_ID", clauseModel.DocumentID.ToString());
cmd.Parameters.AddWithValue("@clause_no", clauseModel.ClauseNo.ToString());
cmd.Parameters.AddWithValue("@clause_page", clauseModel.ClausePage.ToString());
cmd.Parameters.AddWithValue("@clause_content", clauseModel.ClauseContent.ToString());
cmd.Parameters.AddWithValue("@doc_version_ID", clauseModel.DocVersionID.ToString());
cmd.Parameters.AddWithValue("@updated_at", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
cmd.ExecuteNonQuery();
con.Close();
}
}
catch (Exception ex)
{
result = "fail";
}
finally
{
StackTrace stackTrace = new StackTrace();
var routeValues = System.Reflection.MethodBase.GetCurrentMethod().Name;
String caller = stackTrace.GetFrame(1).GetMethod().Name.ToString();
var json = JsonConvert.SerializeObject(clauseModel);
ExceptionLogging.SendExcepToDB(json, "update", userName);
}
return(result);
}
public String InsertClause(ClauseModel clauseModel, string userName)
{
string result = "success";
try
{
using (MySqlConnection con = new MySqlConnection(connectionString))
{
string insert = "insert into clause(clause_ID_old,document_ID,clause_no,clause_page,clause_content,doc_version_ID,creator_ID,created_at,updated_at,updated_by)" +
"values (@clause_ID_old,@document_ID,@clause_no,@clause_page,@clause_content,@doc_version_ID,(select id from aspnetusers where username = '******'),@created_at,@updated_at,(select id from aspnetusers where username = '******'))";
con.Open();
MySqlCommand cmd = new MySqlCommand(insert, con);
cmd.Prepare();
cmd.Parameters.AddWithValue("@clause_ID_old", clauseModel.ClauseOldID.ToString());
cmd.Parameters.AddWithValue("@document_ID", clauseModel.DocumentID.ToString());
cmd.Parameters.AddWithValue("@clause_no", clauseModel.ClauseNo.ToString());
cmd.Parameters.AddWithValue("@clause_page", clauseModel.ClausePage.ToString());
cmd.Parameters.AddWithValue("@clause_content", clauseModel.ClauseContent.ToString());
cmd.Parameters.AddWithValue("@doc_version_ID", clauseModel.DocVersionID.ToString());
cmd.Parameters.AddWithValue("@created_at", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
cmd.Parameters.AddWithValue("@updated_at", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
cmd.ExecuteNonQuery();
con.Close();
}
}
catch (Exception ex)
{
result = "fail";
}finally
{
var json = JsonConvert.SerializeObject(clauseModel);
ExceptionLogging.SendExcepToDB(json, "insert", userName);
}
return(result);
}
public string GetClauseData(ClauseModel selectedClause)
{
// Get template for clause
var clauseTemplate = _clauseTemplates.FirstOrDefault(i => i.LicenseClauseID == selectedClause.ClauseId);
switch ((ClauseType)selectedClause.Type)
{
case ClauseType.Text:
{
return(selectedClause.LegalText);
}
case ClauseType.Input:
{
var model = selectedClause;
if (string.IsNullOrEmpty(model.InputValue))
{
return(clauseTemplate.LegalText);
}
// Identify position where text should be inserted
var indexOfOpenBracket = clauseTemplate.LegalText.IndexOf('{');
// Insert text into brakets
// Result will be like: charged at a rate of ${10}
var result = clauseTemplate.LegalText.Insert(indexOfOpenBracket + 1, model.InputValue);
// Return result
return(result);
}
case ClauseType.InputAndDropDown:
{
// Check whether input has value
if (string.IsNullOrEmpty(selectedClause.InputValue))
{
selectedClause.InputValue = "0";
}
// Legal Text example: Consumer of data will be charged at a rate of ${} each {day,week,month}.
var model = selectedClause;
var indexOfOpenBracket = clauseTemplate.LegalText.IndexOf('{');
var index2OfOpenBracket = clauseTemplate.LegalText.LastIndexOf('{');
var index2OfCloseBracket = clauseTemplate.LegalText.LastIndexOf('}');
// TODO: Make sure entered value validation does not allow to input '{' '}'
// remove dropdown list items from text
var legalText = clauseTemplate.LegalText.Remove(index2OfOpenBracket + 1,
index2OfCloseBracket - index2OfOpenBracket - 1);
// Update index after text modification
index2OfCloseBracket = legalText.LastIndexOf('}');
// Insert DropDown selected value into a brackets location
legalText = legalText.Insert(index2OfCloseBracket, model.SelectedItem);
// insert value of input and selected dropdown item to template
// Result will be like: charged at a rate of ${10} each {day}
return(legalText.Insert(indexOfOpenBracket + 1, model.InputValue));
}
default:
throw new BaseException("Unknown clause type");
}
}
private ComparisonResult CompareClauses(OrganizationLicenseClause providerClause, ClauseModel consumerClause)
{
var result = new ComparisonResult();
// Check whether clause selected by consumer
if (!consumerClause.IsSelectedByConsumer)
{
// Setup result
result.IsMatch = false;
result.Message = "Not selected";
// Return result
return(result);
}
// Setup provider value
var providerTemplate = _clauseTemplateService.FirstOrDefault(i => i.LicenseClauseID == providerClause.LicenseClauseID);
var providerValue = new ClauseValue(providerClause.ClauseData, (ClauseType)providerTemplate.ClauseType);
// Setup consumer value
var consumerClauseData = _licenseClauses.GetClauseData(consumerClause);
var consumerValue = new ClauseValue(consumerClauseData, (ClauseType)consumerClause.Type);
// Compare values
result = CompareClauseValues(providerValue, consumerValue);
// Return result
return(result);
}
