public static bool Delete(ChietKhau data, User user)
{
try
{
if (data != null)
{
ChietKhau objDb = GetById(data.Id);
if (objDb != null)
{
data.UpdateBy = user.UserName;
data.UpdateDate = DateTime.Now;
objDb.DeleteFlag = true;
dbContext.SubmitChanges();
return true;
}
}
}
catch
{
}
CreateSQlConnection();
return false;
}
public UcInfo()
{
InitializeComponent();
dataHoaDon = new HoaDon();
dataHoaDonDetail = new HoaDonDetail();
dataSP = new DTO.SanPham();
dataChietKhau = new ChietKhau();
isUpdate = false;
if (InitSP() && Init())
{
RefreshDataSP();
RefreshData();
CreateNewId();
pbAvatar.Image = Image.FromFile(ConstantResource.SANPHAM_DEFAULT_SP);
}
else
{
this.Visible = false;
}
}
private void GetInfoSP()
{
try
{
dataSP = SanPhamBus.GetById(ConvertUtil.ConvertToInt(((CommonComboBoxItems)cbMaSP.SelectedItem).Value));
dataCK = ChietKhauBus.GetByIdSP(dataSP.Id);
if (dataSP.GiaBan == 0)
{
MessageBox.Show(Constant.MESSAGE_ERROR_MISSING_MONEY, Constant.CAPTION_ERROR, MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
tbTenSP.Text = dataSP.Ten;
int soLuong = 0;
bool isDuplicated = false;
foreach (ListViewItem item in lvThongTin.Items)
{
if (ConvertUtil.ConvertToInt(item.SubItems[1].Text) == dataSP.Id)
{
soLuong = ConvertUtil.ConvertToInt(item.SubItems[6].Text);
tbChietKhau.Text = ConvertUtil.ConvertToInt(item.SubItems[4].Text.Replace(Constant.SYMBOL_DISCOUNT, string.Empty)).ToString();
tbChietKhau.ReadOnly = true;
isDuplicated = true;
break;
}
}
soLuong = dataSP.SoLuong - soLuong;
tbTon.Text = soLuong.ToString();
if (soLuong > 0)
{
tbSoLuong.Text = "1";
tbSoLuong.ReadOnly = false;
}
else
{
tbSoLuong.Text = string.Empty;
tbSoLuong.ReadOnly = true;
}
if (!chbCKTongHD.Checked && !isDuplicated)
{
tbChietKhau.ReadOnly = false;
tbChietKhau.Text = dataKH == null ? string.Empty : dataKH.KhachHangGroup.ChietKhau.ToString();
if (dataCK != null && dataCK.Value != 0)
{
tbChietKhau.Text = dataCK.Value.ToString();
}
}
tbDVT.Text = dataSP.DonViTinh;
tbGiaBan.Text = dataSP.GiaBan.ToString(Constant.DEFAULT_FORMAT_MONEY);
if (!string.IsNullOrEmpty(dataSP.Avatar))
{
pbAvatar.Image = Convert_Function.ConvertByteArrayToImage(Convert_Function.ConvertStringToByteArray(dataSP.Avatar));
}
else
{
pbAvatar.Image = Image.FromFile(ConstantResource.SANPHAM_DEFAULT_SP);
}
}
catch
{
MessageBox.Show(Constant.MESSAGE_ERROR_NULL_DATA, Constant.CAPTION_ERROR, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void detach_ChietKhaus(ChietKhau entity)
{
this.SendPropertyChanging();
entity.SanPham = null;
}
partial void DeleteChietKhau(ChietKhau instance);
partial void UpdateChietKhau(ChietKhau instance);
partial void InsertChietKhau(ChietKhau instance);
private void detach_ChietKhaus(ChietKhau entity)
{
this.SendPropertyChanging();
entity.KhachHangGroup = null;
}
public static bool Update(ChietKhau data, User user)
{
return ChietKhauDao.Update(data, user);
}
public static bool Insert(ChietKhau data, User user)
{
return ChietKhauDao.Insert(data, user);
}
public static bool Delete(ChietKhau data, User user)
{
return ChietKhauDao.Delete(data, user);
}
public static bool Update(ChietKhau data, User user)
{
try
{
if (data != null)
{
data.UpdateBy = user.UserName;
data.UpdateDate = DateTime.Now;
dbContext.SubmitChanges();
return true;
}
return false;
}
catch
{
return false;
}
}
public static bool Insert(ChietKhau data, User user)
{
try
{
if (GetByIdSP(data.IdSanPham) != null)
{
return false;
}
data.CreateBy = data.UpdateBy = user.UserName;
data.CreateDate = data.UpdateDate = DateTime.Now;
dbContext.ChietKhaus.InsertOnSubmit(data);
dbContext.SubmitChanges();
return true;
}
catch
{
return false;
}
}
public UcInfo(DTO.HoaDonDetail data)
{
InitializeComponent();
dataHoaDonDetail = data;
dataHoaDon = data.HoaDon;
dataSP = data.SanPham;
dataChietKhau = ChietKhauBus.GetByIdSP(data.IdSanPham);
dataXuatXu = dataSP.XuatXu;
isUpdate = true;
lbSelect.Text = Constant.DEFAULT_TITLE_EDIT;
if (HoaDonDetailBus.CheckIfSold(data.IdSanPham))
{
tbSoLuong.ReadOnly = true;
}
cbChangeMoney.SelectedIndex = 0;
if (InitSP() && Init())
{
tbMaSP.Text = dataSP.MaSanPham;
cbGroup.Text = dataSP.SanPhamGroup.Ten;
cbDVTSP.Text = dataSP.DonViTinh;
tbTenSP.Text = dataSP.Ten;
tbSize.Text = dataSP.Size;
cbXuatXu.Text = dataXuatXu == null ? string.Empty : dataXuatXu.Ten;
tbHieu.Text = dataSP.Hieu;
tbThoiHan.Text = dataSP.ThoiHan == 0 ? string.Empty : dataSP.ThoiHan.ToString();
cbDonViThoiHan.Text = dataSP.DonViThoiHan;
tbMoTa.Text = dataSP.MoTa;
tbMaNhap.Text = dataHoaDon.MaHoaDon;
tbGiaNhap.Text = dataSP.GiaMua.ToString(Constant.DEFAULT_FORMAT_MONEY);
tbSoLuong.Text = data.SoLuong.ToString();
tbLaiSuat.Text = dataSP.LaiSuat.ToString();
tbGiaBan.Text = dataSP.GiaBan.ToString(Constant.DEFAULT_FORMAT_MONEY);
tbGhiChu.Text = dataHoaDon.GhiChu;
tbChietKhau.Text = dataChietKhau == null ? string.Empty : dataChietKhau.Value.ToString();
//avatarPath = Path.Combine(File_Function.getFinalFolder(listFolderAvatar), CommonFunc.setAvatarPath(dataSP.MaSanPham, dataSP.CreateDate));
if (!string.IsNullOrEmpty(dataSP.Avatar))
{
//string sImage = Convert_Function.ConvertByteArrayToString(Convert_Function.ConvertImageToByteArray(Image.FromFile(avatarPath)));
pbAvatar.Image = Convert_Function.ConvertByteArrayToImage(Convert_Function.ConvertStringToByteArray(dataSP.Avatar));
}
else
{
pbAvatar.Image = Image.FromFile(ConstantResource.SANPHAM_DEFAULT_SP);
}
oldDate = dataSP.UpdateDate;
}
else
{
this.Visible = false;
}
}
private void InsertChietKhau()
{
dataChietKhau = new ChietKhau();
dataChietKhau.IdSanPham = dataSP.Id;
dataChietKhau.Value = ConvertUtil.ConvertToInt(tbChietKhau.Text);
if (ChietKhauBus.Insert(dataChietKhau, FormMain.user))
{
UpdatePriceSP();
}
else
{
try
{
ChietKhauBus.Delete(dataChietKhau, FormMain.user);
}
catch
{
//
}
if (MessageBox.Show(Constant.MESSAGE_INSERT_ERROR + Constant.MESSAGE_NEW_LINE + Constant.MESSAGE_EXIT, Constant.CAPTION_ERROR, MessageBoxButtons.OKCancel, MessageBoxIcon.Warning) == DialogResult.OK)
{
this.Dispose();
}
}
}
