public Makes AddMake(Makes newmodel)
{
try
{
using (var sqlConnection = new SqlConnection())
{
sqlConnection.ConnectionString = sqlConnectionString;
SqlCommand cmd = new SqlCommand();
cmd.Connection = sqlConnection;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "AddMake";
cmd.Parameters.AddWithValue("@Description", newmodel.Description.ToString());
cmd.Parameters.AddWithValue("@UserId", newmodel.UserId.ToString());
cmd.Parameters.AddWithValue("@DateAdded", newmodel.DateAdded.ToString());
cmd.Parameters.Add(new SqlParameter("@NewID", SqlDbType.Int));
cmd.Parameters["@NewID"].Direction = ParameterDirection.Output;
sqlConnection.Open();
cmd.ExecuteNonQuery();
newmodel.MakeId = (int)cmd.Parameters["@NewID"].Value;
}
return(newmodel);
}
catch
{
return(null);
}
}
public ActionResult AddMake(SalesIndexMakesCM form)
{
if (ModelState.IsValid)
{
Makes make = new Makes();
var repo = new MakeRepositoryADO();
make.Make = form.Make;
make.DateAdded = form.DateAdded;
make.EmployeeId = form.EmployeeId;
form.EmployeeId = 1;
repo.CreateMake(make);
return(RedirectToAction("Index"));
}
else
{
SalesIndexMakesVM VM = new SalesIndexMakesVM();
var makes = new MakeRepositoryADO();
VM.Makes = makes.ReadAllMakes();
VM.Form = form;
return(View(VM));
}
}
public Makes GetMakeById(int id)
{
try
{
Makes model = null;
using (var sqlConnection = new SqlConnection())
{
sqlConnection.ConnectionString = sqlConnectionString;
SqlCommand cmd = new SqlCommand();
cmd.Connection = sqlConnection;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "GetMakeById";
cmd.Parameters.AddWithValue("@MakeId", id);
sqlConnection.Open();
SqlDataReader sqlDataRdr = cmd.ExecuteReader();
if (sqlDataRdr.Read())
{
model = new Makes();
model.MakeId = (int)sqlDataRdr["MakeId"];
model.Description = sqlDataRdr["Description"].ToString();
}
return(model);
}
}
catch
{
return(null);
}
}
public List <Makes> GetMakes()
{
List <Makes> MakeChoices = new List <Makes>();
using (SqlConnection cn = new SqlConnection(DataSettings.GetConnectionString()))
{
SqlCommand cmd = new SqlCommand("Select * from Make", cn);
cmd.CommandType = CommandType.Text;
cn.Open();
using (SqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
Makes s = new Makes();
s.MakeID = (int)dr["MakeID"];
s.MakeName = dr["MakeName"].ToString();
s.AddedBy = dr["Addedby"].ToString();
s.DateAdded = DateTime.Parse(dr["DateAdded"].ToString()).Date;
MakeChoices.Add(s);
}
}
}
return(MakeChoices);
}
public void SetMakeItems(IEnumerable <Make> makes)
{
foreach (var make in makes)
{
Makes.Add(make);
}
}
public Makes ReadByMakeId(int makeId)
{
Makes Make = new Makes();
using (var cn = new SqlConnection(Settings.GetConnectionString()))
{
SqlCommand cmd = new SqlCommand("ReadByMakeId", cn);
cmd.CommandType = CommandType.StoredProcedure;
cn.Open();
using (SqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
Makes currentMake = new Makes();
currentMake.MakeId = (int)dr["MakeId"];
currentMake.Make = dr["Make"].ToString();
currentMake.DateAdded = (DateTime)dr["DateAdded"];
//currentMake.ModelId = (VehicleModels)dr["ModelId"];
currentMake.EmployeeId = (int)dr["EmployeeId"];
Make = currentMake;
}
}
cn.Close();
}
return(Make);
}
protected void ddlYear_SelectedIndexChanged(object sender, EventArgs e)
{
ddlMake.Items.Clear();
ddlModel.Items.Clear();
ddlTrim.Items.Clear();
string json = Util.GetJson("https://www.carqueryapi.com/api/0.3/?cmd=getMakes&year=" + Util.SSC(ddlYear.SelectedValue) + "&sold_in_us=1");
Makes makes = Newtonsoft.Json.JsonConvert.DeserializeObject <Makes>(json);
foreach (Make make in makes.makes)
{
ddlMake.Items.Add(new ListItem(make.make_display, make.make_id));
}
json = Util.GetJson("https://www.carqueryapi.com/api/0.3/?cmd=getModels&make=" + Util.SSC(ddlMake.SelectedValue) + "&year=" + Util.SSC(ddlYear.SelectedValue) + "&sold_in_us=1");
Models models = Newtonsoft.Json.JsonConvert.DeserializeObject <Models>(json);
foreach (Model model in models.models)
{
ddlModel.Items.Add(new ListItem(model.model_name, model.model_name));
}
json = Util.GetJson("https://www.carqueryapi.com/api/0.3/?cmd=getTrims&make=" + Util.SSC(ddlMake.SelectedValue) + "&year=" + Util.SSC(ddlYear.SelectedValue) + "&model=" + Util.SSC(ddlModel.SelectedValue));
Trims trims = Newtonsoft.Json.JsonConvert.DeserializeObject <Trims>(json);
foreach (Trim trim in trims.trims)
{
ddlTrim.Items.Add(new ListItem(trim.model_trim, trim.model_id));
}
}
public Makes GetMakeForModel(int modelId)
{
Makes make = new Makes();
using (var cn = new SqlConnection(Settings.GetConnectionString()))
{
SqlCommand cmd = new SqlCommand("GetMakeForModel", cn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@ModelId", modelId);
cn.Open();
using (SqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
make.MakeId = (int)dr["MakeId"];
make.MakeDescription = dr["MakeDescription"].ToString();
make.UserId = dr["UserId"].ToString();
make.MakeDateAdded = (DateTime)dr["MakeDateAdded"];
}
}
}
return(make);
}
public IEnumerable <Makes> GetAll()
{
List <Makes> makes = new List <Makes>();
using (var cn = new SqlConnection(Settings.GetConnectionString()))
{
SqlCommand cmd = new SqlCommand("MakesSelectAll", cn);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cn.Open();
using (SqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
Makes currentRow = new Makes();
currentRow.MakeID = (int)dr["MakeID"];
currentRow.Make = dr["Make"].ToString();
currentRow.CreateDate = (DateTime)dr["CreateDate"];
currentRow.UserName = dr["UserName"].ToString();
makes.Add(currentRow);
}
}
return(makes);
}
}
public async Task <IActionResult> Edit(int id, [Bind("MakeId,MakeName")] Makes makes)
{
if (id != makes.MakeId)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(makes);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!MakesExists(makes.MakeId))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
return(View(makes));
}
public Car(int armor, Makes make, Models model, Dictionary <CarColors, int> carcolor, int health, float speed)
{
this.Armor = armor;
this.Make = make;
this.Model = model;
this.CarColor = carcolor;
this.Health = health;
}
private static async Task InsertTestData(IServiceProvider serviceProvider)
{
await AddOrUpdateAsync(serviceProvider, g => g.MakeId, Makes.Select(m => m.Value));
await AddOrUpdateAsync(serviceProvider, g => g.ModelId, Models.Select(m => m.Value));
await AddOrUpdateAsync(serviceProvider, g => g.BodyTypeId, BodyTypes.Select(m => m.Value));
await AddOrUpdateAsync(serviceProvider, g => g.CarId, Cars.Select(m => m.Value));
await AddOrUpdateAsync(serviceProvider, g => g.OrderId, Orders);
}
public ActionResult DeleteConfirmed(int id)
{
Makes makes = db.Makes.Find(id);
db.Makes.Remove(makes);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public Make AddMake(Make toAdd, string userId)
{
var user = Users.Single(u => u.Id == userId);
toAdd.UserAddedBy = user;
Makes.Add(toAdd);
SaveChanges();
return(toAdd);
}
public Makes GetMakeForModel(int modelId)
{
Makes make = new Makes();
var result = _Models.FirstOrDefault(m => m.ModelId == modelId);
make = _Makes.FirstOrDefault(mk => mk.MakeId == result.MakeId);
return(make);
}
public void GetMakeById(string expectedDesc, int expectedId)
{
Makes model = new Makes();
IRepository repo = new ADORepository();
model = repo.GetMakeById(expectedId);
Assert.AreEqual(expectedDesc, model.Description);
Assert.AreEqual(expectedId, model.MakeId);
}
private void OnRemoveMake(object obj)
{
if (SelectedMake == null)
{
return;
}
Repository.Remove(SelectedMake);
Makes.Remove(SelectedMake);
}
public ActionResult Edit([Bind(Include = "ID,Make")] Makes makes)
{
if (ModelState.IsValid)
{
db.Entry(makes).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(makes));
}
public void SetMakes(IEnumerable <MakeModel> makes)
{
foreach (var make in makes)
{
Makes.Add(new SelectListItem()
{
Value = make.Make,
Text = make.Make
});
}
}
public async Task <IActionResult> Create([Bind("MakeId,MakeName")] Makes makes)
{
if (ModelState.IsValid)
{
_context.Add(makes);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(makes));
}
public ActionResult Create([Bind(Include = "ID,Make")] Makes makes)
{
if (ModelState.IsValid)
{
db.Makes.Add(makes);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(makes));
}
public void SetMakes(IEnumerable <VehicleMake> vehicleMake)
{
foreach (var make in vehicleMake)
{
Makes.Add(new SelectListItem()
{
Value = make.VehicleMakeId.ToString(),
Text = make.Make
});
}
}
public void SetMakes(IEnumerable <Makes> makes)
{
foreach (var m in makes)
{
Makes.Add(new SelectListItem()
{
Value = m.MakeId.ToString(),
Text = m.Description.ToString()
});
}
}
public Make AddMake(string makeName, int adminId)
{
Make newMake = new Make();
newMake.MakeId = Makes.Max(i => i.MakeId) + 1;
newMake.MakeName = makeName;
newMake.AdminId = adminId;
newMake.Created = DateTime.Now;
Makes.Add(newMake);
(this).SaveChanges();
return(newMake);
}
public void SetMakesAndModels(Manager manager)
{
AllMakes = manager.GetAllMakes();
AllModels = manager.GetAllModels();
foreach (var make in AllMakes)
{
Makes.Add(new SelectListItem
{
Text = make.Name,
Value = make.Id.ToString()
});
}
}
// GET: Makes/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Makes makes = db.Makes.Find(id);
if (makes == null)
{
return(HttpNotFound());
}
return(View(makes));
}
public void CanAddMake()
{
var repo = new MakeRepositoryADO();
Makes newMake = new Makes()
{
Make = "Chevy",
UserName = "******"
};
repo.Add(newMake);
var makes = repo.GetAll();
Assert.AreEqual(makes.Count(), 4);
}
public void CanAddMake(string description, string userId, string dateAdded)
{
IRepository ADORepo = new ADORepository();
Makes model = new Makes();
model.Description = description;
model.DateAdded = dateAdded;
model.UserId = userId;
Makes newMake = ADORepo.AddMake(model);
Assert.AreEqual(model.MakeId, newMake.MakeId);
Assert.AreEqual(model.Description, newMake.Description);
Assert.AreEqual(model.UserId, newMake.UserId);
Assert.AreEqual(model.DateAdded, newMake.DateAdded);
}
public ActionResult AddMake(Makes model)
{
var repo = RepositoryFactory.GetRepository();
model.DateAdded = DateTime.Now.ToString();
//Find id of logged in user
var userName = User.Identity.GetUserName();
var userId = context.Users.FirstOrDefault(u => u.UserName == userName).Id;
model.UserId = userId;
repo.AddMake(model);
return(RedirectToAction("AddMake", "Admin"));
}
private void InitializeMakes()
{
this.Makes = new List <string>();
Makes.Add("Land Rover");
Makes.Add("Jaguar");
Makes.Add("Mini");
Makes.Add("Porche");
Makes.Add("Volkswagen");
Makes.Add("Audi");
Makes.Add("Toyota");
Makes.Add("Vaxhaul");
Makes.Add("Peugeot");
Makes.Add("Skoda");
Makes.Add("Lexus");
}
