public string AddCustomerOrder(CustomerOrderViewModel obj) { try { using (NavAssignmentEntities db = new NavAssignmentEntities()) { Order orderObj = new Order(); orderObj.CustomerId = obj.CustomerId; orderObj.OrderType = obj.OrderType; orderObj.PaymentType = obj.PaymentType; orderObj.GrandTotal = obj.GrandTotal; orderObj.deliveryDate = obj.deliveryDate; orderObj.isStatus = true; orderObj.createdDate = orderObj.updatedDate = DateTime.Now; orderObj.noofItems = obj.noofItems; db.Orders.Add(orderObj); db.SaveChanges(); return("Ok"); } } catch (Exception) { throw; } }
public string DeleteUser(int id) { try { using (NavAssignmentEntities db = new NavAssignmentEntities()) { Customer cus = db.Customers.Where(m => m.customerId == id).FirstOrDefault(); cus.isStatus = false; db.SaveChanges(); return("Ok"); } } catch (Exception) { throw; } }
public string DeleteProduct(int id) { try { using (NavAssignmentEntities db = new NavAssignmentEntities()) { Product cus = db.Products.Where(m => m.productId == id).FirstOrDefault(); cus.isStatus = false; db.SaveChanges(); return("Ok"); } } catch (Exception) { throw; } }
public string AddProduct(ProductViewModel obj) { try { using (NavAssignmentEntities db = new NavAssignmentEntities()) { Product pro = new Product(); pro.productName = obj.productName; pro.code = obj.code; pro.productDescription = obj.productDescription; pro.stockQuantity = obj.stockQuantity; pro.updatedDate = pro.createdDate = DateTime.Now; pro.isStatus = true; db.Products.Add(pro); db.SaveChanges(); return("Ok"); } } catch (Exception) { throw; } }
public string AddCustomerOrderItems(CustomerOrderItemViewModel obj) { try { using (NavAssignmentEntities db = new NavAssignmentEntities()) { OrderItem orderObj = new OrderItem(); orderObj.OrderID = obj.OrderID; orderObj.productId = obj.productId; orderObj.itemPrice = obj.itemPrice; orderObj.GrandTotal = obj.GrandTotal; orderObj.DiscountAmount = obj.DiscountAmount; orderObj.isStatus = true; orderObj.createdDate = orderObj.updatedDate = DateTime.Now; db.OrderItems.Add(orderObj); db.SaveChanges(); return("Ok"); } } catch (Exception) { throw; } }
public string AddUser(RegisterViewModel obj) { try { using (NavAssignmentEntities db = new NavAssignmentEntities()) { Customer cus = new Customer(); cus.customername = obj.customername; cus.emailId = obj.emailId; cus.customerAddress = obj.customerAddress; cus.gender = obj.gender; cus.mobileNumber = obj.mobileNumber; cus.updatedDate = cus.createdDate = DateTime.Now; cus.isStatus = true; db.Customers.Add(cus); db.SaveChanges(); return("Ok"); } } catch (Exception) { throw; } }