public List <ChiNhanh> SelectFruitChiNhanhByKeywordAndIdCH(string keyword, int IdCH)
{
List <ChiNhanh> cn = new List <ChiNhanh>();
SqlConnection con = new SqlConnection(strCon);
con.Open();
string strCmd = "SELECT a.* FROM ChiNhanh a, CuaHangTraiCay b WHERE TenChuChiNhanh LIKE '%" + keyword + "%' and a.IdCuaHang=b.Id and b.Id=@Id";
SqlCommand cmd = new SqlCommand(strCmd, con);
cmd.Parameters.Add(new SqlParameter("@Id", IdCH));
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
ChiNhanh c = new ChiNhanh();
c.DiaChiChiNhanh = (string)dr["DiaChiChiNhanh"];
c.Id = (int)dr["Id"];
c.IdCuaHang = (int)dr["IdCuaHang"];
c.IdLoai = (int)dr["IdLoai"];
c.Image = (string)dr["Image"];
c.Phuong = (string)dr["Phuong"];
c.Quan = (string)dr["Quan"];
c.SoDienThoaiChiNhanh = (int)dr["SoDienThoaiChiNhanh"];
c.TenChuChiNhanh = (string)dr["TenChuChiNhanh"];
c.ThanhPho = (string)dr["ThanhPho"];
cn.Add(c);
}
con.Close();
return(cn);
}
public List <ChiNhanh> SelectAllChiNhanhByIdCH(int IdCH)
{
List <ChiNhanh> cn = new List <ChiNhanh>();
SqlConnection con = new SqlConnection(strCon);
con.Open();
string strCmd = "select b.* from cuahangtraicay a, chinhanh b where a.Id=@Id and a.Id = b.IdCuaHang";
SqlCommand cmd = new SqlCommand(strCmd, con);
cmd.Parameters.Add(new SqlParameter("@Id", IdCH));
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
ChiNhanh c = new ChiNhanh();
c.DiaChiChiNhanh = (string)dr["DiaChiChiNhanh"];
c.Id = (int)dr["Id"];
c.IdCuaHang = (int)dr["IdCuaHang"];
c.IdLoai = (int)dr["IdLoai"];
c.Image = (string)dr["Image"];
c.Phuong = (string)dr["Phuong"];
c.Quan = (string)dr["Quan"];
c.SoDienThoaiChiNhanh = (int)dr["SoDienThoaiChiNhanh"];
c.TenChuChiNhanh = (string)dr["TenChuChiNhanh"];
c.ThanhPho = (string)dr["ThanhPho"];
cn.Add(c);
}
con.Close();
return(cn);
}
public List <ChiNhanh> SelectAllFruitChiNhanh()
{
List <ChiNhanh> cn = new List <ChiNhanh>();
SqlConnection con = new SqlConnection(strCon);
con.Open();
string strCmd = "SELECT * FROM ChiNhanh";
SqlCommand cmd = new SqlCommand(strCmd, con);
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
ChiNhanh c = new ChiNhanh();
c.DiaChiChiNhanh = (string)dr["DiaChiChiNhanh"];
c.Id = (int)dr["Id"];
c.IdCuaHang = (int)dr["IdCuaHang"];
c.IdLoai = (int)dr["IdLoai"];
c.Image = (string)dr["Image"];
c.Phuong = (string)dr["Phuong"];
c.Quan = (string)dr["Quan"];
c.SoDienThoaiChiNhanh = (int)dr["SoDienThoaiChiNhanh"];
c.TenChuChiNhanh = (string)dr["TenChuChiNhanh"];
c.ThanhPho = (string)dr["ThanhPho"];
cn.Add(c);
}
con.Close();
return(cn);
}
public bool AddChiNhanh(ChiNhanh newCn)
{
SqlConnection con = new SqlConnection(strCon);
con.Open();
string strCmd = "INSERT INTO ChiNhanh VALUES (@IdLoai,@TenChuChiNhanh,@SoDienThoaiChiNhanh,@DiaChiChiNhanh,@Phuong,@Quan,@ThanhPho,@IdCuaHang,@Image)";
SqlCommand cmd = new SqlCommand(strCmd, con);
cmd.Parameters.Add(new SqlParameter("@IdLoai", newCn.IdLoai));
cmd.Parameters.Add(new SqlParameter("@Image", newCn.Image));
cmd.Parameters.Add(new SqlParameter("@TenChuChiNhanh", newCn.TenChuChiNhanh));
cmd.Parameters.Add(new SqlParameter("@SoDienThoaiChiNhanh", newCn.SoDienThoaiChiNhanh));
cmd.Parameters.Add(new SqlParameter("@DiaChiChiNhanh", newCn.DiaChiChiNhanh));
cmd.Parameters.Add(new SqlParameter("@Phuong", newCn.Phuong));
cmd.Parameters.Add(new SqlParameter("@Quan", newCn.Quan));
cmd.Parameters.Add(new SqlParameter("@ThanhPho", newCn.ThanhPho));
cmd.Parameters.Add(new SqlParameter("@IdCuaHang", newCn.IdCuaHang));
return(cmd.ExecuteNonQuery() > 0);
}
public bool UpdateChiNhanh(ChiNhanh newCn, int IdCH)
{
SqlConnection con = new SqlConnection(strCon);
con.Open();
string strCmd = "UPDATE a SET a.IdLoai=@IdLoai, a.Image=@Image, a.TenChuChiNhanh=@TenChuChiNhanh, a.SoDienThoaiChiNhanh=@SoDienThoaiChiNhanh,a.DiaChiChiNhanh=@DiaChiChiNhanh,a.Phuong=@Phuong, a.Quan=@Quan, a.ThanhPho=@ThanhPho, a.IdCuaHang=@IdCuaHang from ChiNhanh a, Cuahangtraicay b WHERE a.Id=@Id and a.IdCuaHang=b.Id and b.Id=@IdCH";
SqlCommand cmd = new SqlCommand(strCmd, con);
cmd.Parameters.Add(new SqlParameter("@Id", newCn.Id));
cmd.Parameters.Add(new SqlParameter("@IdCH", IdCH));
cmd.Parameters.Add(new SqlParameter("@IdLoai", newCn.IdLoai));
cmd.Parameters.Add(new SqlParameter("@Image", newCn.Image));
cmd.Parameters.Add(new SqlParameter("@TenChuChiNhanh", newCn.TenChuChiNhanh));
cmd.Parameters.Add(new SqlParameter("@SoDienThoaiChiNhanh", newCn.SoDienThoaiChiNhanh));
cmd.Parameters.Add(new SqlParameter("@DiaChiChiNhanh", newCn.DiaChiChiNhanh));
cmd.Parameters.Add(new SqlParameter("@Phuong", newCn.Phuong));
cmd.Parameters.Add(new SqlParameter("@Quan", newCn.Quan));
cmd.Parameters.Add(new SqlParameter("@ThanhPho", newCn.ThanhPho));
cmd.Parameters.Add(new SqlParameter("@IdCuaHang", newCn.IdCuaHang));
return(cmd.ExecuteNonQuery() > 0);
}
