public int AddProduct(DtoProduct data)
{
SqlParameter[] para =
{
new SqlParameter("@MaSanPham", data.MaSanPham),
new SqlParameter("@TenSanPham", data.TenSanPham),
new SqlParameter("@LoaiSanPham", data.LoaiSanPham),
new SqlParameter("@ThoiGianBaoHanh", data.ThoiGianBaoHanh),
new SqlParameter("@DonGiaNhap", data.DonGiaNhap),
new SqlParameter("@DonGiaBan", data.DonGiaBan),
new SqlParameter("@SoLuong", data.SoLuong),
new SqlParameter("@DonViTinh", data.DonViTinh),
new SqlParameter("@GhiChu", data.GhiChu)
};
try
{
return SqlHelper.ExecuteNonQuery(Constants.ConnectionString, CommandType.StoredProcedure, "AddProduct",
para);
}
catch (SqlException sqlEx)
{
throw new ArgumentException(Constants.MsgExceptionSql);
}
catch (Exception ex)
{
throw ex;
}
}
public DtoProduct GetProductByID(string id)
{
try
{
DataTable dt = SqlHelper.ExecuteDataset(Constants.ConnectionString, CommandType.Text,
"select * from SANPHAM where MaSanPham = @MaSanPham", new SqlParameter("@MaSanPham", id)).Tables[0];
DtoProduct dto = new DtoProduct(
dt.Rows[0].ItemArray[0].ToString(),
dt.Rows[0].ItemArray[1].ToString(),
dt.Rows[0].ItemArray[2].ToString(),
int.Parse(dt.Rows[0].ItemArray[3].ToString()),
double.Parse(dt.Rows[0].ItemArray[4].ToString()),
double.Parse(dt.Rows[0].ItemArray[5].ToString()),
int.Parse(dt.Rows[0].ItemArray[6].ToString()),
dt.Rows[0].ItemArray[7].ToString(),
dt.Rows[0].ItemArray[8].ToString()
);
return dto;
}
catch (SqlException sqlEx)
{
throw new Exception("Lỗi kết nối cơ sở dữ liệu!");
}
catch (Exception ex)
{
throw ex;
}
}
public int AddProduct(DtoProduct data)
{
SqlParameter[] para =
{
new SqlParameter("@MaSanPham", data.MaSanPham),
new SqlParameter("@TenSanPham", data.TenSanPham),
new SqlParameter("@LoaiSanPham", data.LoaiSanPham),
new SqlParameter("@ThoiGianBaoHanh", data.ThoiGianBaoHanh),
new SqlParameter("@DonGiaNhap", data.DonGiaNhap),
new SqlParameter("@DonGiaBan", data.DonGiaBan),
new SqlParameter("@SoLuong", data.SoLuong),
new SqlParameter("@DonViTinh", data.DonViTinh),
new SqlParameter("@GhiChu", data.GhiChu)
};
try
{
return SqlHelper.ExecuteNonQuery(con, CommandType.StoredProcedure, "AddProduct",
para);
}
catch (SqlException e)
{
return 0;
throw e;
}
catch (Exception e)
{
return 0;
throw e;
}
}
public bool EditProduct(DtoProduct data)
{
try
{
return _dalProduct.EditProduct(data) == 1 ? true : false;
}
catch (Exception)
{
return false;
}
}
public override bool Equals(object obj)
{
DtoProduct _obj = (DtoProduct)obj;
if (_obj.MaSanPham == MaSanPham && _obj.LoaiSanPham == LoaiSanPham && _obj.GhiChu == GhiChu && _obj.DonViTinh == DonViTinh &&
_obj.DonGiaNhap == DonGiaNhap && _obj.DonGiaBan == DonGiaBan && _obj.SoLuong == SoLuong && _obj.TenSanPham == TenSanPham && _obj.ThoiGianBaoHanh == ThoiGianBaoHanh)
{
return(true);
}
return(false);
}
private void btnLuu_Click(object sender, EventArgs e)
{
if (!CheckTextBox())
{
return;
}
DtoProduct data = new DtoProduct(
txtMaSanPham.Text,
txtTenSanPham.Text,
txtLoaiSanPham.Text,
int.Parse(txtThoiGianBaoHanh.Text),
double.Parse(txtDonGiaNhap.Text),
double.Parse(txtDonGiaBan.Text),
int.Parse(txtSoLuong.Text),
txtDonViTinh.Text,
txtGhiChu.Text);
if (_bllProduct.AddProduct(data))
{
MessageBox.Show(Constants.MsgNotificationSuccessfuly);
btnLuu.Enabled = false;
}
else
{
MessageBox.Show(Constants.MsgAlreadyExist);
}
txtMaSanPham.Enabled = false;
btnLamTuoi.PerformClick();
}
public DtoProduct GetProductByID(string id)
{
DataTable dt = SqlHelper.ExecuteDataset(con, CommandType.Text,
"select * from SANPHAM where MaSanPham = @MaSanPham", new SqlParameter("@MaSanPham", id)).Tables[0];
DtoProduct dto = new DtoProduct();
if (dt.Rows.Count > 0)
{
dto = new DtoProduct(
dt.Rows[0].ItemArray[0].ToString(),
dt.Rows[0].ItemArray[1].ToString(),
dt.Rows[0].ItemArray[2].ToString(),
int.Parse(dt.Rows[0].ItemArray[3].ToString()),
double.Parse(dt.Rows[0].ItemArray[4].ToString()),
double.Parse(dt.Rows[0].ItemArray[5].ToString()),
int.Parse(dt.Rows[0].ItemArray[6].ToString()),
dt.Rows[0].ItemArray[7].ToString(),
dt.Rows[0].ItemArray[8].ToString()
);
}
return dto;
}
private void btnLuu_Click(object sender, EventArgs e)
{
try
{
string keyselect = "";
if (!CheckTextBox())
{
return;
}
DtoProduct data = new DtoProduct(
txtMaSanPham.Text,
txtTenSanPham.Text,
txtLoaiSanPham.Text,
int.Parse(txtThoiGianBaoHanh.Text),
double.Parse(txtDonGiaNhap.Text),
double.Parse(txtDonGiaBan.Text),
0,
txtDonViTinh.Text,
txtGhiChu.Text);
keyselect = data.MaSanPham;
if (_bllProduct.AddProduct(data))
{
//MessageBox.Show(Constants.MsgNotificationSuccessfuly);
DisplayNotify(Constants.MsgNotificationSuccessfuly, 1);
btnLuu.Enabled = false;
txtMaSanPham.Enabled = false;
// btnLamTuoi.PerformClick();
dgvListProduct.DataSource = _bllProduct.GetListProducts();
DgvDataBindings();
SelectRow(dgvListProduct, keyselect);
}
else
{
DisplayNotify(Constants.MsgAlreadyExist, -1);
//MessageBox.Show(Constants.MsgAlreadyExist);
}
txtMaSanPham.Enabled = false;
}
catch (Exception ex)
{
DisplayNotify(ex.Message, -1);
}
}
