public static List <Artikulli> GetItemByBarkodi(int barkodi)
{
List <Artikulli> list = new List <Artikulli>();
using (SqlConnection con = new SqlConnection(DataBaseCon.Connection))
{
con.Open();
SqlCommand cmd = new SqlCommand("spKerkoArtikullin", con);
cmd.Parameters.AddWithValue("@_Barkodi", barkodi);
cmd.CommandType = CommandType.StoredProcedure;
using (IDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
Artikulli artikulli = new Artikulli();
artikulli.Barkodi = barkodi;
artikulli.IdArtikulli = Int32.Parse(reader["IdArtikulli"].ToString());
artikulli.EmriArtikullit = reader["EmriArtikullit"].ToString();
artikulli.IsAktiv = bool.Parse(reader["IsAktiv"].ToString());
artikulli.Njesia = reader["IdArtikulli"].ToString();
artikulli.Pershkrimi = reader["IdArtikulli"].ToString();
}
}
}
return(list);
}
public static List <Artikulli> GetAll()
{
List <Artikulli> list = new List <Artikulli>();
using (SqlConnection conn = new SqlConnection(cs))
{
conn.Open();
SqlCommand cmd = new SqlCommand("spShfaqTeGjithaArtikujt", conn);
cmd.CommandType = CommandType.StoredProcedure;
using (IDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
var artikulli = new Artikulli();
artikulli.Pershkrimi = reader["Pershkrimi"].ToString();
artikulli.IsAktiv = bool.Parse(reader["IsAktive"].ToString());
artikulli.IdArtikulli = int.Parse(reader["IdArtikulli"].ToString());
artikulli.EmriArtikullit = reader["EmriArtikullit"].ToString();
artikulli.Cmimi = double.Parse(reader["Cmimi"].ToString());
artikulli.Barkodi = int.Parse(reader["Barkodi"].ToString());
artikulli.Njesia = reader["Njesia"].ToString();
list.Add(artikulli);
}
}
}
return(list);
}
public static List <Artikulli> GetItemsByID(int id)
{
var list = new List <Artikulli>();
using (SqlConnection conn = new SqlConnection(cs))
{
conn.Open();
SqlCommand cmd = new SqlCommand("spKerkoArtikullin", conn);
cmd.Parameters.AddWithValue("@_Barkodi", id);
cmd.CommandType = CommandType.StoredProcedure;
using (IDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
var artikulli = new Artikulli();
artikulli.IdArtikulli = id;
artikulli.EmriArtikullit = reader["EmriArtikullit"].ToString();
artikulli.Barkodi = int.Parse(reader["Barkodi"].ToString());
artikulli.Njesia = reader["Njesia"].ToString();
artikulli.Cmimi = double.Parse(reader["Cmimi"].ToString());
artikulli.Pershkrimi = reader["Pershkrimi"].ToString();
artikulli.IsAktiv = bool.Parse(reader["IsAktive"].ToString());
list.Add(artikulli);
}
}
}
return(list);
}
public static void Insert(Artikulli a)
{
using (SqlConnection conn = new SqlConnection(cs))
{
conn.Open();
SqlCommand cmd = new SqlCommand("spShtoArtikullin", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@_EmriArtikullit", a.EmriArtikullit);
cmd.Parameters.AddWithValue("@_Barkodi", a.Barkodi);
cmd.Parameters.AddWithValue("@_Njesia", a.Njesia);
cmd.Parameters.AddWithValue("@_Pershkrimi", a.Pershkrimi);
cmd.Parameters.AddWithValue("@_IsAktvi", a.IsAktiv);
cmd.ExecuteNonQuery();
}
}
public static List <Artikulli> UpdateItem(Artikulli a)
{
var list = new List <Artikulli>();
using (SqlConnection conn = new SqlConnection(cs))
{
conn.Open();
SqlCommand cmd = new SqlCommand("spNdryshoAritkullin", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@_IdArtikulli", a.IdArtikulli);
cmd.Parameters.AddWithValue("@_EmriArtikullit", a.EmriArtikullit);
cmd.Parameters.AddWithValue("@_Barkodi", a.Barkodi);
cmd.Parameters.AddWithValue("@_Njesia", a.Njesia);
cmd.Parameters.AddWithValue("@_Pershkrimi", a.Pershkrimi);
cmd.Parameters.AddWithValue("@_IsAktvi", a.IsAktiv);
int o = cmd.ExecuteNonQuery();
cmd.ExecuteNonQuery();
}
return(list);
}
public static List <Artikulli> DeleteItemByBarcod(int barkodi)
{
var list = new List <Artikulli>();
using (SqlConnection conn = new SqlConnection(cs))
{
conn.Open();
SqlCommand cmd = new SqlCommand("spFshijArtikullin", conn);
cmd.Parameters.AddWithValue("@_IdArtikulli", barkodi);
cmd.CommandType = CommandType.StoredProcedure;
using (IDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
var artikulli = new Artikulli();
artikulli.Barkodi = barkodi;
list.Add(artikulli);
}
}
return(list);
}
}
public static List <Artikulli> UpdateItem(Artikulli artikulli)
{
return(dalItems.UpdateItem(artikulli));
}
public static void InsertNewItems(Artikulli artikulli)
{
//if (IsValid(artikulli))
dalItems.Insert(artikulli);
}
