// GET: Isuarance company Master
public ActionResult InsuranceCompany()
{
InsuranceCompanyData insuranceCompanyData = new InsuranceCompanyData();
insuranceCompanyData.InsuranceCompany = null;
insuranceCompanyData.InsuranceCompanies = db.Companies.ToList();
return(View(insuranceCompanyData));
}
public ActionResult CreateInsuranceCompany([Bind(Include = "Id,CompanyName,CompanyCode,Address,Country,Email,Mobile,ContactPersonName,ContactPersonMobile")] CaresoftHMISDataAccess.Company insuranceCompany)
{
if (ModelState.IsValid)
{
db.Companies.Add(insuranceCompany);
db.SaveChanges();
ViewBag.Message = "success~Company Addedd Successfully";
return(RedirectToAction("InsuranceCompany"));
}
else
{
ViewBag.Message = "warning~Fill in all required fields";
InsuranceCompanyData insuranceCompanyData = new InsuranceCompanyData();
insuranceCompanyData.InsuranceCompany = insuranceCompany;
insuranceCompanyData.InsuranceCompanies = db.Companies.ToList();
return(View("InsuranceCompany", insuranceCompanyData));
}
}
private string InsertPrepareSMS(SLMDBEntities slmdb, kkslm_tr_renewinsurance renew, List <InsuranceCompanyData> companyList, List <kkslm_ms_coveragetype> coverageList)
{
try
{
if (string.IsNullOrEmpty(AppConstant.SMSTemplatePathReceiveNo))
{
throw new Exception($"ไม่พบ Config {nameof(AppConstant.SMSTemplatePathReceiveNo)} ใน Configuration File");
}
InsuranceCompanyData insuranceCompany = companyList.FirstOrDefault(p => p.InsComId == renew.slm_InsuranceComId);
if (insuranceCompany == null)
{
throw new Exception("ไม่พบข้อมูลบริษัทประกัน Id " + renew.slm_InsuranceComId + " ในระบบ");
}
kkslm_ms_coveragetype coverage = coverageList.FirstOrDefault(p => p.slm_CoverageTypeId == renew.slm_CoverageTypeId);
if (coverage == null)
{
throw new Exception("ไม่พบข้อมูลประเภทประกัน Id " + renew.slm_CoverageTypeId + " ในระบบ");
}
kkslm_tr_lead lead = slmdb.kkslm_tr_lead.FirstOrDefault(p => p.slm_ticketId == renew.slm_TicketId);
if (lead == null)
{
throw new Exception("ไม่พบข้อมูล Lead ในระบบ, TicketId " + renew.slm_TicketId);
}
string telNoSms = slmdb.kkslm_tr_cusinfo.Where(p => p.slm_TicketId == lead.slm_ticketId).Select(p => p.slm_TelNoSms).FirstOrDefault();
if (string.IsNullOrWhiteSpace(telNoSms))
{
telNoSms = lead.slm_TelNo_1;
}
string template = File.ReadAllText(AppConstant.SMSTemplatePathReceiveNo, Encoding.UTF8);
string smsMessage = template
.Replace("%CoverageType%", coverage.slm_ConverageTypeName?.Trim() ?? "")
.Replace("%CarLicenseNo%", renew.slm_LicenseNo?.Trim() ?? "")
.Replace("%InsuranceCompany%", insuranceCompany.InsNameTH?.Trim() ?? "")
.Replace("%ReceiveNo%", renew.slm_ReceiveNo?.Trim() ?? "")
.Replace("%InsuranceTelNo%", insuranceCompany.TelContact?.Trim() ?? "");
//kkslm_tr_prelead_prepare_sms sms = InitSMS(smsMessage, telNoSms, renew.slm_TicketId, _dbNow);
var sms = new kkslm_tr_prelead_prepare_sms
{
slm_ticketId = renew.slm_TicketId,
slm_Prelead_Id = null,
slm_Message = smsMessage,
slm_Message_CreatedBy = "SYSTEM",
slm_MessageStatusId = "1",
slm_PhoneNumber = telNoSms,
slm_QueueId = "6",
slm_RequestDate = DateTime.Now,
slm_RuleActivityId = 0,
slm_ExportStatus = "0",
slm_RefId = null,
slm_SendingStatusCode = null,
slm_SendingStatus = null,
slm_ErrorCode = null,
slm_ErrorReason = null,
slm_CAS_Flag = null,
slm_CAS_Date = null,
slm_FlagType = "1",
slm_CreatedBy = "SYSTEM",
slm_CreatedDate = DateTime.Now,
slm_UpdatedBy = "SYSTEM",
slm_UpdatedDate = DateTime.Now,
is_Deleted = 0
};
slmdb.kkslm_tr_prelead_prepare_sms.AddObject(sms);
return(smsMessage);
}
catch
{
throw;
}
}
