public static bool Update(Salla Salla) { var conn = DBHelper.GetConnection(); try { var cmd = new SqlCommand("dbo.usp_Sallat_Edit", conn); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@SallaID", Salla.SallaID); cmd.Parameters.AddWithValue("@NumriSalles", Salla.NumriSalles); cmd.Parameters.AddWithValue("@Tipi", Salla.Tipi); cmd.Parameters.AddWithValue("@LastUpdate", Salla.LastUpdate); conn.Open(); cmd.ExecuteNonQuery(); return(true); } catch (Exception) { return(false); } finally { conn.Close(); } }
public static List <Salla> List() { var list = new List <Salla>(); var conn = DBHelper.GetConnection(); var cmd = new SqlCommand("usp_Sallat_List", conn); cmd.CommandType = CommandType.StoredProcedure; try { conn.Open(); var rdr = cmd.ExecuteReader(); while (rdr.Read()) { var sallat = new Salla(); sallat.SallaID = int.Parse(rdr["SallaID"].ToString()); sallat.NumriSalles = int.Parse(rdr["NumriSalles"].ToString()); sallat.Tipi = char.Parse(rdr["Tipi"].ToString()); sallat.CreatedOn = DateTime.Parse(rdr["CreatedOn"].ToString()); sallat.LastUpdate = string.IsNullOrEmpty(rdr["LastUpdate"].ToString()) == true ? DateTime.Now : DateTime.Parse(rdr["LastUpdated"].ToString()); list.Add(sallat); } return(list); } catch (Exception ex) { return(null); } finally { conn.Close(); } }
public static bool Insert(Salla sallat) { var conn = DBHelper.GetConnection(); try { var cmd = new SqlCommand("dbo.usp_Sallat_Add", conn); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@NumriSalles", sallat.NumriSalles); cmd.Parameters.AddWithValue("@Tipi", sallat.Tipi); cmd.Parameters.AddWithValue("@CreatedOn", sallat.CreatedOn); conn.Open(); cmd.ExecuteNonQuery(); return(true); } catch (Exception ex) { return(false); } finally { conn.Close(); } }
public ActionResult Create(Salla salla) { try { // TODO: Add insert logic here salla.CreatedOn = DateTime.Now; if (SallatDAL.Insert(salla)) { return(Redirect("Index")); } return(View(salla)); } catch { return(View()); } }
public ActionResult Create([Bind(Include = "Id_Salla,Statusi,Nr_Rreshtave,Nr_Kolonave")] Salla salla) { try { salla.Statusi = "Available"; if (ModelState.IsValid) { db.Sallas.Add(salla); db.SaveChanges(); TempData["rezsuccess"] = "<script>alert('U shtua me sukses!');</script>"; return(RedirectToAction("Index")); } } catch (Exception ex) { logger.ErrorException("Error i gjendur ne kontroller Manager dhe ne Create Action", ex); } return(View(salla)); }
public static Salla Read(int id) { var salla = new Salla(); var conn = DBHelper.GetConnection(); var cmd = new SqlCommand("usp_Sallat_Read", conn); cmd.CommandType = CommandType.StoredProcedure; try { if (id != 0) { cmd.Parameters.AddWithValue("@GrupiId", id); conn.Open(); var rdr = cmd.ExecuteReader(); if (rdr.Read()) { salla.SallaID = int.Parse(rdr["SallaID"].ToString()); salla.NumriSalles = int.Parse(rdr["NumriSalles"].ToString()); salla.Tipi = char.Parse(rdr["Tipi"].ToString()); salla.CreatedOn = DateTime.Parse(rdr["CreatedOn"].ToString()); salla.LastUpdate = DateTime.Parse(rdr["LastUpdated"].ToString()) == null ? DateTime.Now : DateTime.Parse(rdr["LastUpdated"].ToString()); } return(salla); } else { return(null); } } catch (Exception) { return(null); } finally { conn.Close(); } }
// GET: Sallat/Details/5 public ActionResult Details(int id) { Salla salla = SallatDAL.Read(id); return(View("Details", salla)); }