private void btnSave_Click(object sender, EventArgs e) { if (ValidateName()) { if (Mode == EntryMode.New) { ServiceMaster service = new ServiceMaster() { IsActive = true, Name = txtName.Text.Trim() }; db.ServiceMasters.Add(service); db.SaveChanges(); MessageBox.Show("Saved", "Success", MessageBoxButtons.OK); DialogResult = DialogResult.Yes; } else { var service = db.ServiceMasters.FirstOrDefault(x => x.Id == ServiceId); if (service != null) { service.Name = txtName.Text.Trim(); db.SaveChanges(); MessageBox.Show("Saved", "Success", MessageBoxButtons.OK); DialogResult = DialogResult.Yes; } else { MessageBox.Show("Error", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); DialogResult = DialogResult.No; } } } }
private async void BtnAdd_OnClick(object sender, RoutedEventArgs e) { NewServiceMaster = new ServiceMaster() { FirstName = TbFirstName.Text, MiddleName = TbMiddleName.Text, LastName = TbLastName.Text }; await _repository.Create(NewServiceMaster); _hideFlyout.Invoke(); }
public bool Add_ServiceMaster(ServiceMaster master) { bool status = false; if (master != null) { db.ServiceMasters.InsertOnSubmit(master); db.SubmitChanges(); status = true; } return(status); }
public bool Delete_ServiceMaster(int id) { bool status = false; if (id > 0) { ServiceMaster sm = db.ServiceMasters.FirstOrDefault(x => x.Id == id && x.IsDeleted == false); sm.IsDeleted = true; db.SubmitChanges(); status = true; } return(status); }
private void BtnCancel_Click(object sender, RoutedEventArgs e) { NewServiceMaster = null; _hideFlyout.Invoke(); }
public async Task Init() { try { var path = Path.Combine(AppDomain.CurrentDomain.BaseDirectory, "Repository.db"); var options = new DbContextOptionsBuilder <CarServiceSqliteContext>() .UseSqlite($"Data Source={path}") .Options; var db = new CarServiceSqliteContext(options); var isCreated = await db.Database.EnsureCreatedAsync(); await db.SaveChangesAsync(); var kia = new CarBrand() { Name = "KIA" }; db.CarBrands.Add(kia); await db.SaveChangesAsync(); var kiaSportage = new CarModel() { Name = "Sportage", CarBrand = kia }; db.CarModels.Add(kiaSportage); await db.SaveChangesAsync(); var customer = new Customer() { FirstName = "Customer", LastName = "Customer" }; db.Customers.Add(customer); await db.SaveChangesAsync(); var workType = new WorkType() { Name = "Замена колодок", Description = "Description" }; db.WorkTypes.Add(workType); await db.SaveChangesAsync(); var serviceMaster = new ServiceMaster() { FirstName = "Master1", LastName = "Master1" }; db.ServiceMasters.Add(serviceMaster); await db.SaveChangesAsync(); var customerCar = new CustomerCar() { CarModel = kiaSportage, RegistrationNumber = "КО222М", Customer = customer }; db.СustomerCars.Add(customerCar); await db.SaveChangesAsync(); var order = new Order() { Customer = customer, CustomerCar = customerCar, ServiceMaster = serviceMaster, TimeStamp = DateTime.Now }; db.Orders.Add(order); await db.SaveChangesAsync(); var orderItem = new OrderItem() { Order = order, WorkType = workType }; db.OrderItems.Add(orderItem); await db.SaveChangesAsync(); } catch (Exception e) { Console.WriteLine(e); throw; } }
public string SaveDataToServer(DataSet ds) { string result = string.Empty; int fail = 0; int success = 0; int update = 0; int Id = 0; using (DataClasses1DataContext db = new DataClasses1DataContext()) { try { foreach (DataRow dr in ds.Tables[0].Rows) { try { Id = Convert.ToInt32(dr["Id"]); } catch { Id = 0; } string AMCType = dr["AMC Type"].ToString(); string AMCContactNo = dr["AMC Contact No"].ToString(); DateTime AMCValidUpto = Convert.ToDateTime(dr["AMC Valid Upto"].ToString()); int AMCReminder = Convert.ToInt32(dr["AMC Reminder"].ToString()); DateTime StampingDate = Convert.ToDateTime(dr["Stamping Date"].ToString()); int StampingReminder = Convert.ToInt32(dr["Stamping Reminder"].ToString()); if (AMCType.ToLower() == "Silver(No Spares)".ToLower() || AMCType.ToLower() == "Gold(Without Load Cells)".ToLower() || AMCType.ToLower() == "Platinum(All Spares)".ToLower()) { ServiceMaster sm = Get_ServiceMasterById(Id); if (sm != null) { sm.AMCType = AMCType; sm.AMCContactNo = AMCContactNo; sm.AMCReminder = AMCReminder; sm.AMCValidUpto = AMCValidUpto; sm.StampingDate = StampingDate; sm.StampingReminder = StampingReminder; db.SubmitChanges(); update++; } else { ServiceMaster master = new ServiceMaster(); master.AMCType = AMCType; master.AMCReminder = AMCReminder; master.AMCContactNo = AMCContactNo; master.AMCValidUpto = AMCValidUpto; master.StampingDate = StampingDate; master.StampingReminder = StampingReminder; master.IsDeleted = false; db.ServiceMasters.InsertOnSubmit(master); db.SubmitChanges(); success++; } } else { fail++; } } } catch (Exception ex) { fail++; } result = "New Added: " + success + " Updated: " + update + " Failed: " + fail + ""; } return(result); }
public ServiceMaster Get_ServiceMasterById(int id) { ServiceMaster sm = db.ServiceMasters.FirstOrDefault(x => x.Id == id && x.IsDeleted == false); return(sm); }