public async Task sendpricetoclient(int cartid = 0, int userid = 0) { var userclient = db.tbl_signalrUsers.Where(a => a.userid == userid).SingleOrDefault(); var userclientconnectionid = userclient.connectionId; // change purchase staus to DemandPrice tbl_purchasekart p = db.tbl_purchasekart.Find(cartid); p.status = (int)purchasestatus.GetPrice; db.SaveChanges(); if (userclientconnectionid != null) { await Clients.Client(userclientconnectionid).SendAsync("getPricefromServer", cartid, p.status.Value); } }
//public async Task sendpricebyclient(int userid, int cartid, string connectionid, String transportationRequired, string cartDesc,transportationdetailsMV t ) public async Task sendpricebyclient(int userid, int cartid, string connectionid, String transportationRequired, string cartDesc, string location_name, string person_peygiri, string tell, string location_address) { var user = db.tbl_signalrUsers.Where(a => a.userid == userid).SingleOrDefault(); tbl_purchasekart p = db.tbl_purchasekart.Find(cartid); // change purchase staus to DemandPrice if (cartid != 0) { p.status = (int)purchasestatus.DemandPrice; if (transportationRequired == "true") { tbl_transportaiondetails t = new tbl_transportaiondetails() { cartid = cartid, location_name = location_name, person_peygiri = person_peygiri, tell = tell, location_address = location_address, }; _cart.settransportaiondetails(cartid, t); p.transportationisneeded = true; } else { p.transportationisneeded = false; } p.pcartDesc = cartDesc; db.SaveChanges(); } await Clients.Client(user.connectionId).SendAsync("setDemandPriceStepInClient", p.status.Value); // find alireza is online var alireza = db.tbl_signalrUsers.Where(a => a.userid == 78).SingleOrDefault(); if (alireza.connectionId != null && user.userid != 78) { string msg = $"یک سبد خرید توسط کاربر : {user.fullname} هم اکنون ثبت گردید. "; await Clients.Client(alireza.connectionId).SendAsync("showthiscartonline", msg, cartid, userid, p.status.Value); } }
public ActionResult addnewitem(int product_id = 0) { if (!User.Identity.IsAuthenticated) { return(Json(new cartabstract { number = 0, userid = 0, numberitemexist = 0 })); } else { int user = _userServices.GetUseridByUsername(User.Identity.Name); var product = db.tbl_products.Where(a => a.idproduct == product_id).SingleOrDefault(); int numberexist; var listkala = db.tbl_listkala97.Where(a => a.productid == product_id); if (listkala.Count() != 0) { numberexist = listkala.Sum(a => a.kalanumberm); } else { numberexist = 0; } if (numberexist == 0) { return(Json(new cartabstract { number = 0, userid = user, numberitemexist = 0 })); } int number = 0; cartindropdown cartabs = new cartindropdown(); tbl_purchasekartitemlist item = new tbl_purchasekartitemlist(); if (db.tbl_purchasekart.Where(a => a.userid == user && a.ispaid == false).Count() == 0) { tbl_purchasekart pcart = new tbl_purchasekart(); pcart.userid = user; pcart.purchasedatestart = DateTime.Now; pcart.ispaid = false; pcart.status = 0; db.tbl_purchasekart.Add(pcart); db.SaveChanges(); item.product_id = product_id; item.number = 1; item.price = 0; item.perchasekart_id = pcart.id; item.purchase_datetime = DateTime.Now; item.totalprice = item.number * item.price; db.tbl_purchasekartitemlist.Add(item); db.SaveChanges(); number = db.tbl_purchasekartitemlist.Where(a => a.perchasekart_id == pcart.id).Count(); } else { var pcartopen = db.tbl_purchasekart.Where(a => a.userid == user && a.ispaid == false).SingleOrDefault(); pcartopen.status = 0; int kartidopen = pcartopen.id; if (pcartopen.tbl_purchasekartitemlist.Where(a => a.product_id == product_id).Count() != 0) { return(Json(new { preselected = "1" })); } item.product_id = product_id; item.number = 1; item.price = 0; item.perchasekart_id = kartidopen; item.purchase_datetime = DateTime.Now; item.totalprice = item.number * item.price; db.tbl_purchasekartitemlist.Add(item); db.SaveChanges(); number = db.tbl_purchasekartitemlist.Where(a => a.perchasekart_id == pcartopen.id).Count(); } cartabs.catgname = item.product_.category.categoryname; cartabs.numberincart = item.number; cartabs.pcode = item.product_.codename; cartabs.pname = item.product_.name; cartabs.productid = item.product_id; cartabs.purchasecartid = item.id; cartabs.pimage = item.product_.thumbnail_image != null ? item.product_.thumbnail_image : new byte[0]; cartabs.userid = user; //cartabs.totalitemnumberincart = _purchaseCart.itemnumberincart(user); return(PartialView("~/Views/Shared/PartialSearchProducts/_PartialItemCart.cshtml", cartabs)); } }