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);
}
