void UpdateCart(temp_service tempService) { var result = InitServicePreview(); if (comboServices.Text == string.Empty) { txtCode.Text = string.Empty; txtPrice.Text = string.Empty; MessageBox.Show("Please select a service from drop down", "Message"); } else { MessageBox.Show(Convert.ToString(result.service_id)); using (emedEntities db = new emedEntities()) { //_editItemFromCart.creator_id = StartPage._loggedInUser.user_id; //_editItemFromCart.service_id = result.service_id; //_editItemFromCart.price = result.price; //db.Entry(tempService).State = EntityState.Modified; //db.SaveChanges(); //MessageBox.Show("Service Updated Successfully!", "Message"); //Close(); var cart = db.temp_service.Find(_editItemFromCart.temp_service_id); cart.creator_id = StartPage._loggedInUser.user_id; cart.service_id = result.service_id; cart.price = result.price; db.SaveChanges(); MessageBox.Show("Updated Successfully!", "Message"); Close(); } } }
private decimal?CalculateTotalAmountInCart(int patientId) { temp_service temp = new temp_service(); decimal? total = 0M; var cartList = dbHelper.temp_service .Where(t => t.patient_id == patientId).ToList(); foreach (var item in cartList) { total += item.price * item.quantity; } return(total); }
private void ClearCart(int patient) { temp_service patientServices = new temp_service() { patient_id = patient }; using (emedEntities db = new emedEntities()) { db.temp_service.Attach(patientServices); db.temp_service.Remove(patientServices); db.SaveChanges(); } }
private decimal?CalculateTotalAmountInCart(patient patient) { temp_service temp = new temp_service(); decimal? result = 0M; using (emedEntities db = new emedEntities()) { var cartList = db.temp_service .Where(t => t.patient_id == patient.patient_id).ToList(); foreach (var item in cartList) { result = temp.price * temp.quantity; } } return(result); }
private void AddServiceToCart() { var result = GetSelectedRowService(new service()); using (emedEntities db = new emedEntities()) { temp_service tempService = new temp_service(); tempService.creator_id = StartPage._loggedInUser.user_id; tempService.patient_id = _currentPatient.patient_id; tempService.service_id = result.service_id; tempService.quantity = 1; tempService.price = result.price; db.temp_service.Add(tempService); db.SaveChanges(); } //CalculateTotalAmountInCart(_currentPatient); //SumBillReturnBillID(); //AddServiceToBillDetails(); //ClearCart(_currentPatient.patient_id); MessageBox.Show("Success"); }
public ServiceCart(temp_service editItemFromCart) { InitializeComponent(); _editItemFromCart = editItemFromCart; }