public static List <OrderLocal> GetFilteredOrders_Admin(SearchOrdersRequestModel source)
{
using (var dbContext = new DeliversEntities())
{
try
{
//var results = dbContext.Orders.Where(x => (source.ListStatuses.Count == 0 || (source.ListStatuses.Any(s => s == x.Status))) &&
//(source.ListRiders.Count == 0 || (source.ListRiders.Any(s => x.PickedBy.Equals(s)))) &&
//(source.ListRestaurants.Count == 0 || (source.ListRestaurants.Any(s => x.OrderDetails.FirstOrDefault().ItemDetail.Id == s)))
//).ToList().OrderByDescending(o => o.Id).Select(o => o.MappOrder()).ToList();
var abc = dbContext.Orders.ToList();
var results = dbContext.Orders.Where(x => (source.ListStatuses.Count == 0) &&
(source.ListRiders.Count == 0 || (source.ListRiders.Any(s => x.PickedBy.Equals(s))))
).ToList().OrderByDescending(o => o.Id).Select(o => o.MappOrder()).ToList();
return(results);
}
catch (Exception e)
{
return(null);
//throw;
}
//var orders = dbContext.Orders.ToList().OrderByDescending(o => o.Id).Select(o => o.MappOrder()).ToList();
}
}
public static GetOrdersForStatus GetOrderForStatus(GetOrdersForStatusRequestModel model)
{
var response = new GetOrdersForStatus();
model.CurrentPage--;
using (var dbContext = new DeliversEntities())
{
var list = dbContext.Orders
.Where(
od => od.Status.ToLower() == model.Status).ToList();
if (list.Any())
{
var take = list.Skip(model.CurrentPage * model.ItemsPerPage).
Take(model.ItemsPerPage).ToList();
if (take.Any())
{
var finals = take.Select(obj => obj.MappOrder()).ToList();
response.Orders = finals;
}
}
response.ItemsPerPage = model.ItemsPerPage;
response.CurrentPage++;
response.TotalItems = list.Count;
return(response);
}
}
public static void AddNewRestaurent(ListItemLocal source)
{
using (var dbContext = new DeliversEntities())
{
DbGeography loc = null;
if (!String.IsNullOrEmpty(source.Location) && source.Location != "")
{
var latlng = source.Location.Split('_');
if (latlng.Length == 2)
{
loc = CommonService.ConvertLatLonToDbGeography(latlng[1], latlng[0]); // lat _ lng
}
}
var dbObj = new ListItem
{
Location = loc,
Name = source.Name,
Description = source.Description,
Phone = source.Phone,
LogoImage = source.LogoImage,
LastEdit = DateTime.Now,
BgImage = source.BgImage,
Address = source.Address,
Rating = source.Rating,
Type = source.Type,
Id = source.Id,
Status = source.Status,
Cords = loc,
CreationDate = DateTime.Now
};
dbContext.ListItems.Add(dbObj);
dbContext.SaveChanges();
}
}
public static GetOrdersResponseModel GetOrdersWaitingForPickup(GetOrdersListRequestModel requestModel)
{
using (var dbContext = new DeliversEntities())
{
requestModel.CurrentPage--;
var response = new GetOrdersResponseModel();
var list = dbContext.Orders
.Where(
od =>
od.OrderHistories.Any(str => str.Status == OrderHistoryEnu.WaitingForPickup.Value))
.ToList();
//&&
//(string.IsNullOrEmpty(requestModel.SearchTerm) ||
//(od.OrderDetails.Any(det => det.ItemDetail.ListItem.Name.ToLower().Contains(requestModel.SearchTerm.ToLower())) &&
//od.OrderHistories.Count == 1 && od.OrderHistories.Any(str => str.Status == (int)OrderHistoryEnum.WaitingForPickup)))).ToList();
if (list.Any())
{
var take = list.Skip(requestModel.CurrentPage * requestModel.ItemsPerPage).
Take(requestModel.ItemsPerPage).ToList();
if (take.Any())
{
var finals = take.Select(obj => obj.MappOrderWaitingForPickup()).ToList();
response.Orders = finals;
}
}
response.ItemsPerPage = requestModel.ItemsPerPage;
response.CurrentPage++;
response.TotalItems = list.Count;
return(response);
}
}
public static bool AddNewToken(NotificationRegisModel source)
{
using (var dbContext = new DeliversEntities())
{
var tokens = dbContext.Tokens.Where(t => t.AppId == source.AppId && t.UserId == source.UserId).ToList();
if (tokens != null && tokens.Any())
{
foreach (var tok in tokens)
{
tok.Token1 = source.Token;
tok.DateTime = CommonService.GetSystemTime();
}
dbContext.SaveChanges();
}
else
{
var obj = new Token
{
AppId = source.AppId,
Token1 = source.Token,
UserId = source.UserId,
DateTime = CommonService.GetSystemTime()
};
dbContext.Tokens.Add(obj);
dbContext.SaveChanges();
}
return(true);
}
}
public static GetListResponseModel GetI_Favourite_temsForList(GetFavouriteListRequestModel requestModel)
{
DbGeography userLoc = null;
List <string> latlng = new List <string>();
if (!string.IsNullOrEmpty(requestModel.Cords) && requestModel.Cords != "")
{
latlng = requestModel.Cords.Split('_').ToList();
if (latlng.Count == 2)
{
userLoc = CommonService.ConvertLatLonToDbGeography(latlng[1], latlng[0]); // lat _ lng
}
}
using (var dbContext = new DeliversEntities())
{
requestModel.CurrentPage--;
var response = new GetListResponseModel();
var newList = new List <ListItemLocal>();
string searchText = null;
if (!string.IsNullOrEmpty(requestModel.SearchTerm))
{
searchText = requestModel.SearchTerm.ToLower();
}
var list = dbContext.ListItems_Favt.Where(item =>
(string.IsNullOrEmpty(searchText) ||
item.ListItem.Name.ToLower().Contains(searchText) ||
item.ListItem.Description.ToLower().Contains(searchText) ||
(item.ListItem.ItemDetails.Any(det => det.Name.ToLower().Contains(searchText)))
)).ToList();
if (list.Any())
{
var take = list.Skip(requestModel.CurrentPage * requestModel.ItemsPerPage).
Take(requestModel.ItemsPerPage).ToList();
if (take.Any())
{
var finals = take.Select(obj => obj.ListItem.MapListItem()).ToList();
///
foreach (var rest in finals)
{
var dist = CommonService.GetDistance((double)userLoc.Latitude, (double)userLoc.Longitude, Convert.ToDouble(rest.LocationObj.Latitude), Convert.ToDouble(rest.LocationObj.Longitude));
// if ((int)dist < Convert.ToInt16(20))
{
var disst = Math.Round((double)dist, 2);
rest.LocationObj = null;
rest.Distance = disst;
rest.Name = rest.Name;
newList.Add(rest);
}
}
response.Items = newList.OrderBy(obj => obj.Distance).ToList();
}
}
response.ItemsPerPage = requestModel.ItemsPerPage;
response.CurrentPage++;
response.TotalItems = list.Count;
return(response);
}
}
public static bool AddReview(RatingLocal source)
{
using (var dbContext = new DeliversEntities())
{
try
{
var dbObj = new Rating
{
Id = 0,
DateTime = CommonService.GetSystemTime(),
RatedToItem = source.RatedToItem,
IsApproved = true,
Comments = source.Comments,
RatingStar = source.RatingStar,
RatedByUserId = source.RatedByUserId
};
dbContext.Ratings.Add(dbObj);
dbContext.SaveChanges();
}
catch (Exception df)
{
return(false);
}
}
return(true);
}
public static List <ListItemLocal> GetItemsForList_AdminPanel()
{
using (var dbContext = new DeliversEntities())
{
return(dbContext.ListItems.OrderBy(p => p.Name).ToList().Select(o => o.MapListItem()).ToList());
}
}
public static OrdersForRestaurantResponseModel GetOrdersForRestaurant(GetRestaurantOrdersForSpecificStatus model)
{
using (var dbContext = new DeliversEntities())
{
model.CurrentPage--;
var response = new OrdersForRestaurantResponseModel();
var orderStatus = OrderHistoryEnu.GetOrderStatus(model.Status);
var list = dbContext.Orders
.Where(
od =>
od.OrderHistories.Any(str => str.Status == orderStatus.Value) &&
od.OrderDetails.Any(det => det.ItemDetail.ListItemId.ToString() == model.RestaurantId))
.ToList();
if (list.Any())
{
var take = list.Skip(model.CurrentPage * model.ItemsPerPage).
Take(model.ItemsPerPage).ToList();
if (take.Any())
{
var finals = take.Select(obj => obj.MappOrder()).ToList();
response.Orders = finals;
}
}
response.ItemsPerPage = model.ItemsPerPage;
response.CurrentPage++;
response.TotalItems = list.Count;
return(response);
}
}
public static List <UserLocal> GetUsersByype(string type)
{
using (var dbContext = new DeliversEntities())
{
return(dbContext.AspNetUsers.Where(u => u.Type.ToString() == type).ToList().Select(o => o.Mapper()).ToList());
}
}
public static ListCategoryLocal GetRestaurantType(long id)
{
using (var dbcontext = new DeliversEntities())
{
var item = dbcontext.ListCategories.Where(det => det.Status == true && det.CatId == id).ToList().Select(p => p.Mapper()).FirstOrDefault();
return(item);
}
}
public static ItemDetailLocal GetItemDetailLocalById(long itemId)
{
using (var dbcontext = new DeliversEntities())
{
var items = dbcontext.ItemDetails.FirstOrDefault(det => det.Id == itemId);
return(items?.ItemDetailMapper());
}
}
public static List <OrderLocal> GetAllOrders_Admin()
{
using (var dbContext = new DeliversEntities())
{
var orders = dbContext.Orders.ToList().OrderByDescending(o => o.Id).Select(o => o.MappOrder()).ToList();
return(orders);
}
}
public static List <ListItemTrimmedForSearch> GetItemsForSearch_AdminPanel()
{
using (var dbContext = new DeliversEntities())
{
return(dbContext.ListItems.OrderBy(p => p.Name).ToList().Select(o => new ListItemTrimmedForSearch()
{
Id = o.Id,
Name = o.Name
}).ToList());
}
}
public static bool CancelAppliedOrder_ByRider(ChangeOrderStatusRequesrModel model)
{
using (var dbContext = new DeliversEntities())
{
string newStatus = "";
var order = dbContext.Orders.FirstOrDefault(o => o.Id.ToString() == model.OrderId);
if (order != null)
{
// var combinedOrders = dbContext.Orders.Where(o => o.SerialNo == order.SerialNo).ToList();
// foreach (var dbo in combinedOrders)
{
// CHECK IF HE APPLIED FOR THIS ORDER OT NOT
var isAppliedForOrder = order.PickedBy == model.UserId;
if (!isAppliedForOrder)
{
return(false);
}
newStatus = OrderHistoryEnu.ConfirmedByRestaurant.Value;
order.Status = newStatus;
order.PickedBy = Guid.Empty.ToString();
var currentHis = dbContext.OrderHistories.FirstOrDefault(d => d.OrderId.ToString() == order.Id.ToString() && d.IsCurrent);
if (currentHis != null)
{
currentHis.IsCurrent = false;
}
dbContext.OrderHistories.Add(new OrderHistory
{
OrderId = order.Id,
DateTime = CommonService.GetSystemTime(),
Status = OrderHistoryEnu.CanceledByRider.Value,
IsCurrent = false
});
dbContext.OrderHistories.Add(new OrderHistory
{
OrderId = order.Id,
DateTime = CommonService.GetSystemTime(),
Status = newStatus,
IsCurrent = true
});
dbContext.SaveChanges();
}
// generate notifications
NotificationService.ProcessNotificationRequest(OrderHistoryEnu.CanceledByRider.Value, order.Id);
NotificationService.ProcessNotificationRequest(newStatus, order.Id);
return(true);
}
return(false);
}
}
public static ListItemLocal_Short GetRestaurantById(long restId)
{
using (var dbContext = new DeliversEntities())
{
var restaurantMap = dbContext.ListItems.FirstOrDefault(o => o.Id == restId);
if (restaurantMap != null)
{
return(restaurantMap.MapListItem_ShortM());
}
return(null);
}
}
public static List <ItemDetailLocal_Short> GetMenuByListItemId(long id)
{
using (var dbcontext = new DeliversEntities())
{
var items = dbcontext.ItemDetails.Where(det => det.ListItemId == id).ToList();
if (items.Any())
{
return(items.Select(obj => obj.ItemDetailShortMapper()).ToList());
}
return(null);
}
}
public static OrderLocal GetOrderDetails(string orderId)
{
using (var dbContext = new DeliversEntities())
{
var order = dbContext.Orders.FirstOrDefault(o => o.Id.ToString() == orderId);
if (order != null)
{
return(order.MappOrder());
}
return(null);
}
}
public static GetOrdersResponseModel OrdersReadyToAssign(GetOrdersListRequestModel requestModel)
{
using (var dbContext = new DeliversEntities())
{
requestModel.CurrentPage--;
var response = new GetOrdersResponseModel();
var list = dbContext.Orders
.Where(
od => od.Status == OrderHistoryEnu.ConfirmedByRestaurant.Value &&
od.OrderHistories.Any(str => str.Status == OrderHistoryEnu.ConfirmedByRestaurant.Value && str.IsCurrent))
.ToList();
DbGeography riderLoc = null;
List <string> latlng = new List <string>();
if (!string.IsNullOrEmpty(requestModel.Cords) && requestModel.Cords != "")
{
latlng = requestModel.Cords.Split('_').ToList();
if (latlng.Count == 2)
{
riderLoc = CommonService.ConvertLatLonToDbGeography(latlng[1], latlng[0]); // lat _ lng
}
}
var inRangeOrders = new List <Order>();
if (list != null && list.Any())
{
foreach (var o in list)
{
var dist = CommonService.GetDistance((double)riderLoc.Latitude, (double)riderLoc.Longitude, Convert.ToDouble(o.Cords.Latitude), Convert.ToDouble(o.Cords.Longitude));
//if ((int)dist < Convert.ToInt16(10))
{
inRangeOrders.Add(o);
}
}
}
if (inRangeOrders.Any())
{
var take = list.Skip(requestModel.CurrentPage * requestModel.ItemsPerPage).
Take(requestModel.ItemsPerPage).ToList();
if (take.Any())
{
var finals = take.Select(obj => obj.MappOrderWaitingForPickup()).ToList();
response.Orders = finals;
}
}
response.ItemsPerPage = requestModel.ItemsPerPage;
response.CurrentPage++;
response.TotalItems = list.Count;
return(response);
}
}
public static async Task <ListItemLocal> DetailsAsync(long id)
{
ListItemLocal listItemLocal = null;
using (var dbContext = new DeliversEntities())
{
ListItem listItem = await dbContext.ListItems.FindAsync(id);
listItemLocal = listItem.MapListItem();
}
return(listItemLocal);
}
public static AlterOrderResponse AlterOrder_Admin(AlterOrderRequestModel source)
{
using (var dbContext = new DeliversEntities())
{
var response = new AlterOrderResponse {
isSuccesss = true
};
var totalAmount = source.Items.Sum(i => ItemDetailsService.GetItemDetailLocalById(i.itemId).Price *i.quantity);
if (totalAmount <= 0)
{
response.isSuccesss = false;
response.Message = "Total amount can not be 0";
return(response);
}
var order = dbContext.Orders.FirstOrDefault(o => o.Id == source.OrderId);
if (order != null)
{
if (order.Status == OrderHistoryEnu.Deliverd.Value || order.Status == OrderHistoryEnu.PickedUp.Value)
{
response.isSuccesss = false;
response.Message = "Can not change order with status: " + order.Status;
return(response);
}
if (order.Amount != totalAmount)
{
order.Amount = totalAmount;
order.UpdatedAt = CommonService.GetSystemTime();
if (order.OrderDetails != null && order.OrderDetails.Any())
{
foreach (var det in order.OrderDetails)
{
var newQ = source.Items.FirstOrDefault(i => i.itemId == det.ItemId).quantity;
if (newQ != det.Quantity)
{
det.Quantity = newQ;
}
}
dbContext.OrderHistories.Add(new OrderHistory {
DateTime = CommonService.GetSystemTime(),
IsCurrent = false,
OrderId = source.OrderId,
Status = OrderHistoryEnu.OrderAltered.Value,
Comments = source.Comments
});
dbContext.SaveChanges();
}
}
}
return(response);
}
}
public static OrderHistoryEnu GetOrderCurrentStatus(string orderid)
{
using (var dbContext = new DeliversEntities())
{
var order = dbContext.Orders.FirstOrDefault(o => o.Id.ToString() == orderid);
if (order != null)
{
var orderStatus = OrderHistoryEnu.GetOrderStatus(order.Status);
return(orderStatus);
}
return(null);
}
}
public static string SendSms(string mobile, string contents)
{
var response = SendSMS(mobile, contents, "923466043805", "3186");
if (response != null && response.Contains("OK"))
{
using (var dbContext = new DeliversEntities()) {
var sms = new Sm {
Contetns = contents,
Time = CommonService.GetSystemTime(),
ToNumber = mobile
};
dbContext.Sms.Add(sms);
dbContext.SaveChanges();
}
}
return(response);
//const string url = "http://www.sms4connect.com/api/sendsms.php/sendsms/url";
//String result = "";
//String message = System.Web.HttpUtility.UrlEncode(contents);
//String strPost = "id=kissaneng&pass=pakistan6&msg=" + message +
// "&to=" + mobile + "&mask=KamShamHelp&type=json&lang=English";
//// "&to=923084449991" + "&mask=SMS4CONNECT&type=xml&lang=English";
//StreamWriter myWriter = null;
//HttpWebRequest objRequest = (HttpWebRequest)WebRequest.Create(url);
//objRequest.Method = "POST";
//objRequest.ContentLength = Encoding.UTF8.GetByteCount(strPost);
//objRequest.ContentType = "application/x-www-form-urlencoded";
//try
//{
// myWriter = new StreamWriter(objRequest.GetRequestStream());
// myWriter.Write(strPost);
//}
//catch (Exception e)
//{
// return e.Message;
//}
//finally
//{
// myWriter.Close();
//}
//HttpWebResponse objResponse = (HttpWebResponse)objRequest.GetResponse();
//using (StreamReader sr = new StreamReader(objResponse.GetResponseStream()))
//{
// result = sr.ReadToEnd();
// // Close and clean up the StreamReader
// sr.Close();
//}
//return result;
}
public static List <ListCategoryLocal> GetCategories(bool staus)
{
using (var dbcontext = new DeliversEntities())
{
var items = dbcontext.ListCategories.Where(det => det.Status == staus).ToList().Select(p => p.Mapper()).ToList();
if (items.Any())
{
foreach (var item in items)
{
item.ItemCount = dbcontext.ListItems.Count(o => o.Type == item.CatId);
}
}
return(items);
}
}
public static ListItemLocal GetRestaurantForUserId(string userid)
{
using (var dbContext = new DeliversEntities())
{
var restaurantMap = dbContext.User_Rest_Map.FirstOrDefault(r => r.UserId == userid);
if (restaurantMap != null)
{
var res = dbContext.ListItems.FirstOrDefault(l => l.Id == restaurantMap.RestId);
if (res != null)
{
return(res.MapListItem());
}
}
return(null);
}
}
public static OrdersForRestaurantResponseModel GetOrdersForRestaurant_ByDate(GetRestaurantOrdersForSpecificDate model)
{
using (var dbContext = new DeliversEntities())
{
model.CurrentPage--;
var response = new OrdersForRestaurantResponseModel();
var startDate = Convert.ToDateTime(model.StartDate, CultureInfo.InvariantCulture); // 9/24/2017 9:31:34 AM
var endDate = Convert.ToDateTime(model.EndDate, CultureInfo.InvariantCulture); // 9/24/2017 9:31:34 AM
var localList = new List <Order>();
var list = (from od in dbContext.Orders
where
// od.DateTime.Date >= startDate.Date && od.DateTime.Date <= endDate.Date &&
od.OrderDetails.Any(det => det.ItemDetail.ListItemId.ToString() == model.RestaurantId)
select od).ToList();
if (list.Any())
{
foreach (var od in list)
{
if (od.DateTime.Date >= startDate.Date && od.DateTime.Date <= endDate.Date)
{
localList.Add(od);
}
}
if (localList.Any())
{
var take = localList.Skip(model.CurrentPage * model.ItemsPerPage).
Take(model.ItemsPerPage).ToList();
if (take.Any())
{
var finals = take.Select(obj => obj.MappOrder()).ToList();
response.Orders = finals;
}
}
}
response.ItemsPerPage = model.ItemsPerPage;
response.CurrentPage++;
response.TotalItems = localList.Count;
return(response);
}
}
public static List <OrderLocal> GetFilteredOrdersSingle_Admin(SearchOrdersRequestModelSingle source)
{
using (var dbContext = new DeliversEntities())
{
try
{
//var results = dbContext.Orders.Where(x => (source.ListStatuses.Count == 0 || (source.ListStatuses.Any(s => s == x.Status))) &&
//(source.ListRiders.Count == 0 || (source.ListRiders.Any(s => x.PickedBy.Equals(s)))) &&
//(source.ListRestaurants.Count == 0 || (source.ListRestaurants.Any(s => x.OrderDetails.FirstOrDefault().ItemDetail.Id == s)))
//).ToList().OrderByDescending(o => o.Id).Select(o => o.MappOrder()).ToList();
//temp code,remove asap.
//var abc = dbContext.Orders.ToList();
var results = dbContext.Orders.Where(x => (string.IsNullOrEmpty(source.Status) || x.Status == source.Status) &&
(string.IsNullOrEmpty(source.Rider) || (source.Rider == x.PickedBy)) &&
(source.Restaurant == null || (source.Restaurant == x.OrderDetails.FirstOrDefault().RestId))
);
if (source.OrderDateFrom != null && source.OrderDateTo != null)
{
results = results.Where(x => Nullable.Compare((DbFunctions.TruncateTime(x.DateTime)), source.OrderDateFrom) > -1 && Nullable.Compare((DbFunctions.TruncateTime(x.DateTime)), source.OrderDateTo) < 1);
}
else if (source.OrderDateTo != null)
{
results = results.Where(x => Nullable.Compare((DbFunctions.TruncateTime(x.DateTime)), source.OrderDateTo) < 1);
}
else if (source.OrderDateFrom != null)
{
results = results.Where(x => Nullable.Compare((DbFunctions.TruncateTime(x.DateTime)), source.OrderDateFrom) > -1);
}
var _filtered = results.ToList().OrderByDescending(o => o.Id).Select(o => o.MappOrder()).ToList();
return(_filtered);
}
catch (Exception e)
{
return(null);
//throw;
}
//var orders = dbContext.Orders.ToList().OrderByDescending(o => o.Id).Select(o => o.MappOrder()).ToList();
}
}
public static OrdersForRidersResponseModel GetOrdersForRider_ByDate(GeOrdersByDate_RiderModel model)
{
using (var dbContext = new DeliversEntities())
{
var response = new OrdersForRidersResponseModel();
model.CurrentPage--;
var startDate = Convert.ToDateTime(model.StartDate, CultureInfo.InvariantCulture); // 9/24/2017 9:31:34 AM
var endDate = Convert.ToDateTime(model.EndDate, CultureInfo.InvariantCulture); // 9/24/2017 9:31:34 AM
var localList = new List <Order>();
var list = dbContext.Orders.Where(o => o.PickedBy == model.UserId &&
(string.IsNullOrEmpty(model.Status) || o.Status.ToLower() == model.Status.ToLower())).ToList();
if (list.Any())
{
foreach (var od in list)
{
if (od.DateTime.Date >= startDate.Date && od.DateTime.Date <= endDate.Date)
{
localList.Add(od);
}
}
if (localList.Any())
{
var take = localList.Skip(model.CurrentPage * model.ItemsPerPage).
Take(model.ItemsPerPage).ToList();
if (take.Any())
{
var finals = take.Select(obj => obj.MappOrder()).ToList();
response.Orders = finals;
}
}
}
response.ItemsPerPage = model.ItemsPerPage;
response.CurrentPage++;
response.TotalItems = localList.Count;
return(response);
}
}
public static string AddRemove_Favourite_Restaurent(AddFavtItemRequestModel source)
{
using (var dbContext = new DeliversEntities())
{
var rest = dbContext.ListItems.FirstOrDefault(i => i.Id.ToString()==source.ItemId);
if (rest != null)
{
var isfavtExist = dbContext.ListItems_Favt.FirstOrDefault(i => i.ItemId.ToString() == source.ItemId
&& i.UserId == source.UserId);
if ( source.IsFavourite)
{
if (isfavtExist == null)
{
var obj = new ListItems_Favt
{
ItemId = Convert.ToInt64(source.ItemId),
DateTime = DateTime.Now,
UserId = source.UserId
};
dbContext.ListItems_Favt.Add(obj);
dbContext.SaveChanges();
return "Item added as favourite";
}
else
{
return "Item already is in favourite";
}
}
else
{
if (isfavtExist != null)
{
dbContext.ListItems_Favt.Remove(isfavtExist);
dbContext.SaveChanges();
return "Item removed from favourite";
}
return "Item is not in favourite";
}
}
return "Invalid item";
}
}
public static bool UpdateImages(ListItemLocal source)
{
using (var dbContext = new DeliversEntities())
{
var item = dbContext.ListItems.First(x => x.Id == source.Id);
//if (string.IsNullOrEmpty(source.BgImage))
//{
item.BgImage = "image added";
//}
//if (string.IsNullOrEmpty(source.LogoImage))
//{
item.LogoImage = "logo added";
//}
item.LastEdit = CommonService.GetSystemTime();
dbContext.SaveChanges();
}
return(true);
}
