//public decimal GetTotal() //{ // ShoppingCartId = GetCartId(); // // Multiply product price by quantity of that product to get // // the current price for each of those products in the cart. // // Sum all product price totals to get the cart total. // decimal? total = decimal.Zero; // total = (decimal?)(from cartItems in _db.CartItems // where cartItems.CartId == ShoppingCartId // select (int?)cartItems.Quantity * // cartItems.Product.unitPrice).Sum(); // return total ?? decimal.Zero; //} public decimal GetTotal() { ShoppingCartId = GetCartId(); decimal?items = 0; var cart = _db.CartItems.FirstOrDefault(c => c.CartId == ShoppingCartId); using (var db = new TechEntities()) { List <CartItem> myCart = GetCartItems(); foreach (var cartItem in myCart) { // Iterate through all rows within shopping cart list items = (decimal?)(from cartItems in _db.CartItems where cartItems.CartId == ShoppingCartId select(int?) cartItems.Quantity * cartItems.Product.unitPrice).Sum(); if (cart != null) { cart.Subtotal = items; } _db.SaveChanges(); } //if (cart != null) //{ // cart.Subtotal = items; //} // _db.SaveChanges(); } return(items ?? decimal.Zero); }
public void UpdateShoppingCartDatabase(String cartId, ShoppingCartUpdates[] CartItemUpdates) { using (var db = new TechEntities()) { try { int CartItemCount = CartItemUpdates.Count(); List <CartItem> myCart = GetCartItems(); foreach (var cartItem in myCart) { // Iterate through all rows within shopping cart list for (int i = 0; i < CartItemCount; i++) { if (cartItem.Product.productId == CartItemUpdates[i].ProductId) { if (CartItemUpdates[i].PurchaseQuantity < 1 || CartItemUpdates[i].RemoveItem == true) { RemoveItem(cartId, cartItem.ProductId); } else { UpdateItem(cartId, cartItem.ProductId, CartItemUpdates[i].PurchaseQuantity); } } } } } catch (Exception exp) { throw new Exception("ERROR: Unable to Update Cart Database - " + exp.Message.ToString(), exp); } } }
public void Dispose() { if (_db != null) { _db.Dispose(); _db = null; } }
public bool AddProduct(string ProductName, string ProductDesc, string ProductPrice, string ProductImagePath) { var myProduct = new Product(); myProduct.productName = ProductName; myProduct.productDescription = ProductDesc; myProduct.unitPrice = Convert.ToDecimal(ProductPrice); myProduct.imageURL = ProductImagePath; //myProduct.CategoryID = Convert.ToInt32(ProductCategory); using (TechEntities _db = new TechEntities()) { // Add product to DB. _db.Products.Add(myProduct); _db.SaveChanges(); } // Success. return(true); }
public HttpResponseMessage AddUser(UserViewModel users) { Response response = new Response(); try { using (var dbContext = new TechEntities()) { var Req = dbContext.Users.FirstOrDefault(x => x.UserName == users.UserName); if (Req == null) { var objuser = new User { UserName = users.UserName, UserId = users.UserId, GroupId = users.GroupId, UserStatus = users.UserStatus, CreatedDate = DateTime.Now }; dbContext.Users.Add(objuser); dbContext.SaveChanges(); var NewRecord = dbContext.Users.FirstOrDefault(x => x.UserName == users.UserName); response.success = true; response.result = NewRecord; response.message = "User added successfully "; } else { response.success = false; response.message = "User already exist"; } } } catch (Exception ex) { ex.Message.ToString(); response.success = false; response.message = "User adding failed, Please contact your administrator"; } return(Request.CreateResponse(HttpStatusCode.OK, response)); }
public HttpResponseMessage GetGroup() { HttpResponseMessage httpresponse = new HttpResponseMessage(); Response response = new Response(); try { using (var dbContext = new TechEntities()) { response.result = (from c in dbContext.Groups where c.GroupStatus == true select new { GroupId = c.GroupId, GroupName = c.GroupName }).ToList(); response.success = true; } } catch (Exception ex) { ex.Message.ToString(); response.success = false; response.message = "Group get failed, Please contact your administrator"; } return(Request.CreateResponse(HttpStatusCode.OK, response)); }
public HttpResponseMessage AddGroup(GroupViewModel groups) { HttpResponseMessage httpresponse = new HttpResponseMessage(); Response response = new Response(); try { using (var dbContext = new TechEntities()) { var Req = dbContext.Groups.FirstOrDefault(x => x.GroupName == groups.GroupName); if (Req == null) { var objGroup = new Group { GroupId = groups.GroupId, GroupName = groups.GroupName, GroupStatus = groups.GroupStatus }; dbContext.Groups.Add(objGroup); dbContext.SaveChanges(); var NewRecord = dbContext.Groups.FirstOrDefault(x => x.GroupName == groups.GroupName); response.success = true; response.result = NewRecord; response.message = "Group added successfully "; } else { response.success = false; response.message = "Group already exist"; } } } catch (Exception ex) { ex.Message.ToString(); response.success = false; response.message = "Group adding failed, Please contact your administrator"; } return(httpresponse); }
public DataTableResponse Employee(DataTableRequest request) { int recordsTotal = 0; HttpResponseMessage httpresponse = new HttpResponseMessage(); var lstUser = new List <UserDetail>(); var lstTopUser = new List <UserDetail>(); try { /// var searchValue = Request.Form.GetValues("search[value]").FirstOrDefault(); //Paging Size (10,20,50,100) int pageSize = request.Length; int skip = request.Start; // Getting all Customer data //Sorting //if (!(string.IsNullOrEmpty(sortColumn) && string.IsNullOrEmpty(sortColumnDir))) //{ // customerData = lstUser.OrderBy(sortColumn + " " + sortColumnDir); //} //Search if (!string.IsNullOrEmpty(request.Search.Value)) { var searchText = request.Search.Value.Trim(); using (var dbContext = new TechEntities()) { lstUser = (from c in dbContext.Users where c.UserName.Contains(searchText) || c.Group.GroupName.Contains(searchText) select new UserDetail { UserId = c.UserId, UserName = c.UserName, groupname = c.Group.GroupName, GroupId = c.GroupId, UserStatus = c.UserStatus, CreatedDate = c.CreatedDate, UpdatedDate = c.UpdatedDate }).ToList(); } } else { using (var dbContext = new TechEntities()) { lstUser = (from c in dbContext.Users select new UserDetail { UserId = c.UserId, UserName = c.UserName, groupname = c.Group.GroupName, GroupId = c.GroupId, UserStatus = c.UserStatus, CreatedDate = c.CreatedDate, UpdatedDate = c.UpdatedDate }).ToList(); } } recordsTotal = lstUser.Count(); //Paging lstTopUser = lstUser.Skip(skip).Take(pageSize).ToList(); } catch (Exception ex) { ex.Message.ToString(); } return(new DataTableResponse { draw = request.Draw, recordsTotal = recordsTotal, recordsFiltered = recordsTotal, data = lstTopUser, error = "" }); ///return Request.CreateResponse(HttpStatusCode.OK, new { draw = request.Draw, recordsFiltered = recordsTotal, recordsTotal = recordsTotal, data = lstTopUser }); }
public ActionResult GetUsers() { var lstUser = new List <UserDetail>(); try { //Do To var draw = Request.Form.GetValues("draw").FirstOrDefault(); var start = Request.Form.GetValues("start").FirstOrDefault(); var length = Request.Form.GetValues("length").FirstOrDefault(); var searchValue = Request.Form.GetValues("search[value]").FirstOrDefault(); //Paging Size (10,20,50,100) int pageSize = length != null?Convert.ToInt32(length) : 0; int skip = start != null?Convert.ToInt32(start) : 0; int recordsTotal = 0; // Getting all Customer data //Search options if (!string.IsNullOrEmpty(searchValue)) { using (var dbContext = new TechEntities()) { lstUser = (from c in dbContext.Users where c.UserName.Contains(searchValue) || c.Group.GroupName.Contains(searchValue) select new UserDetail { UserId = c.UserId, UserName = c.UserName, groupname = c.Group.GroupName, GroupId = c.GroupId, UserStatus = c.UserStatus, CreatedDate = c.CreatedDate, UpdatedDate = c.UpdatedDate }).ToList(); } } else { using (var dbContext = new TechEntities()) { lstUser = (from c in dbContext.Users select new UserDetail { UserId = c.UserId, UserName = c.UserName, groupname = c.Group.GroupName, GroupId = c.GroupId, UserStatus = c.UserStatus, CreatedDate = c.CreatedDate, UpdatedDate = c.UpdatedDate }).ToList(); } } recordsTotal = lstUser.Count(); //Paging var data = lstUser.Skip(skip).Take(pageSize).ToList(); return(Json(new { draw = draw, recordsFiltered = recordsTotal, recordsTotal = recordsTotal, data = data })); } catch (Exception) { throw; } }