public List <GuestRegistrationModel> GetGuestList(GuestRegistrationModel model)
{
List <GuestRegistrationModel> listGuestRegistration = new List <GuestRegistrationModel>();
ShomaRMEntities db = new ShomaRMEntities();
try
{
DataTable dtTable = new DataTable();
using (var cmd = db.Database.Connection.CreateCommand())
{
db.Database.Connection.Open();
cmd.CommandText = "usp_GetGuestList";
cmd.CommandType = CommandType.StoredProcedure;
DbParameter param1 = cmd.CreateParameter();
param1.ParameterName = "TenantID";
param1.Value = model.TenantID;
cmd.Parameters.Add(param1);
DbDataAdapter da = DbProviderFactories.GetFactory("System.Data.SqlClient").CreateDataAdapter();
da.SelectCommand = cmd;
da.Fill(dtTable);
db.Database.Connection.Close();
}
foreach (DataRow dr in dtTable.Rows)
{
GuestRegistrationModel pr = new GuestRegistrationModel();
pr.GuestID = Convert.ToInt64(dr["GuestId"].ToString());
pr.FirstName = dr["FirstName"].ToString();
pr.LastName = dr["LastName"].ToString();
pr.Address = dr["Address"].ToString();
pr.Phone = dr["Phone"].ToString();
pr.Email = dr["Email"].ToString();
pr.VisitStartDate = Convert.ToDateTime(dr["VisitStartDate"].ToString());
pr.VisitEndDate = Convert.ToDateTime(dr["VisitEndDate"].ToString());
pr.VehicleMake = dr["VehicleMake"].ToString();
pr.VehicleModel = dr["VehicleModel"].ToString();
pr.Tag = dr["Tag"].ToString();
pr.DriverLicence = dr["DriverLicence"].ToString();
pr.VehicleRegistration = dr["VehicleRegistration"].ToString();
pr.TenantID = Convert.ToInt64(dr["TenantID"].ToString());
pr.OriginalDriverLicence = dr["OriginalDriverLicence"].ToString();
pr.OriginalVehicleRegistration = dr["OriginalVehicleRegistration"].ToString();
pr.TenantName = dr["TenantName"].ToString();
pr.VisitStartDateString = dr["VisitStartDate"].ToString();
pr.VisitEndDateString = dr["VisitEndDate"].ToString();
pr.StatusString = dr["Status"].ToString();
listGuestRegistration.Add(pr);
}
db.Dispose();
return(listGuestRegistration.ToList());
}
catch (Exception ex)
{
db.Database.Connection.Close();
throw ex;
}
}
public GuestRegistrationModel goToGuestDetails(long GuestID)
{
GuestRegistrationModel model = new GuestRegistrationModel();
ShomaRMEntities db = new ShomaRMEntities();
var getTenantGuest = db.tbl_GuestRegistration.Where(co => co.GuestID == GuestID).FirstOrDefault();
if (getTenantGuest != null)
{
var tenantInfo = db.tbl_TenantInfo.Where(co => co.TenantID == getTenantGuest.TenantID).FirstOrDefault();
if (tenantInfo != null)
{
var getUnit = db.tbl_PropertyUnits.Where(co => co.UID == tenantInfo.UnitID).FirstOrDefault();
if (getUnit != null)
{
model.UnitNo = getUnit.UnitNo;
}
model.TenantName = tenantInfo.FirstName + " " + tenantInfo.LastName;
model.GuestName = getTenantGuest.FirstName + " " + getTenantGuest.LastName;
model.VehicleMake = getTenantGuest.VehicleMake;
model.VehicleModel = getTenantGuest.VehicleModel;
model.Tag = getTenantGuest.Tag;
model.Email = getTenantGuest.Email;
model.FirstName = getTenantGuest.FirstName;
model.LastName = getTenantGuest.LastName;
model.Address = getTenantGuest.Address;
model.Phone = getTenantGuest.Phone;
model.VisitStartDateString = getTenantGuest.VisitStartDate.Value.ToString("MM/dd/yyyy");
model.VisitEndDateString = getTenantGuest.VisitEndDate.Value.ToString("MM/dd/yyyy");
model.OriginalDriverLicence = getTenantGuest.OriginalDriverLicence;
model.DriverLicence = getTenantGuest.DriverLicence;
model.OriginalVehicleRegistration = getTenantGuest.OriginalVehicleRegistration;
model.VehicleRegistration = getTenantGuest.VehicleRegistration;
model.HaveVehicleString = getTenantGuest.HaveVehicle == true ? "Yes" : getTenantGuest.HaveVehicle == false ? "No" : "";
model.Status = getTenantGuest.Status;
model.StatusString = getTenantGuest.Status == 1 ? "Approved" : getTenantGuest.Status == 2 ? "Decline" : getTenantGuest.Status == 0 ? "" : "";
}
}
db.Dispose();
return(model);
}
public string StatusUpdate(GuestRegistrationModel model)
{
string msg = "";
ShomaRMEntities db = new ShomaRMEntities();
int userid = ShomaRM.Models.ShomaGroupWebSession.CurrentUser != null ? ShomaRM.Models.ShomaGroupWebSession.CurrentUser.UserID : 0;
var UpdateStatus = db.tbl_GuestRegistration.Where(co => co.GuestID == model.GuestID).FirstOrDefault();
if (UpdateStatus != null)
{
UpdateStatus.Status = model.Status;
UpdateStatus.ApprovedBy = userid;
db.SaveChanges();
msg = "Guest Status Update Successfully";
var tenantInfo = db.tbl_TenantInfo.Where(co => co.TenantID == UpdateStatus.TenantID).FirstOrDefault();
string message = "";
string phonenumber = tenantInfo.Mobile;
if (model.Status != 2)
{
if (model.HaveVehicleString == "Yes")
{
string reportHTML = "";
string filePath = HttpContext.Current.Server.MapPath("~/Content/Templates/");
//reportHTML = System.IO.File.ReadAllText(filePath + "EmailTemplateAmenity.html");
reportHTML = System.IO.File.ReadAllText(filePath + "EmailTemplateProspect.html");
reportHTML = reportHTML.Replace("[%ServerURL%]", ServerURL);
reportHTML = reportHTML.Replace("[%TodayDate%]", DateTime.Now.ToString("dddd,dd MMMM yyyy"));
string emailBody = "";
emailBody += "<p style=\"margin-bottom: 0px;\">Dear " + model.TenantName + "</p>";
emailBody += "<p style=\"margin-bottom: 0px;\">We thank you for your request and We are pleased to confirm your guest reservation on " + model.VisitStartDateString + " to " + model.VisitEndDateString + " for guest " + model.GuestName + "and your Tag Information is " + model.Tag + " </p>";
reportHTML = reportHTML.Replace("[%EmailBody%]", emailBody);
//reportHTML = reportHTML.Replace("[%TenantName%]", model.TenantName);
//reportHTML = reportHTML.Replace("[%EmailBody%]", " <p style='font-size: 14px; line-height: 21px; text-align: justify; margin: 0;'> We thank you for your request and We are pleased to confirm your guest reservation on " + model.VisitStartDateString + " to " + model.VisitEndDateString + " for guest " + model.GuestName + "and your Tag Information is " + model.Tag + " </p>");
//reportHTML = reportHTML.Replace("[%LeaseNowButton%]", "");
string body = reportHTML;
new EmailSendModel().SendEmail(tenantInfo.Email, "Your Request for Guest Registration is Confirmed ", body);
message = "Thank you for your guest reservation request. We will inform you on email. Please check the email for detail.";
if (SendMessage == "yes")
{
if (!string.IsNullOrWhiteSpace(phonenumber))
{
new TwilioService().SMS(phonenumber, message);
}
}
}
else
{
string reportHTMLTag = "";
string filePathTag = HttpContext.Current.Server.MapPath("~/Content/Templates/");
//reportHTMLTag = System.IO.File.ReadAllText(filePathTag + "EmailTemplateAmenity.html");
reportHTMLTag = System.IO.File.ReadAllText(filePathTag + "EmailTemplateProspect.html");
reportHTMLTag = reportHTMLTag.Replace("[%ServerURL%]", ServerURL);
reportHTMLTag = reportHTMLTag.Replace("[%TodayDate%]", DateTime.Now.ToString("dddd,dd MMMM yyyy"));
string emailBody = "";
emailBody += "<p style=\"margin-bottom: 0px;\">Dear " + model.TenantName + "</p>";
emailBody += "<p style=\"margin-bottom: 0px;\">We thank you for your request and We are pleased to confirm your guest reservation on " + model.VisitStartDateString + " to " + model.VisitEndDateString + " for guest " + model.GuestName + ".</p>";
reportHTMLTag = reportHTMLTag.Replace("[%EmailBody%]", emailBody);
//reportHTMLTag = reportHTMLTag.Replace("[%TenantName%]", model.TenantName);
//reportHTMLTag = reportHTMLTag.Replace("[%EmailBody%]", " <p style='font-size: 14px; line-height: 21px; text-align: justify; margin: 0;'> We thank you for your request and We are pleased to confirm your guest reservation on " + model.VisitStartDateString + " to " + model.VisitEndDateString + " for guest " + model.GuestName + ". </p>");
//reportHTMLTag = reportHTMLTag.Replace("[%LeaseNowButton%]", "");
string bodyTAg = reportHTMLTag;
new EmailSendModel().SendEmail(tenantInfo.Email, "Your Request for Guest Registration is Confirmed. ", bodyTAg);
message = "Thank you for your guest reservation request. We will inform you on email. Please check the email for detail.";
if (SendMessage == "yes")
{
if (!string.IsNullOrWhiteSpace(phonenumber))
{
new TwilioService().SMS(phonenumber, message);
}
}
}
}
else
{
string reportHTMLTag = "";
string filePathTag = HttpContext.Current.Server.MapPath("~/Content/Templates/");
//reportHTMLTag = System.IO.File.ReadAllText(filePathTag + "EmailTemplateAmenity.html");
reportHTMLTag = System.IO.File.ReadAllText(filePathTag + "EmailTemplateProspect.html");
reportHTMLTag = reportHTMLTag.Replace("[%ServerURL%]", ServerURL);
reportHTMLTag = reportHTMLTag.Replace("[%TodayDate%]", DateTime.Now.ToString("dddd,dd MMMM yyyy"));
string emailBody = "";
emailBody += "<p style=\"margin-bottom: 0px;\">Dear " + model.TenantName + "</p>";
emailBody += "<p style=\"margin-bottom: 0px;\">I would like to inform you that Your Request is Decline For Guest " + model.GuestName + " due to some reason please contact the Administrator.</p>";
reportHTMLTag = reportHTMLTag.Replace("[%EmailBody%]", emailBody);
//reportHTMLTag = reportHTMLTag.Replace("[%TenantName%]", model.TenantName);
//reportHTMLTag = reportHTMLTag.Replace("[%EmailBody%]", " <p style='font-size: 14px; line-height: 21px; text-align: justify; margin: 0;'> I would like to inform you that Your Request is Decline For Guest " + model.GuestName + " due to some reason please contact the Administrator. </p>");
//reportHTMLTag = reportHTMLTag.Replace("[%LeaseNowButton%]", "");
string bodyTAg = reportHTMLTag;
new EmailSendModel().SendEmail(tenantInfo.Email, "Your Request for Guest Registration is Decline. ", bodyTAg);
message = "Your status regarding guest reservation is sent on email. Please check the email for detail.";
if (SendMessage == "yes")
{
if (!string.IsNullOrWhiteSpace(phonenumber))
{
new TwilioService().SMS(phonenumber, message);
}
}
}
}
db.Dispose();
return(msg);
}
public string SaveUpdateGuestRegistration(GuestRegistrationModel model)
{
ShomaRMEntities db = new ShomaRMEntities();
string Msg = "";
if (model.GuestID == 0)
{
var saveGuestRegistration = new tbl_GuestRegistration()
{
FirstName = model.FirstName,
LastName = model.LastName,
Address = model.Address,
Phone = model.Phone,
Email = model.Email,
VisitStartDate = model.VisitStartDate,
VisitEndDate = model.VisitEndDate,
VehicleMake = model.VehicleMake,
VehicleModel = model.VehicleModel,
Tag = model.Tag,
DriverLicence = model.DriverLicence,
VehicleRegistration = model.VehicleRegistration,
TenantID = model.TenantID,
OriginalDriverLicence = model.OriginalDriverLicence,
OriginalVehicleRegistration = model.OriginalVehicleRegistration,
HaveVehicle = model.HaveVehicle,
Status = 0
};
db.tbl_GuestRegistration.Add(saveGuestRegistration);
db.SaveChanges();
var guestID = saveGuestRegistration.GuestID;
db.Dispose();
Msg = "Progress Saved | " + guestID;
}
else
{
var updateGuestRegistration = db.tbl_GuestRegistration.Where(co => co.GuestID == model.GuestID).FirstOrDefault();
if (updateGuestRegistration != null)
{
updateGuestRegistration.FirstName = model.FirstName;
updateGuestRegistration.LastName = model.LastName;
updateGuestRegistration.Address = model.Address;
updateGuestRegistration.Phone = model.Phone;
updateGuestRegistration.Email = model.Email;
updateGuestRegistration.VisitStartDate = model.VisitStartDate;
updateGuestRegistration.VisitEndDate = model.VisitEndDate;
updateGuestRegistration.VehicleMake = model.VehicleMake;
updateGuestRegistration.VehicleModel = model.VehicleModel;
updateGuestRegistration.Tag = model.Tag;
updateGuestRegistration.DriverLicence = model.DriverLicence;
updateGuestRegistration.VehicleRegistration = model.VehicleRegistration;
updateGuestRegistration.TenantID = model.TenantID;
updateGuestRegistration.OriginalDriverLicence = model.OriginalDriverLicence;
updateGuestRegistration.OriginalVehicleRegistration = model.OriginalVehicleRegistration;
updateGuestRegistration.HaveVehicle = model.HaveVehicle;
db.SaveChanges();
db.Dispose();
Msg = "Progress Updated";
}
}
return(Msg);
}
public GuestRegistrationModel UploadGuestVehicleRegistration(HttpPostedFileBase fileBaseGuestVehicleRegistration, GuestRegistrationModel model)
{
ShomaRMEntities db = new ShomaRMEntities();
string filePath = "";
string fileName = "";
string sysFileName = "";
string Extension = "";
if (fileBaseGuestVehicleRegistration != null && fileBaseGuestVehicleRegistration.ContentLength > 0)
{
filePath = HttpContext.Current.Server.MapPath("~/Content/assets/img/TenantGuestInformation/");
DirectoryInfo di = new DirectoryInfo(filePath);
FileInfo _FileInfo = new FileInfo(filePath);
if (!di.Exists)
{
di.Create();
}
fileName = fileBaseGuestVehicleRegistration.FileName;
Extension = Path.GetExtension(fileBaseGuestVehicleRegistration.FileName);
sysFileName = DateTime.Now.ToFileTime().ToString() + Path.GetExtension(fileBaseGuestVehicleRegistration.FileName);
fileBaseGuestVehicleRegistration.SaveAs(filePath + "//" + sysFileName);
if (!string.IsNullOrWhiteSpace(fileBaseGuestVehicleRegistration.FileName))
{
string afileName = HttpContext.Current.Server.MapPath("~/Content/assets/img/TenantGuestInformation/") + "/" + sysFileName;
}
model.VehicleRegistration = sysFileName;
model.OriginalVehicleRegistration = fileName;
}
return(model);
}
