public static List <LlojiVetures> GetLlojiVeturesByVeturaID(int id) { List <LlojiVetures> llojiVetures = new List <LlojiVetures>(); using (SqlConnection con = new SqlConnection(ConnectionWithDB.GetConnection())) { SqlCommand cmd = new SqlCommand("usp_GetAllVeturasByVeturaID", con); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@VeturaID", id); con.Open(); SqlDataReader sqlDataReader = cmd.ExecuteReader(); while (sqlDataReader.Read()) { LlojiVetures lloji = new LlojiVetures(); lloji.LlojiID = int.Parse(sqlDataReader["LlojiID"].ToString()); lloji.Emri = sqlDataReader["Emrilloji"].ToString(); lloji.Foto = sqlDataReader["Foto"].ToString(); lloji.IsActive = bool.Parse(sqlDataReader["IsActive"].ToString()); Vetura st = new Vetura(); st.VeturaID = int.Parse(sqlDataReader["VeturaID"].ToString()); st.Emri = sqlDataReader["EmriVetura"].ToString(); lloji.Vetura = st; llojiVetures.Add(lloji); } } return(llojiVetures); }
public static Brendi GetBrendByID(int id) { Brendi brendi = new Brendi(); using (SqlConnection con = new SqlConnection(ConnectionWithDB.GetConnection())) { SqlCommand cmd = new SqlCommand("usp_GetBrandByID", con); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@BrandID", id); con.Open(); SqlDataReader sqlDataReader = cmd.ExecuteReader(); while (sqlDataReader.Read()) { brendi.BrendiID = int.Parse(sqlDataReader["BrendiID"].ToString()); brendi.Emri = sqlDataReader["Emri"].ToString(); brendi.Foto = sqlDataReader["Foto"].ToString(); brendi.IsActive = bool.Parse(sqlDataReader["IsActive"].ToString()); } } return(brendi); }
public static List <Brendi> GetAllBrendet() { List <Brendi> brendet = new List <Brendi>(); using (SqlConnection con = new SqlConnection(ConnectionWithDB.GetConnection())) { SqlCommand cmd = new SqlCommand("usp_GetAllBrands", con); con.Open(); SqlDataReader sqlDataReader = cmd.ExecuteReader(); while (sqlDataReader.Read()) { Brendi st = new Brendi(); st.BrendiID = int.Parse(sqlDataReader["BrendiID"].ToString()); st.Emri = sqlDataReader["Emri"].ToString(); st.Foto = sqlDataReader["Foto"].ToString(); st.IsActive = bool.Parse(sqlDataReader["IsActive"].ToString()); brendet.Add(st); } } return(brendet); }
public static void AddBrand(Brendi brendi) { using (SqlConnection con = new SqlConnection(ConnectionWithDB.GetConnection())) { SqlCommand cmd = new SqlCommand("usp_AddBrand", con); cmd.CommandType = System.Data.CommandType.StoredProcedure; con.Open(); cmd.Parameters.AddWithValue("@Emri", brendi.Emri); cmd.Parameters.AddWithValue("@Foto", brendi.Foto); cmd.ExecuteNonQuery(); } }
public static void AddVetura(VeturaCreate vetura) { using (SqlConnection con = new SqlConnection(ConnectionWithDB.GetConnection())) { SqlCommand cmd = new SqlCommand("usp_AddVetura", con); cmd.CommandType = System.Data.CommandType.StoredProcedure; con.Open(); cmd.Parameters.AddWithValue("@BrendiID", vetura.BrendiID); cmd.Parameters.AddWithValue("@Emri", vetura.Emri); cmd.ExecuteNonQuery(); } }
public static List <VM_VeturaWithLlojet> GetAllVeturasByBrandID(int id) { List <VM_VeturaWithLlojet> veturat = new List <VM_VeturaWithLlojet>(); using (SqlConnection con = new SqlConnection(ConnectionWithDB.GetConnection())) { SqlCommand cmd = new SqlCommand("usp_GetAllVeturaByBrandID", con); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@BrendiID", id); con.Open(); SqlDataReader sqlDataReader = cmd.ExecuteReader(); while (sqlDataReader.Read()) { VM_VeturaWithLlojet vm = new VM_VeturaWithLlojet(); Vetura st = new Vetura(); st.VeturaID = int.Parse(sqlDataReader["VeturaID"].ToString()); st.Emri = sqlDataReader["Emrivetura"].ToString(); st.IsActive = bool.Parse(sqlDataReader["IsActive"].ToString()); Brendi b = new Brendi(); b.BrendiID = int.Parse(sqlDataReader["BrendiID"].ToString()); b.Emri = sqlDataReader["Emribrendi"].ToString(); st.Brendi = b; List <LlojiVetures> list = new List <LlojiVetures>(); list = DAL_LLojetVetures.GetLlojiVeturesByVeturaID(st.VeturaID); vm.Vetura = st; vm.llojetlist = list; veturat.Add(vm); } } return(veturat); }