public static void InsertNewClietn(Klienti klienti) { if (IsValid(klienti)) { dalKlineti.Insert(klienti); } }
public async Task <IActionResult> Edit(int id, [Bind("KlientiId,Emri,Mbiemri,NumriTelefonit,Email")] Klienti klienti) { if (id != klienti.KlientiId) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(klienti); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!KlientiExists(klienti.KlientiId)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(Index))); } return(View(klienti)); }
public ActionResult Edit(Klienti klienti) { if (Session["UserID"] != null) { KlientiBusiness kb = new KlientiBusiness(); if (ModelState.IsValid) { if (kb.Klientet.Any(ac => ac.emri.Equals(klienti.emri) && !ac.id.Equals(klienti.id))) { //error ModelState.AddModelError(string.Empty, "Ky Klient egziston"); return(View()); } else { klienti.agjensi = true; kb.modifiko(klienti); return(RedirectToAction("Index", "Agjensi")); } } else { Utility utility = new Utility(); ViewBag.IdDispecheri = new SelectList(utility.GetDispecher(), "id", "emri"); ViewBag.IdMagazina = new SelectList(utility.GetMagazina(), "id", "emri"); return(View()); } } else { return(RedirectToAction("Index", "Hyrje")); } }
public static List <Klienti> GetAll() { List <Klienti> list = new List <Klienti>(); using (SqlConnection conn = new SqlConnection(cs)) { conn.Open(); SqlCommand cmd = new SqlCommand("spShfaqTeGjithKlientet", conn); cmd.CommandType = CommandType.StoredProcedure; using (IDataReader reader = cmd.ExecuteReader()) { while (reader.Read()) { var klienti = new Klienti(); klienti.IdKlienti = reader["IdKlienti"].ToString(); klienti.Emri = reader["Emri"].ToString(); klienti.Adresani = reader["Adresa"].ToString(); klienti.NrTelefonit = reader["NrTelefonit"].ToString(); klienti.IsKlient = bool.Parse(reader["IsKlinet"].ToString()); list.Add(klienti); } conn.Close(); } } return(list); }
public static IEnumerable <Klienti> GetklientByID(string id) { var list = new List <Klienti>(); using (SqlConnection conn = new SqlConnection(cs)) { conn.Open(); SqlCommand cmd = new SqlCommand("spKerkoKlientin", conn); cmd.Parameters.AddWithValue("@_IdKlienti", id); cmd.CommandType = CommandType.StoredProcedure; using (IDataReader reader = cmd.ExecuteReader()) { while (reader.Read()) { var klienti = new Klienti(); klienti.IdKlienti = id; klienti.Emri = reader["Emri"].ToString(); klienti.Adresani = reader["Adresa"].ToString(); klienti.NrTelefonit = reader["NrTelefonit"].ToString(); klienti.IsKlient = bool.Parse(reader["IsKlinet"].ToString()); list.Add(klienti); } } } return(list); }
public ActionResult Create(Klienti klienti) { if (Session["UserID"] != null) { KlientiBusiness kb = new KlientiBusiness(); if (ModelState.IsValid) { if (kb.Klientet.Any(ac => ac.emri.Equals(klienti.emri))) { //error ModelState.AddModelError(string.Empty, "Egziston nje klient me kete emer !"); return(View()); } else { kb.shto(klienti); return(RedirectToAction("Index", "Klienti")); } } else { Utility utility = new Utility(); ViewBag.IdDispecheri = new SelectList(utility.GetDispecher(), "id", "emri"); //ViewBag.IdMagazina = new SelectList(utility.GetMagazina(), "id", "emri"); return(View()); } } else { return(RedirectToAction("Index", "Hyrje")); } }
public async Task <IActionResult> Edit(int id, [Bind("id,Emri,Email,NumriTel,Aktiv,created_at,deleted_at")] Klienti k) { if (id != k.id) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(k); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!KlientiExists(k.id)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(Index))); } return(View(k)); }
private static bool IsValid(Klienti klienti) { if (klienti.IdKlienti != "" && klienti.Adresani != "" & klienti.Emri != "" & klienti.IsKlient == true & klienti.NrTelefonit != "") { return(true); } return(false); }
private void DeleteForm(int ID, string page) { if (page == "/Views/Klientet/Index.aspx") { Klienti obj = new Klienti(); obj.KlientiID = ID; KlientiMapper objm = new KlientiMapper(obj); objm.Delete(); } }
public async Task <IActionResult> Create([Bind("KlientiId,Emri,Mbiemri,NumriTelefonit,Email")] Klienti klienti) { if (ModelState.IsValid) { _context.Add(klienti); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } return(View(klienti)); }
private void placeShenimet() { Index form = (Index)Context.Handler; int ID = form.SelectedID; ViewState["SelectedID"] = ID; Klienti ex = new Klienti(); KlientiMapper em = new KlientiMapper(ex); em.SelectedID(ID); }
public ActionResult Detaje(int id) { if (Session["UserID"] != null) { KlientiBusiness kb = new KlientiBusiness(); Klienti kl = kb.Klientet.Single(s => s.id == id); return(View(kl)); } else { return(RedirectToAction("Index", "Hyrje")); } }
public static void Initialize(LibrarymsContext context) { context.Database.EnsureCreated(); //Look for any students. if (context.Libra.Any() || context.Klienti.Any() || context.Roles.Any()) { return; // DB has been seeded } var lirbat = new Libra[] { new Libra { Titulli = "When Harry Met Sally", Autori = "Filan Fisteku", E_Lire = true, } }; foreach (Libra s in lirbat) { context.Libra.Add(s); } context.SaveChanges(); var klientet = new Klienti[] { new Klienti { Emri = "Leutrim Ahmeti", Email = "*****@*****.**", Aktiv = true, NumriTel = "044444444" }, }; foreach (Klienti k in klientet) { context.Klienti.Add(k); } context.SaveChanges(); var rezervimi = new Rezervimi[] { new Rezervimi { Klienti_id = 1, Libra_id = 2, Aktiv = true } }; foreach (Rezervimi r in rezervimi) { context.Rezervimi.Add(r); } context.SaveChanges(); }
private void simpleButton3_Click(object sender, EventArgs e) { Klienti klienti = null; try { klienti = new Klienti(textBox1.Text.ToString()); } catch { XtraMessageBox.Show("Kujdes!!! Klienti nuk ekziston !!!"); return; } Reporting.Reporting.GetSales(dateEdit4.DateTime, dateEdit3.DateTime.AddDays(1), klienti); }
public async Task <IActionResult> OnGetAsync(long?id) { if (id == null) { return(NotFound()); } Klienti = await _context.Klienti.FirstOrDefaultAsync(m => m.ID == id); if (Klienti == null) { return(NotFound()); } return(Page()); }
private void Save_Event(object sender, EventArgs e) { string txt = textBox1.Text.ToString(); if (txt == "") { MessageBox.Show("Vendos Emrin!"); } klienti = new Klienti() { Emri = txt }; klienti.Save(); Load(); updateEvent.Invoke(); }
public static void GetSales(DateTime start, DateTime end, Klienti klienti) { string path = System.IO.Path.GetFullPath(@"Reporting\Shitjet.txt"); XtraReport report = new XtraReport(); report = XtraReport.FromFile(path, true); report.FindControl("lbInvoice", true).Text = "Raport Shitjesh " + klienti.Emri; ReportPrintTool pt = new ReportPrintTool(report); PrintingSystemBase ps = pt.PrintingSystem; report.PrintingSystem.SetCommandVisibility(DevExpress.XtraPrinting.PrintingSystemCommand.Parameters, DevExpress.XtraPrinting.CommandVisibility.None); report.DataSource = GetAll.GetSales(start, end, klienti.ID); report.DataMember = "CustomSqlQuery"; report.DisplayName = "Invoice"; report.ShowPreview(); }
public static void Insert(Klienti k) { using (SqlConnection conn = new SqlConnection(cs)) { conn.Open(); SqlCommand cmd = new SqlCommand("spShtoKlient", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@_IdKlienti", k.IdKlienti); cmd.Parameters.AddWithValue("@_Emri", k.Emri); cmd.Parameters.AddWithValue("@_Adresa", k.Adresani); cmd.Parameters.AddWithValue("@_NrTelefeoni", k.NrTelefonit); cmd.Parameters.AddWithValue("@_IsKlient", k.IsKlient); cmd.ExecuteNonQuery(); conn.Close(); } }
protected void SaveButton_Click(object sender, EventArgs e) { if (EmriTextBox.Text.Length == 0) { lblError.Visible = true; EmriTextBox.Focus(); return; } else if (MbiemriTextBox.Text.Length == 0) { lblError.Visible = true; MbiemriTextBox.Focus(); return; } else if (NumriTelefonitTextBox.Text.Length == 0) { lblError.Visible = true; NumriTelefonitTextBox.Focus(); return; } else if (NumriTelefonitTextBox.Text.Length == 0) { lblError.Visible = true; NumriTelefonitTextBox.Focus(); return; } else { int ID = Convert.ToInt32(ViewState["SelectedID"].ToString()); Klienti ex = new Klienti(); KlientiMapper em = new KlientiMapper(ex); em.SelectedID(ID); ex.Emri = EmriTextBox.Text; ex.Mbiemri = MbiemriTextBox.Text; ex.NumriTelefonit = int.Parse(NumriTelefonitTextBox.Text); ex.Email = EmailTextBox.Text; em.Update(); Response.Redirect("Index.aspx"); } }
public async Task <IActionResult> OnPostAsync(long?id) { if (id == null) { return(NotFound()); } Klienti = await _context.Klienti.FindAsync(id); if (Klienti != null) { _context.Klienti.Remove(Klienti); await _context.SaveChangesAsync(); } return(RedirectToPage("./Index")); }
public ActionResult Edit(int id) { if (Session["UserID"] != null) { Utility utility = new Utility(); KlientiBusiness kb = new KlientiBusiness(); Klienti kl = kb.Klientet.Single(s => s.id == id); ViewBag.IdDispecheri = new SelectList(utility.GetDispecher(), "id", "emri", kl.idDispecheri); //ViewBag.IdMagazina = new SelectList(utility.GetMagazina(), "id", "emri",kl.idMagazina); return(View(kl)); } else { return(RedirectToAction("Index", "Hyrje")); } }
protected void SaveButton_Click(object sender, EventArgs e) { if (EmriTextBox.Text.Length == 0) { lblError.Visible = true; EmriTextBox.Focus(); return; } else if (MbiemriTextBox.Text.Length == 0) { lblError.Visible = true; MbiemriTextBox.Focus(); return; } else if (NumriTelefonitTextBox.Text.Length == 0) { lblError.Visible = true; NumriTelefonitTextBox.Focus(); return; } else if (EmailTextBox.Text.Length == 0) { lblError.Visible = true; EmailTextBox.Focus(); return; } else { Klienti obj = new Klienti(); obj.Emri = EmriTextBox.Text; obj.Mbiemri = MbiemriTextBox.Text; obj.NumriTelefonit = int.Parse(NumriTelefonitTextBox.Text); obj.Email = EmailTextBox.Text; KlientiMapper objm = new KlientiMapper(obj); objm.Insert(); Response.Redirect("Index.aspx"); } }
public static List <Klienti> UpdateClient(Klienti k) { var list = new List <Klienti>(); using (SqlConnection conn = new SqlConnection(cs)) { conn.Open(); SqlCommand cmd = new SqlCommand("spNdryshoKlientin", conn); cmd.Parameters.AddWithValue("@_IdKlienti", k.IdKlienti); cmd.Parameters.AddWithValue("@_Emri", k.Emri); cmd.Parameters.AddWithValue("@_Adresa", k.Adresani); cmd.Parameters.AddWithValue("@_NrTelefeoni", k.NrTelefonit); cmd.Parameters.AddWithValue("@_IsKlient", k.IsKlient); cmd.CommandType = CommandType.StoredProcedure; int o = cmd.ExecuteNonQuery(); conn.Close(); } return(list); }
public static void Insert(Klienti klienti) { try { using (SqlConnection con = new SqlConnection(Connection.ConnectionString)) { SqlCommand cmd = new SqlCommand("sp_ShtoKlient", con); cmd.CommandType = System.Data.CommandType.StoredProcedure; con.Open(); cmd.Parameters.AddWithValue("@Emri", klienti.Emri); cmd.Parameters.AddWithValue("@Mbiemri", klienti.Mbiemri); cmd.Parameters.AddWithValue("@NrKontaktues", klienti.NrKontaktues); cmd.ExecuteNonQuery(); con.Close(); } } catch (Exception) { throw; } }
public static List <Klienti> GetAll() { List <Klienti> klientat = null; try { using (SqlConnection con = new SqlConnection(Connection.ConnectionString)) { SqlCommand cmd = new SqlCommand("sp_GetAllKlientat", con); cmd.CommandType = System.Data.CommandType.StoredProcedure; con.Open(); using (SqlDataReader sqlr = cmd.ExecuteReader()) { if (sqlr.HasRows) { klientat = new List <Klienti>(); while (sqlr.Read()) { Klienti klient = new Klienti(); klient.KlientiID = int.Parse(sqlr["KlientiID"].ToString()); klient.Emri = sqlr["Emri"].ToString(); klient.Mbiemri = sqlr["Mbiemri"].ToString(); klient.NrKontaktues = sqlr["NrKontaktues"].ToString(); klient.isActive = bool.Parse(sqlr["IsActive"].ToString()); klientat.Add(klient); } } } con.Close(); } } catch (Exception) { klientat = null; throw; } return(klientat); }
public void SelectAllKlients() { SqlConnection con = Generals.GetNewConnection(); try { SqlCommand cmd = new SqlCommand("KlientiSelectAll", con); cmd.CommandType = CommandType.StoredProcedure; SqlDataReader rdr = cmd.ExecuteReader(); while (rdr.Read()) { Klienti k = new Klienti(); k.KlientiID = (int)rdr["KlientiID"]; if (rdr["Emri"] != DBNull.Value) { k.Emri = (string)rdr["Emri"]; } if (rdr["Mbiemri"] != DBNull.Value) { k.Mbiemri = (string)rdr["Mbiemri"]; } if (rdr["NumriTelefonit"] != DBNull.Value) { k.NumriTelefonit = (int)rdr["NumriTelefonit"]; } if (rdr["Email"] != DBNull.Value) { k.Email = (string)rdr["Email"]; } mKlientet.Add(k); } } finally { con.Close(); } }
public static Klienti GetById(int id) { Klienti klient = null; try { using (SqlConnection con = new SqlConnection(Connection.ConnectionString)) { SqlCommand cmd = new SqlCommand("sp_GetKlientById", con); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@KlientId", id); con.Open(); using (SqlDataReader sqlr = cmd.ExecuteReader()) { if (sqlr.HasRows) { klient = new Klienti(); while (sqlr.Read()) { klient.KlientiID = int.Parse(sqlr["KlientiID"].ToString()); klient.Emri = sqlr["Emri"].ToString(); klient.Mbiemri = sqlr["Mbiemri"].ToString(); klient.NrKontaktues = sqlr["NrKontaktues"].ToString(); klient.isActive = bool.Parse(sqlr["IsActive"].ToString()); } } } con.Close(); } } catch (Exception) { throw; } return(klient); }
public async Task <IActionResult> Create(Pagesa pagesa) { try { if (ModelState.IsValid) { pagesa.Active = true; pagesa.DataEPageses = DateTime.Now; switch (pagesa.Shuma) { case 5: pagesa.DataESkadimit = DateTime.Now.AddMonths(1); break; case 10: pagesa.DataESkadimit = DateTime.Now.AddMonths(3); break; case 15: pagesa.DataESkadimit = DateTime.Now.AddMonths(6); break; } _context.Add(pagesa); Klienti klienti = _context.Klienti.Where(k => k.id == pagesa.Klienti_id).First(); klienti.Aktiv = true; await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } }catch (DbUpdateException ex) { //Log the error (uncomment ex variable name and write a log. ModelState.AddModelError("", "Unable to save changes. " + "Try again, and if the problem persists " + "see your system administrator."); } return(View(pagesa)); }
public async Task <IActionResult> Create( [Bind("Emri,Email,NumriTel,Aktiv")] Klienti k) { try { if (ModelState.IsValid) { k.created_at = DateTime.Now; _context.Add(k); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } } catch (DbUpdateException /* ex */) { //Log the error (uncomment ex variable name and write a log. ModelState.AddModelError("", "Unable to save changes. " + "Try again, and if the problem persists " + "see your system administrator."); } return(View(k)); }
private void btnShto_Click(object sender, EventArgs e) { string emri = txtEmri.Text; string mbiemri = txtMbiemri.Text; string nrkontaktues = txtNrkontaktues.Text; if (String.IsNullOrEmpty(emri) || String.IsNullOrEmpty(mbiemri) || String.IsNullOrEmpty(nrkontaktues)) { MessageBox.Show("Mbushini te gjitha hapsirat e kerkuara"); } else { Klienti newKlient = new Klienti() { Emri = emri, Mbiemri = mbiemri, NrKontaktues = nrkontaktues }; BussinessKlienti.InsertKlient(newKlient); MessageBox.Show("U shtua nje klient i ri"); this.Close(); } }