public Object insertInfo(INFORMATION info)
{
try
{
db.INFORMATION.Add(info);
db.SaveChanges();
var result = new
{
status = true,
link = new
{
actionName = "Index",
controllerName = "Home"
},
message = "Nhập thông tin thành công"
};
return(result);
}
catch
{
var result = new
{
status = false,
message = "Nhập thông tin không thành công"
};
return(result);
}
}
/// <summary>
/// Returns a block of data generally from the INFORMATION table plus a few others.
/// </summary>
/// <returns></returns>
public BasicReportData.INFORMATION GetInformation()
{
using (var db = new CSET_Context())
{
INFORMATION infodb = db.INFORMATION.Where(x => x.Id == _assessmentId).FirstOrDefault();
TinyMapper.Bind <INFORMATION, BasicReportData.INFORMATION>(config =>
{
config.Ignore(x => x.Additional_Contacts);
});
var info = TinyMapper.Map <BasicReportData.INFORMATION>(infodb);
var assessment = db.ASSESSMENTS.FirstOrDefault(x => x.Assessment_Id == _assessmentId);
info.Assessment_Date = assessment.Assessment_Date.ToLongDateString();
// Primary Assessor
var user = db.USERS.FirstOrDefault(x => x.UserId == assessment.AssessmentCreatorId);
info.Assessor_Name = user != null?Utilities.FormatName(user.FirstName, user.LastName) : string.Empty;
// Other Contacts
info.Additional_Contacts = new List <string>();
var contacts = db.ASSESSMENT_CONTACTS
.Where(ac => ac.Assessment_Id == _assessmentId &&
ac.UserId != assessment.AssessmentCreatorId)
.Include(u => u.User)
.ToList();
foreach (var c in contacts)
{
info.Additional_Contacts.Add(Utilities.FormatName(c.FirstName, c.LastName));
}
// Include anything that was in the INFORMATION record's Additional_Contacts column
if (infodb.Additional_Contacts != null)
{
string[] acLines = infodb.Additional_Contacts.Split(new[] { Environment.NewLine }, StringSplitOptions.RemoveEmptyEntries);
foreach (string c in acLines)
{
info.Additional_Contacts.Add(c);
}
}
// ACET properties
info.Credit_Union_Name = assessment.CreditUnionName;
info.Charter = assessment.Charter;
info.Assets = 0;
bool a = int.TryParse(assessment.Assets, out int assets);
if (a)
{
info.Assets = assets;
}
return(info);
}
}
public void AddCustomerInformation(INFORMATION information)
{
var postObject = new PostObject <object>();
PostAction action = Config.PostActions.Where(o => o.Code == ActionCode.AddInformation).SingleOrDefault();
postObject.PostAction = action;
postObject.Data = information;
this._service.PostObject(this, postObject);
}
public void changeInfo(INFORMATION entity)
{
object[] sqlparams =
{
new SqlParameter("@SDT", entity.SDT),
new SqlParameter("@TenKH", entity.TenKH),
new SqlParameter("@DiaChi", entity.DiaChi),
new SqlParameter("@Email", entity.Email)
};
db.Database.ExecuteSqlCommand("SuaINFORMATION @SDT, @TenKH, @DiaChi, @Email", sqlparams);
}
public IHttpActionResult SaveInformation([FromBody] PostObject <object> postObject)
{
JsonSerializerSettings serSettings = new JsonSerializerSettings();
serSettings.ContractResolver = new CamelCasePropertyNamesContractResolver();
INFORMATION info = JsonConvert.DeserializeObject <INFORMATION>(postObject.Data.ToString(), serSettings);
var result = this._informationProvider.AddInformation(info);
return(Ok(result));
}
private void AddCustomerInformation()
{
INFORMATION information = new INFORMATION();
information.ID_NO = "8112135489081";
information.ADDRESS1 = "400 Osprey";
_parent.AddCustomerInformation(information);
this.Dismiss();
}
public ActionResult Index(INFORMATION entity)
{
if (Session["Customer"] == null)
{
return(RedirectToAction("Index", "Login", new { area = "" }));
}
else
{
CustomerModel cus = new CustomerModel();
cus.changeInfo(entity);
TempData["Alert-Message"] = "Thay đổi thông tin thành công";
return(Redirect(Request.UrlReferrer.ToString()));
}
}
/// <summary>
/// Persists data to the ASSESSMENTS and INFORMATION tables.
/// Date fields should be converted to UTC before sending the Assessment
/// to this method.
/// </summary>
/// <param name="assessment"></param>
/// <returns></returns>
public int SaveAssessmentDetail(int assessmentId, AssessmentDetail assessment)
{
var db = new DataLayerCore.Model.CSET_Context();
TokenManager tm = new TokenManager();
string app_code = tm.Payload(Constants.Token_Scope);
// Add or update the ASSESSMENT record
var dbAssessment = new ASSESSMENTS()
{
Assessment_Id = assessment.Id,
AssessmentCreatedDate = assessment.CreatedDate,
AssessmentCreatorId = assessment.CreatorId,
Assessment_Date = assessment.AssessmentDate ?? DateTime.Now,
LastAccessedDate = assessment.LastModifiedDate,
Charter = string.IsNullOrEmpty(assessment.Charter) ? string.Empty : assessment.Charter.PadLeft(5, '0'),
CreditUnionName = assessment.CreditUnion,
Assets = assessment.Assets,
MatDetail_targetBandOnly = app_code == "ACET"
};
db.ASSESSMENTS.AddOrUpdate(dbAssessment, x => x.Assessment_Id);
db.SaveChanges();
assessmentId = dbAssessment.Assessment_Id;
var user = db.USERS.FirstOrDefault(x => x.UserId == dbAssessment.AssessmentCreatorId);
// then use its key for the INFORMATION record
var dbInfo = new INFORMATION
{
Id = assessmentId,
Assessment_Name = assessment.AssessmentName,
Facility_Name = assessment.FacilityName,
City_Or_Site_Name = assessment.CityOrSiteName,
State_Province_Or_Region = assessment.StateProvRegion,
Executive_Summary = assessment.ExecutiveSummary,
Assessment_Description = assessment.AssessmentDescription,
Additional_Notes_And_Comments = assessment.AdditionalNotesAndComments,
IsAcetOnly = assessment.IsAcetOnly
};
db.INFORMATION.AddOrUpdate(dbInfo, x => x.Id);
db.SaveChanges();
AssessmentUtil.TouchAssessment(assessmentId);
return(dbInfo.Id);
}
public ResultObj <INFORMATION> AddInformation(INFORMATION information)
{
ResultObj <INFORMATION> result = new ResultObj <INFORMATION>()
{
isSuccessful = false
};
using (this._unitOfWork)
{
var added = this._unitOfWork.InformationManager.AddInformation(information);
this._unitOfWork.SaveChanges();
result.Data = added;
result.isSuccessful = true;
}
return(result);
}
/// <summary>
/// Persists data to the ASSESSMENTS and INFORMATION tables.
/// Date fields should be converted to UTC before sending the Assessment
/// to this method.
/// </summary>
/// <param name="assessment"></param>
/// <returns></returns>
public int SaveAssessmentDetail(int assessmentId, AssessmentDetail assessment)
{
var db = new DataLayerCore.Model.CSET_Context();
// Add or update the ASSESSMENT record
var dbAssessment = new ASSESSMENTS()
{
Assessment_Id = assessment.Id,
AssessmentCreatedDate = assessment.CreatedDate,
AssessmentCreatorId = assessment.CreatorId,
Assessment_Date = assessment.AssessmentDate ?? DateTime.Now,
LastAccessedDate = assessment.LastModifiedDate,
Charter = assessment.Charter,
CreditUnionName = assessment.CreditUnion,
Assets = assessment.Assets
};
db.ASSESSMENTS.AddOrUpdate(dbAssessment, x => x.Assessment_Id);
db.SaveChanges();
assessmentId = dbAssessment.Assessment_Id;
var user = db.USERS.FirstOrDefault(x => x.UserId == dbAssessment.AssessmentCreatorId);
// then use its key for the INFORMATION record
var dbInfo = new INFORMATION
{
Id = assessmentId,
Assessment_Name = assessment.AssessmentName,
Facility_Name = assessment.FacilityName,
City_Or_Site_Name = assessment.CityOrSiteName,
State_Province_Or_Region = assessment.StateProvRegion,
Executive_Summary = assessment.ExecutiveSummary,
Assessment_Description = assessment.AssessmentDescription,
Additional_Notes_And_Comments = assessment.AdditionalNotesAndComments
};
db.INFORMATION.AddOrUpdate(dbInfo, x => x.Id);
db.SaveChanges();
AssessmentUtil.TouchAssessment(assessmentId);
return(dbInfo.Id);
}
/// <summary>
/// Returns a block of data generally from the INFORMATION table plus a few others.
/// </summary>
/// <returns></returns>
public BasicReportData.INFORMATION GetInformation()
{
using (var db = new CSET_Context())
{
INFORMATION infodb = db.INFORMATION.Where(x => x.Id == _assessmentId).FirstOrDefault();
var info = TinyMapper.Map <BasicReportData.INFORMATION>(infodb);
var assessment = db.ASSESSMENTS.FirstOrDefault(x => x.Assessment_Id == _assessmentId);
info.Assessment_Date = assessment.Assessment_Date.ToLongDateString();
// Primary Assessor
var user = db.USERS.FirstOrDefault(x => x.UserId == assessment.AssessmentCreatorId);
info.Assessor_Name = user != null?Utilities.FormatName(user.FirstName, user.LastName) : string.Empty;
// Other Contacts
info.Additional_Contacts = new List <string>();
var contacts = db.ASSESSMENT_CONTACTS
.Where(ac => ac.Assessment_Id == _assessmentId &&
ac.UserId != assessment.AssessmentCreatorId)
.Include(u => u.User)
.ToList();
foreach (var c in contacts)
{
info.Additional_Contacts.Add(Utilities.FormatName(c.FirstName, c.LastName));
}
// ACET properties
info.Credit_Union_Name = assessment.CreditUnionName;
info.Charter = assessment.Charter;
info.Assets = 0;
bool a = int.TryParse(assessment.Assets, out int assets);
if (a)
{
info.Assets = assets;
}
return(info);
}
}
public void When_Information_Added_Should_Return_True()
{
IUnitOfWork unitOfWork = new UnitOfWork();
IInformationProvider provider = new InformationProvider(unitOfWork);
INFORMATION info = new INFORMATION();
info.ID_NO = "9812135489081";
InformationController controller = new InformationController(provider);
PostObject <object> post = new PostObject <object>();
post.Data = JsonConvert.SerializeObject(info);
var res = controller.SaveInformation(post);
Assert.IsNotNull(res);
// var result = provider.AddInformation(info);
// Assert.IsNotNull(result.Success);
}
public ActionResult ForgetPassword(INFORMATION entity)
{
MainDbContext db = new MainDbContext();
int count = db.INFORMATION.Where(x => x.SDT == entity.SDT).Count();
if (count > 0)
{
try
{
CustomerModel cus = new CustomerModel();
ViewBag.infoCustomer = cus.infoCustomer(entity.SDT);
string content = System.IO.File.ReadAllText(Server.MapPath("~/Template/OTP.html"));
Random rd = new Random();
string rdNumber = (rd.Next(100000, 999999)).ToString();
Session["OTP"] = rdNumber;
var toEmail = "";
foreach (var item in ViewBag.infoCustomer)
{
content = content.Replace("{{OTP}}", Session["OTP"].ToString());
toEmail = item.Email;
}
new MailHelper().SendMail(toEmail, "Lấy lại mật khẩu", content);
Session["PhoneNumber"] = entity.SDT;
return(RedirectToAction("Verify", "Login"));
}
catch { }
}
else
{
TempData["Error"] = "Số điện thoại không tồn tại";
}
return(Redirect(Request.UrlReferrer.ToString()));
}
/// <summary>
/// Persists data to the ASSESSMENTS and INFORMATION tables.
/// Date fields should be converted to UTC before sending the Assessment
/// to this method.
/// </summary>
/// <param name="assessment"></param>
/// <returns></returns>
public int SaveAssessmentDetail(int assessmentId, AssessmentDetail assessment)
{
using (var db = new DataLayerCore.Model.CSET_Context())
{
TokenManager tm = new TokenManager();
string app_code = tm.Payload(Constants.Token_Scope);
// Add or update the ASSESSMENTS record
var dbAssessment = db.ASSESSMENTS.Where(x => x.Assessment_Id == assessmentId).FirstOrDefault();
if (dbAssessment == null)
{
dbAssessment = new ASSESSMENTS();
db.ASSESSMENTS.Add(dbAssessment);
db.SaveChanges();
assessmentId = dbAssessment.Assessment_Id;
}
dbAssessment.Assessment_Id = assessmentId;
dbAssessment.AssessmentCreatedDate = assessment.CreatedDate;
dbAssessment.AssessmentCreatorId = assessment.CreatorId;
dbAssessment.Assessment_Date = assessment.AssessmentDate ?? DateTime.Now;
dbAssessment.LastAccessedDate = assessment.LastModifiedDate;
dbAssessment.Charter = string.IsNullOrEmpty(assessment.Charter) ? string.Empty : assessment.Charter.PadLeft(5, '0');
dbAssessment.CreditUnionName = assessment.CreditUnion;
dbAssessment.Assets = assessment.Assets;
dbAssessment.MatDetail_targetBandOnly = (app_code == "ACET");
dbAssessment.AnalyzeDiagram = false;
db.ASSESSMENTS.AddOrUpdate(dbAssessment, x => x.Assessment_Id);
db.SaveChanges();
var user = db.USERS.FirstOrDefault(x => x.UserId == dbAssessment.AssessmentCreatorId);
var dbInformation = db.INFORMATION.Where(x => x.Id == assessmentId).FirstOrDefault();
if (dbInformation == null)
{
dbInformation = new INFORMATION()
{
Id = assessmentId
};
}
// add or update the INFORMATION record
dbInformation.Assessment_Name = assessment.AssessmentName;
dbInformation.Facility_Name = assessment.FacilityName;
dbInformation.City_Or_Site_Name = assessment.CityOrSiteName;
dbInformation.State_Province_Or_Region = assessment.StateProvRegion;
dbInformation.Executive_Summary = assessment.ExecutiveSummary;
dbInformation.Assessment_Description = assessment.AssessmentDescription;
dbInformation.Additional_Notes_And_Comments = assessment.AdditionalNotesAndComments;
dbInformation.IsAcetOnly = assessment.IsAcetOnly;
db.INFORMATION.AddOrUpdate(dbInformation, x => x.Id);
db.SaveChanges();
AssessmentUtil.TouchAssessment(assessmentId);
return(assessmentId);
}
}
/// <summary>
/// Persists data to the ASSESSMENTS and INFORMATION tables.
/// Date fields should be converted to UTC before sending the Assessment
/// to this method.
/// </summary>
/// <param name="assessment"></param>
/// <returns></returns>
public int SaveAssessmentDetail(int assessmentId, AssessmentDetail assessment)
{
using (var db = new DataLayerCore.Model.CSET_Context())
{
TokenManager tm = new TokenManager();
string app_code = tm.Payload(Constants.Token_Scope);
// Add or update the ASSESSMENTS record
var dbAssessment = db.ASSESSMENTS.Where(x => x.Assessment_Id == assessmentId).FirstOrDefault();
if (dbAssessment == null)
{
dbAssessment = new ASSESSMENTS();
db.ASSESSMENTS.Add(dbAssessment);
db.SaveChanges();
assessmentId = dbAssessment.Assessment_Id;
}
dbAssessment.Assessment_Id = assessmentId;
dbAssessment.AssessmentCreatedDate = assessment.CreatedDate;
dbAssessment.AssessmentCreatorId = assessment.CreatorId;
dbAssessment.Assessment_Date = assessment.AssessmentDate ?? DateTime.Now;
dbAssessment.LastAccessedDate = assessment.LastModifiedDate;
dbAssessment.UseDiagram = assessment.UseDiagram;
dbAssessment.UseMaturity = assessment.UseMaturity;
dbAssessment.UseStandard = assessment.UseStandard;
dbAssessment.Charter = string.IsNullOrEmpty(assessment.Charter) ? string.Empty : assessment.Charter.PadLeft(5, '0');
dbAssessment.CreditUnionName = assessment.CreditUnion;
dbAssessment.Assets = assessment.Assets;
dbAssessment.MatDetail_targetBandOnly = (app_code == "ACET");
dbAssessment.Diagram_Markup = assessment.DiagramMarkup;
dbAssessment.Diagram_Image = assessment.DiagramImage;
dbAssessment.AnalyzeDiagram = false;
db.ASSESSMENTS.AddOrUpdate(dbAssessment, x => x.Assessment_Id);
db.SaveChanges();
var user = db.USERS.FirstOrDefault(x => x.UserId == dbAssessment.AssessmentCreatorId);
var dbInformation = db.INFORMATION.Where(x => x.Id == assessmentId).FirstOrDefault();
if (dbInformation == null)
{
dbInformation = new INFORMATION()
{
Id = assessmentId
};
}
// add or update the INFORMATION record
dbInformation.Assessment_Name = assessment.AssessmentName;
dbInformation.Facility_Name = assessment.FacilityName;
dbInformation.City_Or_Site_Name = assessment.CityOrSiteName;
dbInformation.State_Province_Or_Region = assessment.StateProvRegion;
dbInformation.Executive_Summary = assessment.ExecutiveSummary;
dbInformation.Assessment_Description = assessment.AssessmentDescription;
dbInformation.Additional_Notes_And_Comments = assessment.AdditionalNotesAndComments;
dbInformation.IsAcetOnly = assessment.IsAcetOnly;
db.INFORMATION.AddOrUpdate(dbInformation, x => x.Id);
db.SaveChanges();
if (assessment.UseMaturity)
{
SalManager salManager = new SalManager();
salManager.SetDefaultSAL_IfNotSet(assessmentId);
//this is at the bottom deliberatly because
//we want everything else to succeed first
MaturityManager mm = new MaturityManager();
mm.PersistSelectedMaturityModel(assessmentId, "CMMC");
if (mm.GetMaturityLevel(assessmentId) == 0)
{
mm.PersistMaturityLevel(assessmentId, 1);
}
}
AssessmentUtil.TouchAssessment(assessmentId);
return(assessmentId);
}
}
public INFORMATION AddInformation(INFORMATION information)
{
return(this._context.INFORMATION.Add(information));
}
