public IActionResult Create([FromBody] CustomerCar CustomerCar)
{
CustomerCar.Id = Guid.NewGuid() + "";
CustomerCar.IsDelete = false;
return(Ok(_repository.Create(CustomerCar)));
}
public ActionResult DeleteConfirmed(int id)
{
CustomerCar customerCar = db.CustomerCars.Find(id);
db.CustomerCars.Remove(customerCar);
db.SaveChanges();
return RedirectToAction("Index");
}
/// <summary>
/// Initializes a new instance of the <see cref="FrmMiniSearch"/> class.
/// </summary>
/// Created by SMK
public FrmMiniSearch()
{
InitializeComponent();
customerCar = new CustomerCar();
GvContext = gvCusInfo;
comboBox1.SelectedIndex = 0;
btnApply.Enabled = false;
}
public ActionResult Edit([Bind(Include = "customerCarId,customerCarFirstName,customerCarLastName,customerCarPhone,address")] CustomerCar customerCar)
{
if (ModelState.IsValid)
{
db.Entry(customerCar).State = EntityState.Modified;
db.SaveChanges();
return RedirectToAction("Index");
}
return View(customerCar);
}
public FrmCustomerList()
{
InitializeComponent();
customer = new Customer();
customerCar = new CustomerCar();
this.GvContext = gvCusInfo;
this.GvChildContext = gvCar;
FormatDebitGrid();
LoadCustomerGrid();
}
public ActionResult Create([Bind(Include = "customerCarId,customerCarFirstName,customerCarLastName,customerCarPhone,address")] CustomerCar customerCar)
{
if (ModelState.IsValid)
{
db.CustomerCars.Add(customerCar);
db.SaveChanges();
return RedirectToAction("Index");
}
return View(customerCar);
}
// GET: CustomerCars/Delete/5
public ActionResult Delete(int? id)
{
if (id == null)
{
return new HttpStatusCodeResult(HttpStatusCode.BadRequest);
}
CustomerCar customerCar = db.CustomerCars.Find(id);
if (customerCar == null)
{
return HttpNotFound();
}
return View(customerCar);
}
public IActionResult Update(string id, [FromBody] CustomerCar CustomerCar)
{
var claims = User.Claims.Select(claim => new { claim.Type, claim.Value }).ToDictionary(t => t.Type, t => t.Value);
if (claims.ContainsKey("name"))
{
if (claims["name"].Equals("ADMIN") || claims["name"].Equals("MANAGER"))
{
return(Ok(_repository.Update(id, CustomerCar)));
}
}
else
{
return(Forbid());
}
return(Forbid());
}
public IActionResult Create([FromBody] CustomerCar CustomerCar)
{
var claims = User.Claims.Select(claim => new { claim.Type, claim.Value }).ToDictionary(t => t.Type, t => t.Value);
if (claims.ContainsKey("name"))
{
if (claims["name"].Equals("ADMIN") || claims["name"].Equals("MANAGER"))
{
CustomerCar.Id = Guid.NewGuid() + "";
CustomerCar.IsDelete = false;
return(Ok(_repository.Create(CustomerCar)));
}
}
else
{
return(Forbid());
}
return(Forbid());
}
public ActionResult SignUp(string fname, string lname, string email, DateTime dob, int year, string make, string carmodel, bool coverage, bool dui, int?ticket)
{
if (fname != "" || lname != "" || email != null || year <= DateTime.Today.Year || year > DateTime.Today.AddYears(-130).Year || carmodel != "" || make != "") //check for null values
{
if (ticket == null)
{
ticket = 0;
}
using (CarInsuranceEntities db = new CarInsuranceEntities())
{
string NewId = Guid.NewGuid().ToString();
var signUpCustomer = new Customer(); //Mapping objects instantiated for all three tables
var signupCar = new CustomerCar();
var signupRecord = new CustomerRecord();
signUpCustomer.DateofBirth = dob;
signUpCustomer.EmailAddress = email;
signUpCustomer.FirstName = fname;
signUpCustomer.LastName = lname;
signupCar.CarMake = make;
signupCar.CarModel = carmodel;
signupCar.CarYear = year;
signupRecord.DUI = dui;
signupRecord.FullCoverage = coverage;
signupRecord.NumofTicket = (int)ticket;
signUpCustomer.Id = NewId;
signupCar.CustomerId = NewId;
signupRecord.CustomerId = NewId;
db.Customers.Add(signUpCustomer);
db.CustomerCars.Add(signupCar);
db.CustomerRecords.Add(signupRecord);
db.SaveChanges();
}
}
else
{
return(RedirectToAction(@"~/views/Shared/Error.cshtml"));
}
return(View("Success"));
}
public IActionResult Update(string id, [FromBody] CustomerCar CustomerCar)
{
return(Ok(_repository.Update(id, CustomerCar)));
}
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;
}
}
