private string InsertPrepareSMS(SLMDBEntities slmdb, OBT_PRO_32_DataAccess.SMSPaymentDueMessage item)
{
try
{
if (string.IsNullOrEmpty(SMSTemplatePath))
{
throw new Exception($"ไม่พบ Config {nameof(SMSTemplatePath)} ใน Configuration File");
}
string template = File.ReadAllText(SMSTemplatePath, Encoding.UTF8);
string smsMessage = template.Replace("%CarLicenseNo%", string.IsNullOrWhiteSpace(item.LicenseNo) ? "" : item.LicenseNo.Trim())
.Replace("%ExpiredDate%", item.ExpiredDate != null ? item.ExpiredDate.Value.ToString("dd/MM/") + item.ExpiredDate.Value.Year.ToString() : "");
//kkslm_tr_prelead_prepare_sms sms = InitSMS(smsMessage, item.slm_TelNo, item.slm_TicketId, _dbNow, item.slm_Prelead_Id);
var sms = new kkslm_tr_prelead_prepare_sms
{
slm_ticketId = string.IsNullOrWhiteSpace(item.TicketId) ? null : item.TicketId,
slm_Prelead_Id = string.IsNullOrWhiteSpace(item.TicketId) ? item.PreleadId : null,
slm_Message = smsMessage,
slm_Message_CreatedBy = "SYSTEM",
slm_MessageStatusId = "1",
slm_PhoneNumber = item.TelNo.Trim(),
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;
}
}
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;
}
}
private void InsertPrepareSMS(SLMDBEntities slmdb, kkslm_tr_lead lead, kkslm_tr_renewinsurance renew, List <InsuranceCompanyData> insurComList, List <CoverageTypeData> coverageList, DateTime createdDate)
{
try
{
string filePath = AppConstant.SMSTemplatePathPolicyNo;
if (string.IsNullOrWhiteSpace(filePath))
{
throw new Exception("ไม่พบ Config SMSTemplatePathPolicyNo ใน Configuration File");
}
var paidAmount = CalculateTotalPaidAmount(slmdb, renew.slm_TicketId, AppConstant.PaymentCode.Policy);
var coverageTypeName = coverageList.Where(p => p.CoverageTypeId == renew.slm_CoverageTypeId).Select(p => p.CoverageTypeName).FirstOrDefault();
var insurTelNo = insurComList.Where(p => p.InsComId == renew.slm_InsuranceComId).Select(p => p.TelContact).FirstOrDefault();
var insNameAbb = insurComList.Where(p => p.InsComId == renew.slm_InsuranceComId).Select(p => p.InsNameAbb).FirstOrDefault();
string policyStartCoverDate = "";
if (renew.slm_PolicyStartCoverDate != null)
{
policyStartCoverDate = renew.slm_PolicyStartCoverDate.Value.ToString("dd/MM/") + (renew.slm_PolicyStartCoverDate.Value.Year + 543).ToString().Substring(2, 2);
}
string template = File.ReadAllText(filePath, Encoding.UTF8);
template = template.Replace("%InsNameAbb%", string.IsNullOrWhiteSpace(insNameAbb) ? "" : insNameAbb)
.Replace("%CoverageType%", string.IsNullOrWhiteSpace(coverageTypeName) ? "" : coverageTypeName)
.Replace("%PolicyPremiumPaid%", paidAmount.ToString("#,##0.00"))
.Replace("%PolicyNo%", renew.slm_PolicyNo)
.Replace("%PolicyStartCoverDate%", policyStartCoverDate)
//.Replace("%CarLicenseNo%", renew.slm_LicenseNo)
.Replace("%InsuranceTelNo%", string.IsNullOrWhiteSpace(insurTelNo) ? "" : insurTelNo);
kkslm_tr_prelead_prepare_sms sms = new kkslm_tr_prelead_prepare_sms()
{
slm_ticketId = renew.slm_TicketId,
slm_Message = template,
slm_Message_CreatedBy = "SYSTEM",
slm_MessageStatusId = "1",
slm_PhoneNumber = GetTelNoSMS(lead),
slm_QueueId = "6",
slm_RequestDate = createdDate,
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 = "2",
slm_CreatedBy = "SYSTEM",
slm_CreatedDate = createdDate,
slm_UpdatedBy = "SYSTEM",
slm_UpdatedDate = createdDate,
is_Deleted = 0
};
slmdb.kkslm_tr_prelead_prepare_sms.AddObject(sms);
slmdb.SaveChanges();
}
catch
{
throw;
}
}
