public int Insert(CustomerDetail obj) { CustomerDetail newCustomerMaster = new CustomerDetail(); // CustomerCylinderDetail newCustomerCylinderDetail = new CustomerCylinderDetail(); newCustomerMaster.companyName = obj.companyName; newCustomerMaster.address = obj.address; newCustomerMaster.contact_Num_1 = obj.contact_Num_1; newCustomerMaster.contact_Num_2 = obj.contact_Num_2; newCustomerMaster.email = obj.email; newCustomerMaster.discount = obj.discount; newCustomerMaster.gst = obj.gst; newCustomerMaster.balanceAmount = obj.balanceAmount; newCustomerMaster.openingBalance = obj.openingBalance; context.CustomerDetails.Add(newCustomerMaster); context.SaveChanges(); if (obj.CustomerCylinderDetail != null) { foreach (var i in obj.CustomerCylinderDetail) { CustomerCylinderDetail newCustomerCylinderDetail = new CustomerCylinderDetail(); newCustomerCylinderDetail.cylinder_Id = i.cylinder_Id; newCustomerCylinderDetail.cylinderType = i.cylinderType; newCustomerCylinderDetail.discount = i.discount; newCustomerCylinderDetail.totalCylinder = i.totalCylinder; newCustomerCylinderDetail.openingCylinder = i.openingCylinder; newCustomerCylinderDetail.cust_id = newCustomerMaster.cust_id; context.CustomerCylinderDetails.Add(newCustomerCylinderDetail); context.SaveChanges(); } } return(newCustomerMaster.cust_id); }
public void Update(CustomerDetail obj) { CustomerDetail newCustomerMaster = context.CustomerDetails.Where(obj1 => obj1.cust_id == obj.cust_id).FirstOrDefault(); CustomerCylinderDetail newCustomerCylinderDetail = new CustomerCylinderDetail(); newCustomerMaster.companyName = obj.companyName; newCustomerMaster.address = obj.address; newCustomerMaster.contact_Num_1 = obj.contact_Num_1; newCustomerMaster.contact_Num_2 = obj.contact_Num_2; newCustomerMaster.email = obj.email; newCustomerMaster.discount = obj.discount; newCustomerMaster.gst = obj.gst; newCustomerMaster.openingBalance = obj.openingBalance; newCustomerMaster.balanceAmount = obj.balanceAmount; context.SaveChanges(); if (obj.CustomerCylinderDetailForEdit != null) { foreach (var i in obj.CustomerCylinderDetailForEdit) { newCustomerCylinderDetail.cylinder_Id = i.cylinder_Id; newCustomerCylinderDetail.cylinderType = i.cylinderType; newCustomerCylinderDetail.discount = i.discount; newCustomerCylinderDetail.totalCylinder = i.totalCylinder; newCustomerCylinderDetail.openingCylinder = i.openingCylinder; newCustomerCylinderDetail.cust_id = newCustomerMaster.cust_id; context.CustomerCylinderDetails.Add(newCustomerCylinderDetail); context.SaveChanges(); } } }
public void DeleteDetail(int id) { CustomerCylinderDetail newCustomerCylinder = context.CustomerCylinderDetails.Where(obj => obj.cust_id == id).FirstOrDefault(); context.CustomerCylinderDetails.Remove(newCustomerCylinder); context.SaveChanges(); }
public int Insert(DeliveryDetail obj) { try { DeliveryDetail newdeliverydetail = new DeliveryDetail(); newdeliverydetail.C_deliveryDate = obj.C_deliveryDate; newdeliverydetail.voucherNo = obj.voucherNo; newdeliverydetail.cylinder_Id = obj.cylinder_Id; newdeliverydetail.cust_id = obj.cust_id; newdeliverydetail.cylinderAmount = obj.cylinderAmount; newdeliverydetail.emptyCylinder = obj.emptyCylinder; newdeliverydetail.filledCylinder = obj.filledCylinder; newdeliverydetail.replacementCylinder = obj.replacementCylinder; newdeliverydetail.paidAmount = obj.paidAmount; newdeliverydetail.totalAmount = obj.totalAmount; newdeliverydetail.sgst = Math.Round(obj.sgst.Value); newdeliverydetail.cgst = Math.Round(obj.cgst.Value); newdeliverydetail.balanceAmount = obj.balanceAmount; newdeliverydetail.userid = obj.userid; if (obj.signature != null) { newdeliverydetail.signature = obj.signature; } if (obj.phone != null) { newdeliverydetail.phone = obj.phone; } if (obj.filledCylinder <= 0) { obj.voucherNo = "LPG-E000"; } context.DeliveryDetails.Add(newdeliverydetail); context.SaveChanges(); CustomerDetail objCustomerDetails = context.CustomerDetails.Where(ite => ite.cust_id == obj.cust_id).FirstOrDefault(); if (objCustomerDetails != null) { objCustomerDetails.openingBalance = objCustomerDetails.openingBalance + obj.balanceAmount; context.SaveChanges(); } CustomerCylinderDetail objCustomerCylinderDetail = context.CustomerCylinderDetails.Where(ite => ite.cust_id == obj.cust_id && ite.cylinder_Id == obj.cylinder_Id).FirstOrDefault(); if (objCustomerCylinderDetail != null) { if (obj.filledCylinder > 0) { objCustomerCylinderDetail.totalCylinder = objCustomerCylinderDetail.totalCylinder + obj.filledCylinder; } if (obj.emptyCylinder > 0) { objCustomerCylinderDetail.totalCylinder = objCustomerCylinderDetail.totalCylinder - obj.emptyCylinder; } if (obj.replacementCylinder > 0) { objCustomerCylinderDetail.totalCylinder = objCustomerCylinderDetail.totalCylinder - obj.replacementCylinder; } context.SaveChanges(); } return(newdeliverydetail.ID); } catch (System.Data.Entity.Validation.DbEntityValidationException dbEx) { // ViewBag.ErrorMsg = "Sorry Some Problem Occured"; //dd.cylinders = repo.GetCylinderType(); //return View(dd); Exception raise = dbEx; foreach (var validationErrors in dbEx.EntityValidationErrors) { foreach (var validationError in validationErrors.ValidationErrors) { string message = string.Format("{0}:{1}", validationErrors.Entry.Entity.ToString(), validationError.ErrorMessage); // raise a new exception nesting // the current instance as InnerException raise = new InvalidOperationException(message, raise); } } throw raise; } }