/// <summary>
///
/// </summary>
/// <param name="BusinessObject"></param>
/// <returns></returns>
public string UpdateRestaurantProfile(BusinessObject BusinessObject)
{
CommonDomainLogic commonDomainLogic = new CommonDomainLogic();
tblBusiness business = bringlyEntities.tblBusinesses.Where(x => x.BusinessGuid == BusinessObject.BusinessGuid).FirstOrDefault();
business.BusinessName = BusinessObject.BusinessName;
business.CityGuid = BusinessObject.CityGuid;
business.PNumber = BusinessObject.PNumber;
business.Phone = BusinessObject.Phone;
business.PinCode = BusinessObject.PinCode;
business.ModifiedBy = UserVariables.LoggedInUserGuid;
business.ModifiedDate = DateTime.Now;
business.Address = BusinessObject.Address;
business.Email = BusinessObject.Email;
business.OrderTiming = BusinessObject.OrderTiming;
business.PickUpTiming = BusinessObject.PickUpTiming;
business.ServiceCharge = BusinessObject.ServiceCharge;
business.ServiceTax = BusinessObject.ServiceTax;
business.FlatRate = BusinessObject.FlatRate;
business.RateAfterKm = BusinessObject.RateAfterKm;
business.Description = BusinessObject.Description;
bringlyEntities.SaveChanges();
string cityname = bringlyEntities.tblCities.Where(x => x.CityGuid == BusinessObject.CityGuid).FirstOrDefault().CityName;
return(cityname);
}
/// <summary>
///
/// </summary>
/// <param name="guid"></param>
/// <returns></returns>
public bool SendThankUForSocialSignUpEmail(Guid guid)
{
var user = bringlyEntities.tblUsers.Where(usr => usr.UserGuid == guid && usr.IsDeleted == false).FirstOrDefault();
if (user == null || user.EmailAddress == null)
{
return(false);
}
string currentDomainName = string.Empty;
Utilities.Helper.UtilityHelper.GetHostedDomainName(out currentDomainName);
string imgSrc = CommonDomainLogic.GetCurrentDomain + CommonDomainLogic.GetImagePath(ImageType.User, "bringlylogoemail.png");
EmailDomain emailDomain = new EmailDomain();
emailDomain.EmailTo = user.EmailAddress;
emailDomain.EmailFrom = ConfigurationManager.AppSettings["EmailFrom"];
tblEmailTemplate Template = bringlyEntities.tblEmailTemplates.Where(x => x.TemplateType == "ThankYouSocialSignUp").FirstOrDefault();
if (Template == null)
{
return(false);
}
emailDomain.EmailSubject = Template.Subject;
emailDomain.EmailBody = Template.Body.Replace("{ToName}", user.FullName).Replace("{hostUrl}", currentDomainName).Replace("{logoUrl}", currentDomainName + "/Templates/images/bringlylogoemail.png");
string emailSendResult = EmailSender.sendEmail(emailDomain);
if (!string.IsNullOrEmpty(emailSendResult))
{
ErrorLog.LogError(emailSendResult, "send email Error");
return(false);
}
return(true);
}
/// <summary>
///
/// </summary>
/// <param name="LatestPage"></param>
/// <returns></returns>
public MyEmail GetSentEmail(int LatestPage = 0)
{
MyEmail Email = new MyEmail();
Email.PageSize = PageSize;
Email.CurrentPage = LatestPage > 0 ? LatestPage : CurrentPage;
Email.SortBy = SortBy;
string restaurantimagepath = string.Empty;
var restaurant = bringlyEntities.tblRestaurants.Where(x => x.CreatedByGuid == x.tblUser.UserGuid).FirstOrDefault();
if (restaurant != null)
{
restaurantimagepath = CommonDomainLogic.GetCurrentDomain + CommonDomainLogic.GetImagePath(ImageType.Restaurant, restaurant.RestaurantImage);
}
Email.Emails = bringlyEntities.tblEmails.Where(x => x.FK_CreatedByGuid == UserVariables.LoggedInUserGuid && x.IsDeleted == false && x.Sent == true).
Select(em => new Email
{
EmailGuid = em.EmailGuid,
TemplateGuid = em.FK_TemplateGuid,
Subject = em.Subject,
Body = em.Body,
EmailFrom = em.EmailFrom,
DateCreated = em.DateCreated
,
FromName = em.tblUser.FullName,
ToName = em.tblEmailToes.Where(x => x.FK_UserGuid == x.tblUser.UserGuid).ToList().FirstOrDefault().tblUser.FullName
,
EmailToList = em.tblEmailToes.Where(x => x.FK_UserGuid == x.tblUser.UserGuid).ToList().Select(t => new EmailTo {
UserGuid = t.FK_UserGuid, Name = t.tblUser.FullName
}).ToList()
,
UserImage = em.tblUser.ImageName
}).OrderByDescending(x => x.DateCreated).ToList();
Email.Emails.ForEach(z => z.RestaurantImage = restaurantimagepath);
Email.UnReadCount = bringlyEntities.tblEmailToes.Where(x => x.FK_UserGuid == UserVariables.LoggedInUserGuid && x.IsDeleted == false && x.tblEmail.Sent == true && x.Read == false && x.FK_EmailGuid == x.tblEmail.EmailGuid)
.ToList().Count;
Email.TotalRecords = Email.Emails.Count;
int Skip = 0;
int Take = PageSize;
if (Email.CurrentPage == 1)
{
Skip = 0;
}
else
{
Skip = ((Email.CurrentPage * Email.PageSize) - Email.PageSize);
}
if (Email.TotalRecords == 0 && Skip > 0)
{
Skip = Skip - 1;
}
Email.Emails = Email.Emails.Skip(Skip).Take(Take).ToList();
return(Email);
}
public DeliveryOption GetDeliveryOption(Guid OrderGuid)
{
var deliveryOptionData = (from user in bringlyEntities.tblUsers
join odr in bringlyEntities.tblOrders
on user.UserGuid equals odr.FK_CreatedByGuid
where user.IsDeleted == false && user.IsActive == true && odr.OrderGuid == OrderGuid
select new DeliveryOption
{
UserGuid = user.UserGuid,
UserFullName = user.FullName,
EmailAddress = user.EmailAddress,
MobileNumber = user.MobileNumber,
OrderGuid = OrderGuid,
BillingAddress = user.tblUserAddresses.Where(z => z.IsDeleted == false && z.AddressType.Equals("Billing", StringComparison.OrdinalIgnoreCase)).Select(z => new UserAddress
{
Address = z.Address,
AddressType = z.AddressType,
CountryGuid = z.CountryGuid,
CityGuid = z.FK_CityGuid,
CityName = z.tblCity.CityName,
Country = z.Country,
Latitude = z.Latitude,
Longitude = z.Longitude,
PlaceId = z.PlaceId,
PostCode = z.PostCode,
UserGuid = z.FK_UserGuid
}).FirstOrDefault(),
ShippingAddress = user.tblUserAddresses.Where(z => z.IsDeleted == false && z.AddressType.Equals("Shipping", StringComparison.OrdinalIgnoreCase)).Select(z => new UserAddress
{
Address = z.Address,
AddressType = z.AddressType,
CountryGuid = z.CountryGuid,
CityGuid = z.FK_CityGuid,
CityName = z.tblCity.CityName,
Country = z.Country,
Latitude = z.Latitude,
Longitude = z.Longitude,
PlaceId = z.PlaceId,
PostCode = z.PostCode,
UserGuid = z.FK_UserGuid
}).FirstOrDefault(),
DeliveryType = (OrderType)odr.OrderType
}).FirstOrDefault();
CommonDomainLogic commonDomainLogic = new CommonDomainLogic();
deliveryOptionData.CityList = commonDomainLogic.GetCities();
deliveryOptionData.CountryList = commonDomainLogic.GetCountryList();
return(deliveryOptionData);
}
/// <summary>
///
/// </summary>
/// <param name="businessGuid"></param>
/// <returns></returns>
public BusinessObject GetRestaurantByRestaurantGuid(Guid businessGuid)
{
BusinessObject business = new BusinessObject();
CommonDomainLogic commonDomainLogic = new CommonDomainLogic();
List <City> list = commonDomainLogic.GetCities();
business = bringlyEntities.tblBusinesses.Where(x => x.BusinessGuid == businessGuid).Select(r => new BusinessObject
{
BusinessImage = r.BusinessImage
,
BusinessGuid = r.BusinessGuid
,
BusinessName = r.BusinessName
,
CityGuid = r.CityGuid
,
BusinessTypeGuid = r.FK_BusinessTypeGuid
,
PNumber = r.PNumber
,
Phone = r.Phone
,
PinCode = r.PinCode
,
CreatedByGuid = r.FK_CreatedByGuid
,
ManagerGuid = r.ManagerUserGuid
,
Address = r.Address
,
Email = r.Email
,
OrderTiming = r.OrderTiming
,
PickUpTiming = r.PickUpTiming
,
ServiceCharge = r.ServiceCharge
,
ServiceTax = r.ServiceTax
,
FlatRate = r.FlatRate
,
RateAfterKm = r.RateAfterKm
,
Description = r.Description
}).FirstOrDefault();
business.CityList = list;
business.CityName = business.CityGuid != Guid.Empty ? bringlyEntities.tblCities.Where(x => x.CityGuid == business.CityGuid).FirstOrDefault().CityName : "";
return(business);
}
/// <summary>
///
/// </summary>
/// <returns></returns>
public City GetPreferedCity()
{
UserDomainLogic _userDomainLogic = new UserDomainLogic();
CommonDomainLogic commonDomainLogic = new CommonDomainLogic();
City _City = new City();
UserProfile _FindUser = _userDomainLogic.FindUser(UserVariables.LoggedInUserGuid);
if (_FindUser == null && string.IsNullOrEmpty(_FindUser.PreferedCity))
{
_City = new City();
}
else
{
if (string.IsNullOrEmpty(_FindUser.PreferedCity))
{
_FindUser.PreferedCity = bringlyEntities.tblCities.Where(x => x.IsDeleted == false).ToList().FirstOrDefault().CityGuid.ToString();
}
_City = commonDomainLogic.GetCityByGUID(new Guid(_FindUser.PreferedCity)).FirstOrDefault();
}
return(_City);
}
/// <summary>
///
/// </summary>
/// <param name="Request"></param>
/// <returns></returns>
public string UploadMenuItemImage(HttpRequestBase Request)
{
tblUser user = bringlyEntities.tblUsers.Where(x => x.UserGuid == UserVariables.LoggedInUserGuid).FirstOrDefault();
string imageName = "";
string imageLocation = "";
if (Request.Files.Count > 0)
{
Items item = new Items();
for (int i = 0; i < Request.Files.Count; i++)
{
imageName = Path.GetFileName("Item_" + Guid.NewGuid() + Path.GetExtension(Request.Files[i].FileName));
imageLocation = CommonDomainLogic.GetImagePath(Domain.Enums.ImageType.Item, imageName);
Request.Files[i].SaveAs(HttpContext.Current.Server.MapPath(imageLocation));
}
item.ItemImage = imageName;
return(imageLocation);
}
else
{
return(imageLocation);
}
}
/// <summary>
///
/// </summary>
/// <param name="LatestPage"></param>
/// <param name="searchQuery"></param>
/// <param name="sortBy"></param>
/// <returns></returns>
public MyEmail GetInboxEmail(int LatestPage = 0, string searchQuery = "", string sortBy = "lto")
{
MyEmail Email = new MyEmail();
Email.PageSize = PageSize;
Email.CurrentPage = LatestPage > 0 ? LatestPage : CurrentPage;; //ViewBag.CurrentPage
Email.SortBy = SortBy;
string restaurantimagepath = string.Empty;
var restaurant = bringlyEntities.tblRestaurants.Where(x => x.CreatedByGuid == x.tblUser.UserGuid).FirstOrDefault();
var temp = bringlyEntities.tblBusinesses.Where(x => x.FK_CreatedByGuid == x.tblUser.UserGuid).FirstOrDefault();
if (restaurant != null)
{
restaurantimagepath = CommonDomainLogic.GetCurrentDomain + CommonDomainLogic.GetImagePath(ImageType.Restaurant, restaurant.RestaurantImage);
}
else
{
restaurantimagepath = CommonDomainLogic.GetCurrentDomain + CommonDomainLogic.GetImagePath(null, null);
}
var data = bringlyEntities.tblEmailToes
.Where(x => x.FK_EmailGuid == x.tblEmail.EmailGuid && x.IsDeleted == false && x.FK_UserGuid == UserVariables.LoggedInUserGuid);
if (!string.IsNullOrEmpty(searchQuery))
{
data = data.Where(x => x.tblEmail.Subject.Contains(searchQuery));
}
if (sortBy != null && sortBy.Equals("otl"))
{
Email.Emails = data.Select(em => new Email
{
EmailGuid = em.tblEmail.EmailGuid,
TemplateGuid = em.tblEmail.FK_TemplateGuid,
Subject = em.tblEmail.Subject,
Body = em.tblEmail.Body,
EmailFrom = em.tblEmail.EmailFrom,
DateCreated = em.tblEmail.DateCreated,
FromName = bringlyEntities.tblUsers.Where(zx => zx.UserGuid == em.tblEmail.FK_CreatedByGuid).FirstOrDefault().FullName,
Read = em.Read,
ToName = em.tblUser.FullName,
UserImage = bringlyEntities.tblUsers.Where(zx => zx.UserGuid == em.tblEmail.FK_CreatedByGuid).FirstOrDefault().ImageName
})
.OrderBy(x => x.DateCreated)
.ToList()
.OrderBy(x => x.Read == false)
.ToList();
}
else
{
Email.Emails = data
.Select(em => new Email
{
EmailGuid = em.tblEmail.EmailGuid,
TemplateGuid = em.tblEmail.FK_TemplateGuid,
Subject = em.tblEmail.Subject,
Body = em.tblEmail.Body,
EmailFrom = em.tblEmail.EmailFrom,
DateCreated = em.tblEmail.DateCreated,
FromName = bringlyEntities.tblUsers.Where(zx => zx.UserGuid == em.tblEmail.FK_CreatedByGuid).FirstOrDefault().FullName,
Read = em.Read,
ToName = em.tblUser.FullName,
UserImage = bringlyEntities.tblUsers.Where(zx => zx.UserGuid == em.tblEmail.FK_CreatedByGuid).FirstOrDefault().ImageName
})
.OrderByDescending(x => x.DateCreated)
.ToList()
.OrderByDescending(x => x.Read == false)
.ToList();
}
Email.Emails.ForEach(z => z.RestaurantImage = restaurantimagepath);
Email.UnReadCount = bringlyEntities.tblEmailToes.Where(x => x.FK_UserGuid == UserVariables.LoggedInUserGuid &&
x.IsDeleted == false && x.tblEmail.Sent == true && x.Read == false && x.FK_EmailGuid == x.tblEmail.EmailGuid)
.ToList().Count;
Email.TotalRecords = Email.Emails.Count;
int Skip = 0;
int Take = PageSize;
if (Email.CurrentPage == 1)
{
Skip = 0;
}
else
{
Skip = ((Email.CurrentPage * Email.PageSize) - Email.PageSize);
}
Email.Emails = Email.Emails.Skip(Skip).Take(Take).ToList();
return(Email);
}
/// <summary>
///
/// </summary>
/// <param name="ComposeEmail"></param>
/// <returns></returns>
public bool SendEmail(ComposeEmail ComposeEmail)
{
EmailDomain EmailDomain = new EmailDomain();
tblUser userfrom = bringlyEntities.tblUsers.Where(x => x.UserGuid == UserVariables.LoggedInUserGuid).ToList().FirstOrDefault();
tblEmailTemplate template = new tblEmailTemplate();
BusinessObject tblBusiness = new BusinessObject();
string image = "<img src = " + CommonDomainLogic.GetCurrentDomain + CommonDomainLogic.GetImagePath(ImageType.Default, "") + ">";
string UserImageName = userfrom.ImageName;
int count = 0;
if (ComposeEmail.EmailToGuid != null && ComposeEmail.EmailToGuid.Count() > 0)
{
foreach (string usertoguid in ComposeEmail.EmailToGuid)
{
tblUser userto = bringlyEntities.tblUsers.Where(x => x.UserGuid == new Guid(usertoguid)).ToList().FirstOrDefault();
EmailDomain.EmailTo = userto.EmailAddress;
template = !string.IsNullOrEmpty(ComposeEmail.EmailMessage.TemplateType) ? bringlyEntities.tblEmailTemplates
.Where(x => x.TemplateType == ComposeEmail.EmailMessage.TemplateType).ToList().FirstOrDefault() : new tblEmailTemplate();
if (template != null && template.TemplateGuid != null && template.TemplateGuid != Guid.Empty)
{
EmailDomain.EmailFrom = userfrom.EmailAddress;
EmailDomain.EmailSubject = ComposeEmail.EmailMessage.Subject;
if (!ComposeEmail.Isemailreplyorforward)
{
tblBusiness = bringlyEntities.tblBusinesses.Where(x => x.FK_CreatedByGuid == UserVariables.LoggedInUserGuid).
Select(s => new BusinessObject {
BusinessImage = s.BusinessImage, BusinessName = s.BusinessName
}).ToList().FirstOrDefault();
EmailDomain.EmailBody = template.Body;
EmailDomain.EmailBody = EmailDomain.EmailBody.Replace("{ToName}", userto.FullName).Replace("{Description}", ComposeEmail.EmailMessage.Body)
.Replace("{FromName}", userfrom.FullName);
}
else
{
EmailDomain.EmailBody = ComposeEmail.EmailMessage.Body;
}
string emailSendResult = EmailSender.sendEmail(EmailDomain);
if (!string.IsNullOrEmpty(emailSendResult))
{
ErrorLog.LogError(emailSendResult, "send email Error");
}
tblEmail tblEmail = new tblEmail();
tblEmail.EmailGuid = Guid.NewGuid();
tblEmail.EmailFrom = EmailDomain.EmailFrom;
tblEmail.Subject = EmailDomain.EmailSubject;
tblEmail.Body = EmailDomain.EmailBody;
tblEmail.Sent = (emailSendResult == "") ? true : false;
tblEmail.FK_TemplateGuid = template.TemplateGuid;
tblEmail.DateCreated = DateTime.Now;
tblEmail.FK_CreatedByGuid = UserVariables.LoggedInUserGuid;
bringlyEntities.tblEmails.Add(tblEmail);
if (tblEmail.Sent)
{
tblEmailTo tblEmailTo = new tblEmailTo();
tblEmailTo.EmailToGuid = Guid.NewGuid();
tblEmailTo.FK_EmailGuid = tblEmail.EmailGuid;
tblEmailTo.EmailTo = EmailDomain.EmailTo;
tblEmailTo.FK_UserGuid = new Guid(usertoguid);// new Guid(usertoguid);
bringlyEntities.tblEmailToes.Add(tblEmailTo);
}
bringlyEntities.SaveChanges();
count = count + ((emailSendResult == "") ? 0 : 1);
}
}
}
else
{
count++;
}
if (count > 0)
{
return(false);
}
else
{
return(true);
}
}
