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