public static List <LlojiVetures> GetLlojiVeturesByVeturaID(int id)
{
List <LlojiVetures> llojiVetures = new List <LlojiVetures>();
using (SqlConnection con = new SqlConnection(ConnectionWithDB.GetConnection()))
{
SqlCommand cmd = new SqlCommand("usp_GetAllVeturasByVeturaID", con);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@VeturaID", id);
con.Open();
SqlDataReader sqlDataReader = cmd.ExecuteReader();
while (sqlDataReader.Read())
{
LlojiVetures lloji = new LlojiVetures();
lloji.LlojiID = int.Parse(sqlDataReader["LlojiID"].ToString());
lloji.Emri = sqlDataReader["Emrilloji"].ToString();
lloji.Foto = sqlDataReader["Foto"].ToString();
lloji.IsActive = bool.Parse(sqlDataReader["IsActive"].ToString());
Vetura st = new Vetura();
st.VeturaID = int.Parse(sqlDataReader["VeturaID"].ToString());
st.Emri = sqlDataReader["EmriVetura"].ToString();
lloji.Vetura = st;
llojiVetures.Add(lloji);
}
}
return(llojiVetures);
}
public ActionResult DeleteConfirmed(int id)
{
Vetura vetura = db.Veturas.Find(id);
db.Veturas.Remove(vetura);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "VeturaID,Emri,IsActive")] Vetura vetura)
{
if (ModelState.IsValid)
{
db.Entry(vetura).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(vetura));
}
public ActionResult Create([Bind(Include = "VeturaID,Emri,IsActive")] Vetura vetura)
{
if (ModelState.IsValid)
{
//db.Veturas.Add(vetura);
//db.SaveChanges();
//return RedirectToAction("Index");
}
return(RedirectToAction("Index"));
}
// GET: Veturas/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Vetura vetura = db.Veturas.Find(id);
if (vetura == null)
{
return(HttpNotFound());
}
return(View(vetura));
}
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);
}