public String SaveUpdateTenantPet(TenantPetListModel model)
{
string msg = "";
ShomaRMEntities db = new ShomaRMEntities();
if (model.PetID != 0)
{
var TenantPetInfo = db.tbl_TenantPet.Where(p => p.PetID == model.PetID).FirstOrDefault();
if (TenantPetInfo != null)
{
TenantPetInfo.Breed = model.Breed;
TenantPetInfo.Weight = model.Weight;
TenantPetInfo.Age = model.Age;
TenantPetInfo.PetName = model.PetName;
TenantPetInfo.UniqID = model.UniqID;
TenantPetInfo.ExpiryDate = model.ExpiryDate;
db.SaveChanges();
msg = "Pet information updated successfully.</br>";
}
else
{
msg = "Pet information not updated successfully.</br>";
}
}
db.Dispose();
return(msg);
}
public String SendRemainder(TenantPetListModel model)
{
string msg = "";
ShomaRMEntities db = new ShomaRMEntities();
if (model.PetID != 0)
{
var GetTenantPetData = db.tbl_TenantPet.Where(p => p.PetID == model.PetID).FirstOrDefault();
if (GetTenantPetData != null)
{
string expiryDate = "";
try { expiryDate = Convert.ToDateTime(GetTenantPetData.ExpiryDate).ToString("MM/dd/yyyy"); } catch { expiryDate = ""; }
ExpiryDateString = expiryDate;
var TenantInfo = db.tbl_TenantInfo.Where(p => p.ProspectID == GetTenantPetData.TenantID).FirstOrDefault();
if (TenantInfo != null)
{
TenantName = TenantInfo.FirstName + ' ' + TenantInfo.LastName;
Email = TenantInfo.Email;
PhoneNumber = TenantInfo.Mobile;
}
string reportHTML = "";
string filePath = HttpContext.Current.Server.MapPath("~/Content/Templates/");
reportHTML = System.IO.File.ReadAllText(filePath + "EmailTemplateProspect.html");
reportHTML = reportHTML.Replace("[%ServerURL%]", serverURL);
reportHTML = reportHTML.Replace("[%TodayDate%]", DateTime.Now.ToString("dddd,dd MMMM yyyy"));
if (model != null)
{
string emailBody = "";
emailBody += "<p style=\"margin-bottom: 0px;\">Dear " + TenantName + " your pet " + PetName + " vaccination is Expired / Expiring . Please submit new vaccination Certificate</p>";
reportHTML = reportHTML.Replace("[%EmailBody%]", emailBody);
//reportHTML = reportHTML.Replace("[%EmailHeader%]", "Pet Vaccination Certificate Expiry Remainder");
//reportHTML = reportHTML.Replace("[%EmailBody%]", " <p style='font-size: 14px; line-height: 21px; text-align: justify; margin: 0;'> Dear " + TenantName + " your pet " + PetName + " vaccination is Expired / Expiring . Please submit new vaccination Certificate</p>");
//reportHTML = reportHTML.Replace("[%TenantName%]", TenantName);
//reportHTML = reportHTML.Replace("[%TenantEmail%]", Email);
}
string body = reportHTML;
new EmailSendModel().SendEmail(Email, "Pet Vaccination Certificate Expiry Remainder", body);
string message = "Pet Vaccination Certificate Expiry Remainder. Please check the email for detail.";
if (SendMessage == "yes")
{
if (!string.IsNullOrWhiteSpace(PhoneNumber))
{
new TwilioService().SMS(PhoneNumber, message);
}
}
}
msg = "Vaccination Expiry Remainder Send Successfully";
}
return(msg);
}
public String UpdateUniqId(TenantPetListModel model)
{
string msg = "";
ShomaRMEntities db = new ShomaRMEntities();
if (model.PetID != 0)
{
var TenantPetInfo = db.tbl_TenantPet.Where(p => p.PetID == model.PetID).FirstOrDefault();
if (TenantPetInfo != null)
{
TenantPetInfo.UniqID = model.UniqID;
db.SaveChanges();
msg = "Pet information updated successfully.</br>";
}
else
{
msg = "Pet information not updated successfully.</br>";
}
}
db.Dispose();
return(msg);
}
