public bool SaveBookAppointment(int appointmentId, AspxCommonInfo aspxCommonObj, BookAnAppointmentCoreInfo obj)
{
var isSuccess = false;
try
{
AspxServiceProvider objService = new AspxServiceProvider();
objService.SaveBookAppointment(appointmentId, aspxCommonObj, obj);
isSuccess = true;
}
catch (Exception)
{
isSuccess = false;
}
return isSuccess;
}
public bool SaveBookAppointment(int appointmentId, AspxCommonInfo aspxCommonObj, BookAnAppointmentCoreInfo obj)
{
var isSuccess = false;
try
{
AspxServiceProvider objService = new AspxServiceProvider();
objService.SaveBookAppointment(appointmentId, aspxCommonObj, obj);
isSuccess = true;
}
catch (Exception)
{
isSuccess = false;
}
return(isSuccess);
}
public void SendMailNotificatiion(int storeId, int portalId, string cultureName, BookAnAppointmentCoreInfo objInfo)
{
StoreSettingConfig ssc = new StoreSettingConfig();
string logosrc = ssc.GetStoreSettingsByKey(StoreSetting.StoreLogoURL, storeId, portalId, cultureName);
string name = "Appointment Approval - Email";
List <KeyValuePair <string, object> > parameter = new List <KeyValuePair <string, object> >();
parameter.Add(new KeyValuePair <string, object>("PortalID", portalId));
parameter.Add(new KeyValuePair <string, object>("CultureName", cultureName));
parameter.Add(new KeyValuePair <string, object>("MessageTemplateTypeName", name));
OracleHandler sql = new OracleHandler();
int messageTemplateTypeId = sql.ExecuteNonQuery("usp_Aspx_GetMessageTemplateTypeID", parameter, "MessageTemplateID");
MessageManagementController msgController = new MessageManagementController();
var template = msgController.GetMessageTemplate(messageTemplateTypeId, portalId);
string messageTemplate = template.Body;
string src = HttpContext.Current.Request.ServerVariables["SERVER_NAME"] + "/";
string receiverEmailID = objInfo.Email;
string subject = template.Subject;
string senderEmail = template.MailFrom;
var headerMsg = string.Empty;
var customMessage = "";
if (objInfo.AppointmentID > 0)
{
headerMsg = "status has been modified as follow.";
}
else if (objInfo.AppointmentID == 0)
{
headerMsg = "has been scheduled as following date and time.";
}
if (template != null)
{
string[] tokens = GetAllToken(messageTemplate);
foreach (var token in tokens)
{
switch (token)
{
case "%LogoSource%":
string imgSrc = src + logosrc;
messageTemplate = messageTemplate.Replace(token, imgSrc);
break;
case "%DateTime%":
messageTemplate = messageTemplate.Replace(token, DateTime.Now.ToString("MM/dd/yyyy"));
break;
case "%PreferredDate%":
messageTemplate = messageTemplate.Replace(token, objInfo.PreferredDate.ToString("MM/dd/yyyy"));
break;
case "%PreferredTime%":
messageTemplate = messageTemplate.Replace(token, objInfo.PreferredTime);
break;
case "%PreferredTimeInterval%":
messageTemplate = messageTemplate.Replace(token, objInfo.PreferredTimeInterval);
break;
case "%AppointmentStatus%":
messageTemplate = messageTemplate.Replace(token, objInfo.AppointmentStatusName);
break;
case "%ServerPath%":
messageTemplate = messageTemplate.Replace(token, src);
break;
case "%DateYear%":
messageTemplate = messageTemplate.Replace(token, System.DateTime.Now.Year.ToString());
break;
case "%AppointmentHeadingMessage%":
messageTemplate = messageTemplate.Replace(token, headerMsg);
break;
case "%AppointmentCustomMessage%":
messageTemplate = messageTemplate.Replace(token, customMessage);
break;
case "%ServiceProductName%":
messageTemplate = messageTemplate.Replace(token, objInfo.ServiceProductName);
break;
}
}
}
SageFrameConfig pagebase = new SageFrameConfig();
string emailSuperAdmin = pagebase.GetSettingsByKey(SageFrameSettingKeys.SuperUserEmail);
string emailSiteAdmin = pagebase.GetSettingsByKey(SageFrameSettingKeys.SiteAdminEmailAddress);
MailHelper.SendMailNoAttachment(senderEmail, receiverEmailID, subject, messageTemplate, emailSiteAdmin, emailSuperAdmin);
}
public bool SaveBookAppointment(int appointmentId, AspxCommonInfo aspxCommonObj, BookAnAppointmentCoreInfo obj)//upto this 1/13/2013
{
var isSuccess = false;
try
{
List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetParamSPC(aspxCommonObj);
parameter.Add(new KeyValuePair <string, object>("AppointmentID", appointmentId));
parameter.Add(new KeyValuePair <string, object>("OrderID", obj.OrderID));
parameter.Add(new KeyValuePair <string, object>("ServiceCategoryID", obj.ServiceCategoryID));
parameter.Add(new KeyValuePair <string, object>("ServiceProductID", obj.ServiceProductID));
parameter.Add(new KeyValuePair <string, object>("ServiceProductPrice", obj.ServiceProductPrice));
parameter.Add(new KeyValuePair <string, object>("AppointmentStatusID", obj.AppointmentStatusID));
parameter.Add(new KeyValuePair <string, object>("Title", obj.Title));
parameter.Add(new KeyValuePair <string, object>("FirstName", obj.FirstName));
parameter.Add(new KeyValuePair <string, object>("LastName", obj.LastName));
parameter.Add(new KeyValuePair <string, object>("Gender", obj.Gender));
parameter.Add(new KeyValuePair <string, object>("Mobile", obj.MobileNumber));
parameter.Add(new KeyValuePair <string, object>("Phone", obj.PhoneNumber));
parameter.Add(new KeyValuePair <string, object>("Email", obj.Email));
parameter.Add(new KeyValuePair <string, object>("PreferredDateID", obj.ServiceDateId));
parameter.Add(new KeyValuePair <string, object>("PreferredDate", obj.PreferredDate));
parameter.Add(new KeyValuePair <string, object>("PreferredTime", obj.PreferredTime));
parameter.Add(new KeyValuePair <string, object>("TypeOfTreatment", obj.TypeOfTreatment));
parameter.Add(new KeyValuePair <string, object>("StoreLocation", obj.StoreLocation));
parameter.Add(new KeyValuePair <string, object>("CustomerType", obj.TypeOfCustomer));
parameter.Add(new KeyValuePair <string, object>("MembershipElite", obj.MembershipElite));
parameter.Add(new KeyValuePair <string, object>("UserName", obj.UserName));
parameter.Add(new KeyValuePair <string, object>("PaymentMethodID", obj.PaymentMethodID));
parameter.Add(new KeyValuePair <string, object>("PreferredTimeInterval", obj.PreferredTimeInterval));
parameter.Add(new KeyValuePair <string, object>("PreferredTimeID", obj.PreferredTimeId));
parameter.Add(new KeyValuePair <string, object>("EmployeeID", obj.EmployeeID));
OracleHandler sqlh = new OracleHandler();
sqlh.ExecuteNonQuery("usp_Aspx_AddAppointment", parameter);
if (appointmentId != 0 && obj.AppointmentStatusName.ToLower() == "completed")
{
SendMailNotificatiion(aspxCommonObj.StoreID, aspxCommonObj.PortalID, aspxCommonObj.CultureName, obj);
}
else if (appointmentId == 0 && obj.AppointmentStatusName.ToLower() == "pending")
{
SendMailNotificatiion(aspxCommonObj.StoreID, aspxCommonObj.PortalID, aspxCommonObj.CultureName, obj);
}
isSuccess = true;
}
catch (Exception)
{
isSuccess = false;
// throw ex;
}
return(isSuccess);
}
public void SendMailNotificatiion(int storeId, int portalId, string cultureName, BookAnAppointmentCoreInfo objInfo)
{
StoreSettingConfig ssc = new StoreSettingConfig();
string logosrc = ssc.GetStoreSettingsByKey(StoreSetting.StoreLogoURL, storeId, portalId, cultureName);
string name = "Appointment Approval - Email";
List<KeyValuePair<string, object>> parameter = new List<KeyValuePair<string, object>>();
parameter.Add(new KeyValuePair<string, object>("@PortalID", portalId));
parameter.Add(new KeyValuePair<string, object>("@CultureName", cultureName));
parameter.Add(new KeyValuePair<string, object>("@MessageTemplateTypeName", name));
SQLHandler sql = new SQLHandler();
int messageTemplateTypeId = sql.ExecuteNonQuery("[dbo].[usp_Aspx_GetMessageTemplateTypeID]", parameter, "@MessageTemplateID");
MessageManagementController msgController = new MessageManagementController();
var template = msgController.GetMessageTemplate(messageTemplateTypeId, portalId);
string messageTemplate = template.Body;
string src = HttpContext.Current.Request.ServerVariables["SERVER_NAME"] + "/";
string receiverEmailID = objInfo.Email;
string subject = template.Subject;
string senderEmail = template.MailFrom;
var headerMsg = string.Empty;
var customMessage = "";
if (objInfo.AppointmentID > 0)
{
headerMsg = "status has been modified as follow.";
}
else if (objInfo.AppointmentID == 0)
{
headerMsg = "has been scheduled as following date and time.";
}
if (template != null)
{
string[] tokens = GetAllToken(messageTemplate);
foreach (var token in tokens)
{
switch (token)
{
case "%LogoSource%":
string imgSrc = src + logosrc;
messageTemplate = messageTemplate.Replace(token, imgSrc);
break;
case "%DateTime%":
messageTemplate = messageTemplate.Replace(token, DateTime.Now.ToString("MM/dd/yyyy"));
break;
case "%PreferredDate%":
messageTemplate = messageTemplate.Replace(token, objInfo.PreferredDate.ToString("MM/dd/yyyy"));
break;
case "%PreferredTime%":
messageTemplate = messageTemplate.Replace(token, objInfo.PreferredTime);
break;
case "%PreferredTimeInterval%":
messageTemplate = messageTemplate.Replace(token, objInfo.PreferredTimeInterval);
break;
case "%AppointmentStatus%":
messageTemplate = messageTemplate.Replace(token, objInfo.AppointmentStatusName);
break;
case "%ServerPath%":
messageTemplate = messageTemplate.Replace(token, src);
break;
case "%DateYear%":
messageTemplate = messageTemplate.Replace(token, System.DateTime.Now.Year.ToString());
break;
case "%AppointmentHeadingMessage%":
messageTemplate = messageTemplate.Replace(token, headerMsg);
break;
case "%AppointmentCustomMessage%":
messageTemplate = messageTemplate.Replace(token, customMessage);
break;
case "%ServiceProductName%":
messageTemplate = messageTemplate.Replace(token, objInfo.ServiceProductName);
break;
}
}
}
SageFrameConfig pagebase = new SageFrameConfig();
string emailSuperAdmin = pagebase.GetSettingsByKey(SageFrameSettingKeys.SuperUserEmail);
string emailSiteAdmin = pagebase.GetSettingsByKey(SageFrameSettingKeys.SiteAdminEmailAddress);
MailHelper.SendMailNoAttachment(senderEmail, receiverEmailID, subject, messageTemplate, emailSiteAdmin, emailSuperAdmin);
}
public bool SaveBookAppointment(int appointmentId, AspxCommonInfo aspxCommonObj, BookAnAppointmentCoreInfo obj)//upto this 1/13/2013
{
var isSuccess = false;
try
{
List<KeyValuePair<string, object>> parameter = CommonParmBuilder.GetParamSPC(aspxCommonObj);
parameter.Add(new KeyValuePair<string, object>("@AppointmentID", appointmentId));
parameter.Add(new KeyValuePair<string, object>("@OrderID", obj.OrderID));
parameter.Add(new KeyValuePair<string, object>("@ServiceCategoryID", obj.ServiceCategoryID));
parameter.Add(new KeyValuePair<string, object>("@ServiceProductID", obj.ServiceProductID));
parameter.Add(new KeyValuePair<string, object>("@ServiceProductPrice", obj.ServiceProductPrice));
parameter.Add(new KeyValuePair<string, object>("@AppointmentStatusID", obj.AppointmentStatusID));
parameter.Add(new KeyValuePair<string, object>("@Title", obj.Title));
parameter.Add(new KeyValuePair<string, object>("@FirstName", obj.FirstName));
parameter.Add(new KeyValuePair<string, object>("@LastName", obj.LastName));
parameter.Add(new KeyValuePair<string, object>("@Gender", obj.Gender));
parameter.Add(new KeyValuePair<string, object>("@Mobile", obj.MobileNumber));
parameter.Add(new KeyValuePair<string, object>("@Phone", obj.PhoneNumber));
parameter.Add(new KeyValuePair<string, object>("@Email", obj.Email));
parameter.Add(new KeyValuePair<string, object>("@PreferredDateID", obj.ServiceDateId));
parameter.Add(new KeyValuePair<string, object>("@PreferredDate", obj.PreferredDate));
parameter.Add(new KeyValuePair<string, object>("@PreferredTime", obj.PreferredTime));
parameter.Add(new KeyValuePair<string, object>("@TypeOfTreatment", obj.TypeOfTreatment));
parameter.Add(new KeyValuePair<string, object>("@StoreLocation", obj.StoreLocation));
parameter.Add(new KeyValuePair<string, object>("@CustomerType", obj.TypeOfCustomer));
parameter.Add(new KeyValuePair<string, object>("@MembershipElite", obj.MembershipElite));
parameter.Add(new KeyValuePair<string, object>("@UserName", obj.UserName));
parameter.Add(new KeyValuePair<string, object>("@PaymentMethodID", obj.PaymentMethodID));
parameter.Add(new KeyValuePair<string, object>("@PreferredTimeInterval", obj.PreferredTimeInterval));
parameter.Add(new KeyValuePair<string, object>("@PreferredTimeID", obj.PreferredTimeId));
parameter.Add(new KeyValuePair<string, object>("@EmployeeID", obj.EmployeeID));
SQLHandler sqlh = new SQLHandler();
sqlh.ExecuteNonQuery("[dbo].[usp_Aspx_AddAppointment]", parameter);
if (appointmentId != 0 && obj.AppointmentStatusName.ToLower() == "completed")
{
SendMailNotificatiion(aspxCommonObj.StoreID, aspxCommonObj.PortalID, aspxCommonObj.CultureName, obj);
}
else if (appointmentId == 0 && obj.AppointmentStatusName.ToLower() == "pending")
{
SendMailNotificatiion(aspxCommonObj.StoreID, aspxCommonObj.PortalID, aspxCommonObj.CultureName, obj);
}
isSuccess = true;
}
catch (Exception)
{
isSuccess = false;
// throw ex;
}
return isSuccess;
}