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