public IActionResult CarRegister(CarRegister carregister, IFormFile[] Images)
{
if (Images == null || Images.Length == 0)
{
//return Content("File(s) not selected");
}
else
{
carregister.DtImages = new DataTable();
carregister.DtImages.Columns.Add("ImagePath");
carregister.Images = new List <string>();
foreach (IFormFile photo in Images)
{
var path = Path.Combine(Directory.GetCurrentDirectory(), "wwwroot/images", photo.FileName);
var stream = new FileStream(path, FileMode.Create);
photo.CopyToAsync(stream);
carregister.Images.Add(photo.FileName);
carregister.DtImages.Rows.Add("../images/" + photo.FileName);
}
}
bool resltflag = _idalRep.SaveRegister(carregister);
if (resltflag)
{
_carregister = new CarRegister();
}
_carregister.CarManinfo = _idalRep.Gatcarmaninfo();
return(View(_carregister));
}
public IActionResult AddModel()
{
CarRegister _carregister = new CarRegister();
_carregister.CarManinfo = _idalRep.Gatcarmaninfo();
return(View(_carregister));
}
public IActionResult AddModel(CarRegister carregister)
{
bool resltflag = _idalRep.SaveModel(carregister);
if (resltflag)
{
return(RedirectToAction("CarRegister", "Master"));
}
return(View(carregister));
}
public ActionResult DeleteConfirmed(int id)
{
if (Session["UserID"] == null)
{
return(RedirectToAction("Login"));
}
CarRegister carRegister = db.CarRegisters.Find(id);
db.CarRegisters.Remove(carRegister);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "CarId,CarNum,Brand,Model,Available")] CarRegister carRegister)
{
if (Session["UserID"] == null)
{
return(RedirectToAction("Login"));
}
if (ModelState.IsValid)
{
db.Entry(carRegister).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(carRegister));
}
public ActionResult Create([Bind(Include = "CarId,CarNum,Brand,Model,Available")] CarRegister carRegister)
{
if (Session["UserID"] == null)
{
return(RedirectToAction("Login"));
}
if (ModelState.IsValid)
{
db.CarRegisters.Add(carRegister);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(carRegister));
}
// GET: CarRegisters/Delete/5
public ActionResult Delete(int?id)
{
if (Session["UserID"] == null)
{
return(RedirectToAction("Login"));
}
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
CarRegister carRegister = db.CarRegisters.Find(id);
if (carRegister == null)
{
return(HttpNotFound());
}
return(View(carRegister));
}
public bool SaveModel(CarRegister _carRegister)
{
try
{
using (SqlConnection con = new SqlConnection(Constr))
{
SqlCommand cmd = new SqlCommand(SystemConstant.SaveModel, con);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@BrandId", _carRegister.Brand_id);
cmd.Parameters.AddWithValue("@ModelName", _carRegister.Model_name);
con.Open();
var statflag = cmd.ExecuteNonQuery();
con.Close();
return(statflag == 1 ? true : false);
}
}
catch (Exception ex)
{
return(false);
}
}
public bool SaveRegister(CarRegister _carRegister)
{
try
{
using (SqlConnection con = new SqlConnection(Constr))
{
SqlCommand cmd = new SqlCommand(SystemConstant.SaveCarRegister, con);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Modelid", _carRegister.Model_id);
cmd.Parameters.AddWithValue("@Yearbuild", _carRegister.YearBuild);
cmd.Parameters.AddWithValue("@kilometer_coverd", _carRegister.Kilometer_Coverd);
cmd.Parameters.AddWithValue("@CarImages", _carRegister.DtImages);
con.Open();
var statflag = cmd.ExecuteNonQuery();
con.Close();
return(statflag == 1 ? true : false);
}
}
catch (Exception ex)
{
return(false);
}
}
public static void Initialize(CarContext context)
{
context.Database.EnsureCreated();
// Look for any students.
if (context.Persons.Any())
{
return; // DB has been seeded
}
var persons = new Person[]
{
new Person {
Firstname = "Erik"
},
new Person {
Firstname = "Eva"
},
new Person {
Firstname = "Charlie"
},
new Person {
Firstname = "Thomas"
},
new Person {
Firstname = "Benjamin"
},
};
foreach (Person person in persons)
{
context.Persons.Add(person);
}
context.SaveChanges();
var cars = new Car[]
{
new Car {
Make = "Ascona", Model = "Opel"
},
new Car {
Make = "Audi", Model = "Q5"
},
};
foreach (Car car in cars)
{
context.Cars.Add(car);
}
context.SaveChanges();
var register = new CarRegister[]
{
new CarRegister {
CarID = 1, PersonID = 1
},
new CarRegister {
CarID = 1, PersonID = 2
},
new CarRegister {
CarID = 2, PersonID = 1
},
};
foreach (CarRegister item in register)
{
context.CarRegisters.Add(item);
}
context.SaveChanges();
}
