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