public static Brendi GetBrendByID(int id)
{
Brendi brendi = new Brendi();
using (SqlConnection con = new SqlConnection(ConnectionWithDB.GetConnection()))
{
SqlCommand cmd = new SqlCommand("usp_GetBrandByID", con);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@BrandID", id);
con.Open();
SqlDataReader sqlDataReader = cmd.ExecuteReader();
while (sqlDataReader.Read())
{
brendi.BrendiID = int.Parse(sqlDataReader["BrendiID"].ToString());
brendi.Emri = sqlDataReader["Emri"].ToString();
brendi.Foto = sqlDataReader["Foto"].ToString();
brendi.IsActive = bool.Parse(sqlDataReader["IsActive"].ToString());
}
}
return(brendi);
}
public static List <Brendi> GetAllBrendet()
{
List <Brendi> brendet = new List <Brendi>();
using (SqlConnection con = new SqlConnection(ConnectionWithDB.GetConnection()))
{
SqlCommand cmd = new SqlCommand("usp_GetAllBrands", con);
con.Open();
SqlDataReader sqlDataReader = cmd.ExecuteReader();
while (sqlDataReader.Read())
{
Brendi st = new Brendi();
st.BrendiID = int.Parse(sqlDataReader["BrendiID"].ToString());
st.Emri = sqlDataReader["Emri"].ToString();
st.Foto = sqlDataReader["Foto"].ToString();
st.IsActive = bool.Parse(sqlDataReader["IsActive"].ToString());
brendet.Add(st);
}
}
return(brendet);
}
public ActionResult DeleteConfirmed(int id)
{
Brendi brendi = db.Brendis.Find(id);
db.Brendis.Remove(brendi);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "BrendiID,Emri,Foto,IsActive")] Brendi brendi)
{
if (ModelState.IsValid)
{
db.Entry(brendi).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(brendi));
}
// GET: Brendis/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Brendi brendi = db.Brendis.Find(id);
if (brendi == null)
{
return(HttpNotFound());
}
return(View(brendi));
}
public static void AddBrand(Brendi brendi)
{
using (SqlConnection con = new SqlConnection(ConnectionWithDB.GetConnection()))
{
SqlCommand cmd = new SqlCommand("usp_AddBrand", con);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
con.Open();
cmd.Parameters.AddWithValue("@Emri", brendi.Emri);
cmd.Parameters.AddWithValue("@Foto", brendi.Foto);
cmd.ExecuteNonQuery();
}
}
public static List <VM_VeturaWithLlojet> GetAllVeturasByBrandID(int id)
{
List <VM_VeturaWithLlojet> veturat = new List <VM_VeturaWithLlojet>();
using (SqlConnection con = new SqlConnection(ConnectionWithDB.GetConnection()))
{
SqlCommand cmd = new SqlCommand("usp_GetAllVeturaByBrandID", con);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@BrendiID", id);
con.Open();
SqlDataReader sqlDataReader = cmd.ExecuteReader();
while (sqlDataReader.Read())
{
VM_VeturaWithLlojet vm = new VM_VeturaWithLlojet();
Vetura st = new Vetura();
st.VeturaID = int.Parse(sqlDataReader["VeturaID"].ToString());
st.Emri = sqlDataReader["Emrivetura"].ToString();
st.IsActive = bool.Parse(sqlDataReader["IsActive"].ToString());
Brendi b = new Brendi();
b.BrendiID = int.Parse(sqlDataReader["BrendiID"].ToString());
b.Emri = sqlDataReader["Emribrendi"].ToString();
st.Brendi = b;
List <LlojiVetures> list = new List <LlojiVetures>();
list = DAL_LLojetVetures.GetLlojiVeturesByVeturaID(st.VeturaID);
vm.Vetura = st;
vm.llojetlist = list;
veturat.Add(vm);
}
}
return(veturat);
}
public ActionResult Create([Bind(Include = "BrendiID,Emri,Foto,IsActive")] Brendi brendi, HttpPostedFileBase image)
{
string imagename = Path.GetFileName(image.FileName);
string path = Server.MapPath("/Content/brendetimages/" + imagename);
image.SaveAs(path);
if (ModelState.IsValid)
{
// db.Brendis.Add(brendi);
//db.SaveChanges();
brendi.Foto = imagename;
DAL_Brendet.AddBrand(brendi);
return(RedirectToAction("Index"));
}
return(View(brendi));
}
