public async Task <IActionResult> Edit(int id, [Bind("VendoriId,Emri,Lokacioni,NrKontaktues,BankAccount")] Vendori vendori)
{
if (id != vendori.VendoriId)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(vendori);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!VendoriExists(vendori.VendoriId))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
return(View(vendori));
}
private void DeleteForm(int ID, string page)
{
if (page == "/Views/Klientet/Index.aspx")
{
Vendori obj = new Vendori();
obj.VendoriID = ID;
VendoriMapper objm = new VendoriMapper(obj);
objm.Delete();
}
}
public async Task <IActionResult> Create([Bind("VendoriId,Emri,Lokacioni,NrKontaktues,BankAccount")] Vendori vendori)
{
if (ModelState.IsValid)
{
_context.Add(vendori);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(vendori));
}
private void placeShenimet()
{
Index form = (Index)Context.Handler;
int ID = form.SelectedID;
ViewState["SelectedID"] = ID;
Vendori ex = new Vendori();
VendoriMapper em = new VendoriMapper(ex);
em.SelectedID(ID);
}
protected void SaveButton_Click(object sender, EventArgs e)
{
if (EmriTextBox.Text.Length == 0)
{
lblError.Visible = true;
EmriTextBox.Focus();
return;
}
else if (LokacioniTextBox.Text.Length == 0)
{
lblError.Visible = true;
LokacioniTextBox.Focus();
return;
}
else if (NrKontaktuesTextBox.Text.Length == 0)
{
lblError.Visible = true;
NrKontaktuesTextBox.Focus();
return;
}
else if (BankAccountTextBox.Text.Length == 0)
{
lblError.Visible = true;
BankAccountTextBox.Focus();
return;
}
else
{
int ID = Convert.ToInt32(ViewState["SelectedID"].ToString());
Vendori obj = new Vendori();
VendoriMapper objm = new VendoriMapper(obj);
objm.SelectedID(ID);
obj.Emri = EmriTextBox.Text;
obj.Lokacioni = LokacioniTextBox.Text;
obj.NrKontaktues = int.Parse(NrKontaktuesTextBox.Text);
obj.BankAccount = int.Parse(BankAccountTextBox.Text);
objm.Update();
Response.Redirect("Index.aspx");
}
}
protected void SaveButton_Click(object sender, EventArgs e)
{
if (EmriTextBox.Text.Length == 0)
{
lblError.Visible = true;
EmriTextBox.Focus();
return;
}
else if (LokacioniTextBox.Text.Length == 0)
{
lblError.Visible = true;
LokacioniTextBox.Focus();
return;
}
else if (NrKontaktuesTextBox.Text.Length == 0)
{
lblError.Visible = true;
NrKontaktuesTextBox.Focus();
return;
}
else if (BankAccountTextBox.Text.Length == 0)
{
lblError.Visible = true;
BankAccountTextBox.Focus();
return;
}
else
{
Vendori obj = new Vendori();
obj.Emri = EmriTextBox.Text;
obj.Lokacioni = LokacioniTextBox.Text;
obj.NrKontaktues = int.Parse(NrKontaktuesTextBox.Text);
obj.BankAccount = int.Parse(BankAccountTextBox.Text);
VendoriMapper objm = new VendoriMapper(obj);
objm.Insert();
Response.Redirect("Index.aspx");
}
}
public void SelectAllVendori()
{
SqlConnection con = Generals.GetNewConnection();
try
{
SqlCommand cmd = new SqlCommand("VendoriSelectAll", con);
cmd.CommandType = CommandType.StoredProcedure;
SqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
Vendori v = new Vendori();
v.VendoriID = (int)rdr["VendoriID"];
if (rdr["Emri"] != DBNull.Value)
{
v.Emri = (string)rdr["Emri"];
}
if (rdr["Lokacioni"] != DBNull.Value)
{
v.Lokacioni = (string)rdr["Lokacioni"];
}
if (rdr["NrKontaktues"] != DBNull.Value)
{
v.NrKontaktues = (int)rdr["NrKontaktues"];
}
if (rdr["BankAccount"] != DBNull.Value)
{
v.BankAccount = (int)rdr["BankAccount"];
}
mVendoret.Add(v);
}
}
finally
{
con.Close();
}
}
public VendoriMapper(Vendori v)
{
mVendori = v;
}
