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();
}
}
