/// <summary>
/// Update
/// </summary>
/// <param name="item"></param>
/// <returns></returns>
public int Update(Entities.KhuyenMaiSoLuong item)
{
int rt = 0;
try
{
conn = new Connection();
SqlConnection cn = conn.openConnection();
string sql = "exec sp_UpdateKMSL @Id,@MaHangHoa,@TenHangHoa,@NgayBatDau,@NgayKetThuc,@SoLuong,@GiaBanBuon,@GiaBanLe";
SqlCommand cmd = new SqlCommand(sql, cn);
cmd.Parameters.Add("Id", SqlDbType.Int).Value = item.Id;
cmd.Parameters.Add("MaHangHoa", SqlDbType.VarChar, 50).Value = item.MaHangHoa;
cmd.Parameters.Add("TenHangHoa", SqlDbType.NVarChar, 200).Value = item.TenHangHoa;
cmd.Parameters.Add("NgayBatDau", SqlDbType.DateTime).Value = item.NgayBatDau;
cmd.Parameters.Add("NgayKetThuc", SqlDbType.DateTime).Value = item.NgayKetThuc;
cmd.Parameters.Add("SoLuong", SqlDbType.Float).Value = item.SoLuong;
cmd.Parameters.Add("GiaBanBuon", SqlDbType.Float).Value = item.GiaBanBuon;
cmd.Parameters.Add("GiaBanLe", SqlDbType.Float).Value = item.GiaBanLe;
rt = cmd.ExecuteNonQuery();
}
catch
{
rt = 0;
}
return(rt);
}
public KhuyenMaiSoLuong()
{
conn = null;
cmd = null;
dr = null;
kmsl = null;
cn = null;
}
public KhuyenMaiSoLuong()
{
conn = null;
cmd = null;
dr = null;
kmsl = null;
cn = null;
}
/// <summary>
/// Delete
/// </summary>
/// <param name="item"></param>
/// <returns></returns>
public int Delete(Entities.KhuyenMaiSoLuong item)
{
int rt = 0;
try
{
conn = new Connection();
SqlConnection cn = conn.openConnection();
string sql = "exec sp_DeleteKMSL @MaHangHoa";
SqlCommand cmd = new SqlCommand(sql, cn);
cmd.Parameters.Add("MaHangHoa", SqlDbType.VarChar, 50).Value = item.MaHangHoa;
rt = cmd.ExecuteNonQuery();
}
catch
{
rt = 0;
}
return(rt);
}
/// <summary>
/// Select
/// </summary>
/// <returns></returns>
public Entities.KhuyenMaiSoLuong[] Select(Entities.KhuyenMaiSoLuong item)
{
Entities.KhuyenMaiSoLuong[] list = null;
try
{
string sql = "exec sp_SelectKMSLTheoMa @MaHangHoa";
conn = new Connection();
cn = conn.openConnection();
cmd = new SqlCommand(sql, cn);
cmd.Parameters.Add("MaHangHoa", SqlDbType.VarChar, 50).Value = item.MaHangHoa;
dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
List <Entities.KhuyenMaiSoLuong> arr = new List <Entities.KhuyenMaiSoLuong>();
while (dr.Read())
{
Entities.KhuyenMaiSoLuong row = new Entities.KhuyenMaiSoLuong();
row.Id = Convert.ToInt32(dr["Id"].ToString());
row.MaHangHoa = dr["MaHangHoa"].ToString();
row.TenHangHoa = dr["TenHangHoa"].ToString();
row.SoLuong = double.Parse(dr["SoLuong"].ToString());
row.NgayBatDau = DateTime.Parse(dr["NgayBatDau"].ToString());
row.NgayKetThuc = DateTime.Parse(dr["NgayKetThuc"].ToString());
row.GiaBanBuon = double.Parse(dr["GiaBanBuon"].ToString());
row.GiaBanLe = double.Parse(dr["GiaBanLe"].ToString());
arr.Add(row);
}
list = arr.ToArray();
}
catch
{
list = null;
}
finally
{
cmd.Connection.Dispose();
cn.Close();
conn.closeConnection();
}
return(list);
}
/// <summary>
/// Select
/// </summary>
/// <returns></returns>
public Entities.KhuyenMaiSoLuong[] Select()
{
Entities.KhuyenMaiSoLuong[] list = null;
try
{
string sql = "exec sp_SelectKMSL";
conn = new Connection();
cn = conn.openConnection();
cmd = new SqlCommand(sql, cn);
dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
List<Entities.KhuyenMaiSoLuong> arr = new List<Entities.KhuyenMaiSoLuong>();
while (dr.Read())
{
Entities.KhuyenMaiSoLuong row = new Entities.KhuyenMaiSoLuong();
row.Id = Convert.ToInt32(dr["Id"].ToString());
row.MaHangHoa = dr["MaHangHoa"].ToString();
row.TenHangHoa = dr["TenHangHoa"].ToString();
row.SoLuong = double.Parse(dr["SoLuong"].ToString());
row.NgayBatDau = DateTime.Parse(dr["NgayBatDau"].ToString());
row.NgayKetThuc = DateTime.Parse(dr["NgayKetThuc"].ToString());
row.GiaBanBuon = double.Parse(dr["GiaBanBuon"].ToString());
row.GiaBanLe = double.Parse(dr["GiaBanLe"].ToString());
arr.Add(row);
}
list = arr.ToArray();
}
catch
{
list = null;
}
finally
{
cmd.Connection.Dispose();
cn.Close();
conn.closeConnection();
}
return list;
}
