public void SelectedID(int GrupiID)
{
SqlConnection con = Generals.GetNewConnection();
try
{
SqlCommand cmd = new SqlCommand("GrupiSelectRow", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@GrupiID", GrupiID);
SqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
mGrupi.GrupiID = (int)rdr["GrupiID"];
if (rdr["Grupi"] != DBNull.Value)
{
mGrupi.emriGrupit = (string)rdr["Grupi"];
}
if (rdr["KategoriaID"] != DBNull.Value)
{
mGrupi.KategoriaID = (int)rdr["KategoriaID"];
}
}
}
finally
{
con.Close();
}
}
public void SelectedID(int ObjektiID)
{
SqlConnection con = Generals.GetNewConnection();
try
{
SqlCommand cmd = new SqlCommand("ObjektiSelectRow", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@ObjektiID", ObjektiID);
SqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
mObjekti.ObjektiID = (int)rdr["ObjektiID"];
if (rdr["Lokacioni"] != DBNull.Value)
{
mObjekti.Lokacioni = (string)rdr["Lokacioni"];
}
}
}
finally
{
con.Close();
}
}
public void SelectAllObjektet()
{
SqlConnection con = Generals.GetNewConnection();
try
{
SqlCommand cmd = new SqlCommand("ObjektiSelectAll", con);
cmd.CommandType = CommandType.StoredProcedure;
SqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
Objekti o = new Objekti();
o.ObjektiID = (int)rdr["ObjektiID"];
if (rdr["Lokacioni"] != DBNull.Value)
{
o.Lokacioni = (string)rdr["Lokacioni"];
}
mObjektet.Add(o);
}
}
finally
{
con.Close();
}
}
public void SelectedID(int KategoriaID)
{
SqlConnection con = Generals.GetNewConnection();
try
{
SqlCommand cmd = new SqlCommand("KategoriaSelectRow", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@KategoriaID", KategoriaID);
SqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
mKategoria.KategoriaID = (int)rdr["KategoriaID"];
if (rdr["VleraKategoris"] != DBNull.Value)
{
mKategoria.Vlera = (int)rdr["VleraKategoris"];
}
}
}
finally
{
con.Close();
}
}
public void SelectAllGrupet()
{
SqlConnection con = Generals.GetNewConnection();
try
{
SqlCommand cmd = new SqlCommand("GrupiSelectAll", con);
cmd.CommandType = CommandType.StoredProcedure;
SqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
Grupi g = new Grupi();
g.GrupiID = (int)rdr["GrupiID"];
if (rdr["Grupi"] != DBNull.Value)
{
g.emriGrupit = (string)rdr["Grupi"];
}
if (rdr["KategoriaID"] != DBNull.Value)
{
g.KategoriaID = (int)rdr["KategoriaID"];
}
mGrupet.Add(g);
}
}
finally
{
con.Close();
}
}
public void Update()
{
SqlConnection con = Generals.GetNewConnection();
try
{
SqlCommand cmd = new SqlCommand("ProduktiUpdateRow", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Emri", mProdukti.Emri);
cmd.Parameters.AddWithValue("@Pershkrimi", mProdukti.Pershkrimi);
cmd.Parameters.AddWithValue("@Prodhuesi", mProdukti.Prodhuesi);
cmd.Parameters.AddWithValue("@Modeli", mProdukti.Modeli);
cmd.Parameters.AddWithValue("@Jetegjatesia", mProdukti.Jetegjatesia);
cmd.Parameters.AddWithValue("@Lloji", mProdukti.Lloji);
cmd.Parameters.AddWithValue("@GrupiID", mProdukti.GrupiID);
cmd.Parameters.AddWithValue("@Statusi", mProdukti.Statusi);
cmd.Parameters.AddWithValue("@NrSerik", mProdukti.NrSerik);
cmd.Parameters.AddWithValue("@salvageValue", mProdukti.salvageValue);
cmd.Parameters.AddWithValue("@Cmimi", mProdukti.Cmimi);
cmd.Parameters.AddWithValue("@Data1", mProdukti.Data1);
cmd.ExecuteNonQuery();
}
finally
{
con.Close();
}
}
public void Insert()
{
SqlConnection con = Generals.GetNewConnection();
try
{
SqlCommand cmd = new SqlCommand("KategoriaInsertRow", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@VleraKategorise", mKategoria.Vlera);
}
finally
{
con.Close();
}
}
public void Delete()
{
SqlConnection con = Generals.GetNewConnection();
try
{
SqlCommand cmd = new SqlCommand("KategoriaDeleteRow", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@KategoriaID", mKategoria.KategoriaID);
cmd.ExecuteNonQuery();
}
finally
{
con.Close();
}
}
public void Insert()
{
SqlConnection con = Generals.GetNewConnection();
try
{
SqlCommand cmd = new SqlCommand("ObjektiInsertRow", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Lokacioni", mObjekti.Lokacioni);
cmd.ExecuteNonQuery();
}
finally
{
con.Close();
}
}
public void Insert()
{
SqlConnection con = Generals.GetNewConnection();
try
{
SqlCommand cmd = new SqlCommand("GrupiInsertRow", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Grupi", mGrupi.emriGrupit);
cmd.Parameters.AddWithValue("@KategoriaID", mGrupi.KategoriaID);
cmd.ExecuteNonQuery();
}
finally
{
con.Close();
}
}
public void Login()
{
SqlConnection con = Generals.GetNewConnection();
try
{
SqlCommand cmd = new SqlCommand("UserLogin", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@username", mLogin.username);
cmd.Parameters.AddWithValue("@password", mLogin.password);
cmd.ExecuteNonQuery();
}
finally
{
con.Close();
}
}
public void Insert()
{
SqlConnection con = Generals.GetNewConnection();
try
{
SqlCommand cmd = new SqlCommand("KlientiInsertRow", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Emri", mKlienti.Emri);
cmd.Parameters.AddWithValue("@Mbiemri", mKlienti.Mbiemri);
cmd.Parameters.AddWithValue("@NumriTelefonit", mKlienti.NumriTelefonit);
cmd.Parameters.AddWithValue("@Email", mKlienti.Email);
cmd.ExecuteNonQuery();
}
finally
{
con.Close();
}
}
//public void Delete()
//{
// SqlConnection con = Generals.GetNewConnection();
// try
// {
// SqlCommand cmd = new SqlCommand("MirembajtjaDeleteRow", con);
// cmd.CommandType = CommandType.StoredProcedure;
// cmd.Parameters.AddWithValue("@MirembajtjaID", mMirembajtja.MirembajtjaID);
// cmd.ExecuteNonQuery();
// }
// finally
// {
// con.Close();
// }
//}
public void Insert()
{
SqlConnection con = Generals.GetNewConnection();
try
{
SqlCommand cmd = new SqlCommand("MirembajtjaInsertRow", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@ProduktiID", mMirembajtja.ProduktiID);
cmd.Parameters.AddWithValue("@DataMirembajtjes", mMirembajtja.DataMirembajtjes);
cmd.Parameters.AddWithValue("@Pershkrimi", mMirembajtja.Pershkrimi);
cmd.Parameters.AddWithValue("@PunetoriID", mMirembajtja.PunetoriID);
cmd.ExecuteNonQuery();
}
finally
{
con.Close();
}
}
public void Update() // Perditsim i te dhenave
{
SqlConnection con = Generals.GetNewConnection();
try
{
SqlCommand cmd = new SqlCommand("PunetoriUpdateRow", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@PunetoriID", mPunetori.PunetoriID);
cmd.Parameters.AddWithValue("@Emri", mPunetori.Emri);
cmd.Parameters.AddWithValue("@Mbiemri", mPunetori.Mbiemri);
cmd.Parameters.AddWithValue("@Gjinia", mPunetori.Gjinia);
cmd.Parameters.AddWithValue("@RoliId", mPunetori.RoliID);
cmd.ExecuteNonQuery();
}
finally
{
con.Close();
}
}
public void Update() // Perditsim i te dhenave
{
SqlConnection con = Generals.GetNewConnection();
try
{
SqlCommand cmd = new SqlCommand("VendoriUpdateRow", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@VendoriID", mVendori.VendoriID);
cmd.Parameters.AddWithValue("@Emri", mVendori.Emri);
cmd.Parameters.AddWithValue("@Lokacioni", mVendori.Lokacioni);
cmd.Parameters.AddWithValue("@NrKontaktues", mVendori.NrKontaktues);
cmd.Parameters.AddWithValue("@BankAccount", mVendori.BankAccount);
cmd.ExecuteNonQuery();
}
finally
{
con.Close();
}
}
public void SelectAllPunetoret()
{
SqlConnection con = Generals.GetNewConnection();
try
{
SqlCommand cmd = new SqlCommand("PunetoriSelectAll", con);
cmd.CommandType = CommandType.StoredProcedure;
SqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
Punetori p = new Punetori();
p.PunetoriID = (int)rdr["PunetoriID"];
if (rdr["Emri"] != DBNull.Value)
{
p.Emri = (string)rdr["Emri"];
}
if (rdr["Mbiemri"] != DBNull.Value)
{
p.Mbiemri = (string)rdr["Mbiemri"];
}
if (rdr["Gjinia"] != DBNull.Value)
{
p.Gjinia = (string)rdr["Gjinia"];
}
if (rdr["RoliID"] != DBNull.Value)
{
p.RoliID = (int)rdr["RoliID"];
}
mPunetoret.Add(p);
}
}
finally
{
con.Close();
}
}
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 void SelectedID(int VendoriID) // Opsion i select id
{
SqlConnection con = Generals.GetNewConnection();
try
{
SqlCommand cmd = new SqlCommand("VendoriSelectRow", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@VendoriID", VendoriID);
SqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
mVendori.VendoriID = (int)rdr["VendoriID"];
if (rdr["Emri"] != DBNull.Value)
{
mVendori.Emri = (string)rdr["Emri"];
}
if (rdr["Lokacioni"] != DBNull.Value)
{
mVendori.Lokacioni = (string)rdr["Lokacioni"];
}
if (rdr["NrKontaktues"] != DBNull.Value)
{
mVendori.NrKontaktues = (int)rdr["NrKontaktues"];
}
if (rdr["BankAccount"] != DBNull.Value)
{
mVendori.BankAccount = (int)rdr["BankAccount"];
}
}
}
finally
{
con.Close();
}
}
public void SelectedID(int PunetoriID) // Opsion i select id
{
SqlConnection con = Generals.GetNewConnection();
try
{
SqlCommand cmd = new SqlCommand("PunetoriSelectRow", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@PunetoriID", PunetoriID);
SqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
mPunetori.PunetoriID = (int)rdr["PunetoriID"];
if (rdr["Emri"] != DBNull.Value)
{
mPunetori.Emri = (string)rdr["Emri"];
}
if (rdr["Mbiemri"] != DBNull.Value)
{
mPunetori.Mbiemri = (string)rdr["Mbiemri"];
}
if (rdr["Gjinia"] != DBNull.Value)
{
mPunetori.Gjinia = (string)rdr["Gjinia"];
}
if (rdr["RoliID"] != DBNull.Value)
{
mPunetori.RoliID = (int)rdr["RoliID"];
}
}
}
finally
{
con.Close();
}
}
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 void SelectedID(int KlientiID)
{
SqlConnection con = Generals.GetNewConnection();
try
{
SqlCommand cmd = new SqlCommand("KlientiSelectRow", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@KlientiID", KlientiID);
SqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
mKlienti.KlientiID = (int)rdr["KlientiID"];
if (rdr["Emri"] != DBNull.Value)
{
mKlienti.Emri = (string)rdr["Emri"];
}
if (rdr["Mbiemri"] != DBNull.Value)
{
mKlienti.Mbiemri = (string)rdr["Mbiemri"];
}
if (rdr["NumriTelefonit"] != DBNull.Value)
{
mKlienti.NumriTelefonit = (int)rdr["NumriTelefonit"];
}
if (rdr["Email"] != DBNull.Value)
{
mKlienti.Email = (string)rdr["Email"];
}
}
}
finally
{
con.Close();
}
}
public void SelectAllKategorit()
{
SqlConnection con = Generals.GetNewConnection();
try
{
SqlCommand cmd = new SqlCommand("KategoriaSelectAll", con);
cmd.CommandType = CommandType.StoredProcedure;
SqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
Kategoria k = new Kategoria();
k.KategoriaID = (int)rdr["KategoriaID"];
if (rdr["vleraKategorise"] != DBNull.Value)
{
k.Vlera = (int)rdr["vleraKategorise"];
}
}
}
finally
{
con.Close();
}
}
public void SelectedID(int ProduktiID)
{
SqlConnection con = Generals.GetNewConnection();
try
{
SqlCommand cmd = new SqlCommand("ProduktiSelectRow", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@ProduktiID", ProduktiID);
SqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
mProdukti.ProduktiID = (int)rdr["ProduktiID"];
if (rdr["Emri"] != DBNull.Value)
{
mProdukti.Emri = (string)rdr["Emri"];
}
if (rdr["Pershkrimi"] != DBNull.Value)
{
mProdukti.Pershkrimi = (string)rdr["Pershkrimi"];
}
if (rdr["Prodhuesi"] != DBNull.Value)
{
mProdukti.Prodhuesi = (string)rdr["Prodhuesi"];
}
if (rdr["Modeli"] != DBNull.Value)
{
mProdukti.Modeli = (string)rdr["Modeli"];
}
if (rdr["Jetegjatesia"] != DBNull.Value)
{
mProdukti.Jetegjatesia = (int)rdr["Jetegjatesia"];
}
if (rdr["Lloji"] != DBNull.Value)
{
mProdukti.Lloji = (string)rdr["Lloji"];
}
if (rdr["GrupiID"] != DBNull.Value)
{
mProdukti.GrupiID = (int)rdr["GrupiID"];
}
if (rdr["Statusi"] != DBNull.Value)
{
mProdukti.Statusi = (bool)rdr["Statusi"];
}
if (rdr["NrSerik"] != DBNull.Value)
{
mProdukti.NrSerik = (string)rdr["NrSerik"];
}
if (rdr["salvageValue"] != DBNull.Value)
{
mProdukti.salvageValue = (decimal)rdr["salvageValue"];
}
if (rdr["Cmimi"] != DBNull.Value)
{
mProdukti.Cmimi = (decimal)rdr["Cmimi"];
}
if (rdr["Data1"] != DBNull.Value)
{
mProdukti.Data1 = (DateTime)rdr["Data1"];
}
}
}
finally
{
con.Close();
}
}
public void SelectAllProduktet()
{
SqlConnection con = Generals.GetNewConnection();
try
{
SqlCommand cmd = new SqlCommand("ProduktiSelectAll", con);
cmd.CommandType = CommandType.StoredProcedure;
SqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
Produkti p = new Produkti();
p.ProduktiID = (int)rdr["ProduktiID"];
if (rdr["Emri"] != DBNull.Value)
{
p.Emri = (string)rdr["Emri"];
}
if (rdr["Pershkrimi"] != DBNull.Value)
{
p.Pershkrimi = (string)rdr["Pershkrimi"];
}
if (rdr["Prodhuesi"] != DBNull.Value)
{
p.Prodhuesi = (string)rdr["Prodhuesi"];
}
if (rdr["Modeli"] != DBNull.Value)
{
p.Modeli = (string)rdr["Modeli"];
}
if (rdr["Jetegjatesia"] != DBNull.Value)
{
p.Jetegjatesia = (int)rdr["Jetegjatesia"];
}
if (rdr["Lloji"] != DBNull.Value)
{
p.Lloji = (string)rdr["Lloji"];
}
if (rdr["GrupiID"] != DBNull.Value)
{
p.GrupiID = (int)rdr["GrupiID"];
}
if (rdr["Statusi"] != DBNull.Value)
{
p.Statusi = (bool)rdr["Statusi"];
}
if (rdr["NrSerik"] != DBNull.Value)
{
p.NrSerik = (string)rdr["NrSerik"];
}
if (rdr["salvageValue"] != DBNull.Value)
{
p.salvageValue = (decimal)rdr["salvageValue"];
}
if (rdr["Cmimi"] != DBNull.Value)
{
p.Cmimi = (decimal)rdr["Cmimi"];
}
if (rdr["Data1"] != DBNull.Value)
{
p.Data1 = (DateTime)rdr["Data1"];
}
mProduktet.Add(p);
}
}
finally
{
con.Close();
}
}