private static Boolean saveInDb(PistisContext db, Message msg) { var model = new VendorChat(); model.CustomerId = msg.CustomerId; model.IsActive = true; model.ProductVariantDetailId = msg.ProductVariantDetailId; model.VendorId = msg.VendorId; model.IpAddress = msg.IpAddress; model.IsArchieved = false; model.ProductVariantDetailId = msg.ProductVariantDetailId; db.VendorChat.Add(model); try { db.SaveChanges(); var data = new VendorChatMsg(); data.CustomerMsg = msg.CustomerMsg; data.DateTime = DateTime.Now; data.IsCustomerRead = false; data.IsVendorRead = false; data.VendorChatId = model.Id; data.VendorMsg = msg.VendorMsg; db.VendorChatMsg.Add(data); db.SaveChanges(); return(true); } catch (Exception ex) { return(false); } }
public Boolean saveInDb(Message msg) { var model = new VendorChat(); var vendorid = 0; if (msg.VendorId == 0) { vendorid = db.Products.Where(x => x.Id == msg.ProductId).FirstOrDefault().VendorId; } else { vendorid = msg.VendorId; } model = db.VendorChat.Where(x => x.IsActive == true && x.IsArchieved == false && x.VendorId == vendorid && x.ProductVariantDetailId == msg.ProductVariantDetailId && x.CustomerId == msg.CustomerId).FirstOrDefault(); if (model == null) { model = new VendorChat(); model.CustomerId = msg.CustomerId; model.IsActive = true; model.ProductVariantDetailId = msg.ProductVariantDetailId; model.IpAddress = msg.IpAddress; model.VendorId = vendorid; model.IsArchieved = false; model.ProductVariantDetailId = msg.ProductVariantDetailId; db.VendorChat.Add(model); } try { db.SaveChanges(); var data = new VendorChatMsg(); data.CustomerMsg = msg.CustomerMsg; data.DateTime = DateTime.Now; data.IsCustomerRead = false; data.IsVendorRead = false; data.VendorChatId = model.Id; data.VendorMsg = msg.VendorMsg; db.VendorChatMsg.Add(data); db.SaveChanges(); var chat = new AllChats(); chat.CustomerId = model.CustomerId; var cust = db.Users.Where(x => x.Id == model.CustomerId).FirstOrDefault(); chat.CustomerName = cust.FirstName + " " + cust.LastName; var vendor = db.Users.Where(x => x.Id == model.VendorId).FirstOrDefault(); chat.VendorName = vendor.DisplayName; chat.Date = data.DateTime; chat.LastMsg = data.CustomerMsg; chat.ProductId = msg.ProductId; chat.ProductVariantDetailId = model.ProductVariantDetailId; chat.VendorId = model.VendorId; if (msg.VendorId == 0) { var booldata = saveNotification(chat); } else { var bdata = saveNotiForCust(chat); } return(true); } catch (Exception ex) { return(false); } }