public static int Create(Formulari formulari) { var conn = DBHelper.GetConnection(); try { var cmd = new SqlCommand("usp_Formulari_Insert", conn); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@prmGjenerataId", formulari.GjenerataId); cmd.Parameters.AddWithValue("@prmGjysmevjetoriId", formulari.GjysmevjetoriId); cmd.Parameters.AddWithValue("@prmMungesaMeArsye", formulari.MungesaMeArsye); cmd.Parameters.AddWithValue("@prmMungesaPaArsye", formulari.MungesaPaArsye); cmd.Parameters.Add("@prmId", SqlDbType.Int).Direction = ParameterDirection.Output; conn.Open(); cmd.ExecuteNonQuery(); return(Convert.ToInt32(cmd.Parameters["@prmId"].Value)); } catch (Exception) { throw; } finally { conn.Close(); } }
public ActionResult DeleteConfirmed(int id) { Formulari formulari = db.Formularis.Find(id); db.Formularis.Remove(formulari); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Edit([Bind(Include = "Id,GjenerataId,GjysmevjetoriId,ShkollaId,MungesaMeArsye,MungesaPaArsye")] Formulari formulari) { if (ModelState.IsValid) { db.Entry(formulari).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.GjenerataId = new SelectList(db.Gjeneratas, "Id", "Id", formulari.GjenerataId); ViewBag.GjysmevjetoriId = new SelectList(db.Gjysmevjetoris, "Id", "Id", formulari.GjysmevjetoriId); ViewBag.ShkollaId = new SelectList(db.Shkollas, "Id", "Emertimi", formulari.ShkollaId); return(View(formulari)); }
// GET: Formulari/Delete/5 public ActionResult Delete(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Formulari formulari = db.Formularis.Find(id); if (formulari == null) { return(HttpNotFound()); } return(View(formulari)); }
// GET: Formulari/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Formulari formulari = db.Formularis.Find(id); if (formulari == null) { return(HttpNotFound()); } ViewBag.GjenerataId = new SelectList(db.Gjeneratas, "Id", "Id", formulari.GjenerataId); ViewBag.GjysmevjetoriId = new SelectList(db.Gjysmevjetoris, "Id", "Id", formulari.GjysmevjetoriId); ViewBag.ShkollaId = new SelectList(db.Shkollas, "Id", "Emertimi", formulari.ShkollaId); return(View(formulari)); }
// GET: Formulari/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } FullFormularViewModel formulari = new FullFormularViewModel(); Formulari f = DAL.DAL_Formulari.Read(id); formulari.MungesaMeArsye = f.MungesaMeArsye; formulari.MungesaPaArsye = f.MungesaPaArsye; formulari.suksesiLendor = DAL.DAL_SuksesiLendor.List(id); if (formulari == null) { return(HttpNotFound()); } return(View(formulari)); }
public static Formulari Read(int?id) { var formulari = new Formulari(); var conn = DBHelper.GetConnection(); var cmd = new SqlCommand("usp_Formularet_GetById", conn); cmd.CommandType = CommandType.StoredProcedure; try { if (id != null) { cmd.Parameters.AddWithValue("@id", id); conn.Open(); var rdr = cmd.ExecuteReader(); if (rdr.Read()) { formulari.Id = int.Parse(rdr["Id"].ToString()); formulari.GjenerataId = int.Parse(rdr["GjenerataId"].ToString()); formulari.GjysmevjetoriId = int.Parse(rdr["GjysmevjetoriId"].ToString()); formulari.ShkollaId = int.Parse(rdr["ShkollaId"].ToString()); formulari.MungesaMeArsye = int.Parse(rdr["MungesaMeArsye"].ToString()); formulari.MungesaPaArsye = int.Parse(rdr["MungesaPaArsye"].ToString()); } return(formulari); } else { return(null); } } catch (Exception) { return(null); } finally { conn.Close(); } }
public static List <Formulari> ListFormular() { var LstGJ = new List <Formulari>(); var conn = DBHelper.GetConnection(); var cmd = new SqlCommand("usp_Formulari_GetList", conn); cmd.CommandType = System.Data.CommandType.StoredProcedure; try { conn.Open(); var rdr = cmd.ExecuteReader(); while (rdr.Read()) { var formulari = new Formulari(); formulari.GjenerataId = int.Parse(rdr["GjenerataId"].ToString()); formulari.Id = int.Parse(rdr["Id"].ToString()); formulari.GjysmevjetoriId = int.Parse(rdr["GjysmevjetoriId"].ToString()); formulari.ShkollaId = int.Parse(rdr["ShkollaId"].ToString()); formulari.MungesaMeArsye = int.Parse(rdr["MungesaMeArsye"].ToString()); formulari.MungesaPaArsye = int.Parse(rdr["MungesaPaArsye"].ToString()); formulari.Gjysmevjetori = DAL_Gjysmevjetori.Read(formulari.GjysmevjetoriId); formulari.Gjenerata = DAL_Gjenerata.Read(formulari.GjenerataId); LstGJ.Add(formulari); } return(LstGJ); } catch (Exception) { return(null); } finally { conn.Close(); } }