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