//Luu Chi tiet don Hang
public int LuuChiTietNhapHang(CT_HDNHAP ct)
{
try
{
QLCH.CT_HDNHAPs.InsertOnSubmit(ct);
QLCH.SubmitChanges();
return(1);
}
catch
{
return(0);
}
}
private void BtnLuuCTHD_Click(object sender, EventArgs e)
{
for (int i = 0; i < dataGridView1.Rows.Count; i++)
{
string masp = dataGridView1.Rows[i].Cells["MaSP"].Value.ToString();
string tensp = dataGridView1.Rows[i].Cells["TenSP"].Value.ToString();
string mahdn = dataGridView1.Rows[i].Cells["MaHDN"].Value.ToString();
string soluongnhap = dataGridView1.Rows[i].Cells["SoLuongNhap"].Value.ToString();
string dongianhap = dataGridView1.Rows[i].Cells["DonGiaNhap"].Value.ToString();
string tongtien = dataGridView1.Rows[i].Cells["TongTien"].Value.ToString();
string dongiaban = dataGridView1.Rows[i].Cells["DonGiaBan"].Value.ToString();
string mathuonghieu = dataGridView1.Rows[i].Cells["MaThuongHieu"].Value.ToString();
CT_HDNHAP ct = new CT_HDNHAP();
//ct.MACHITIET_PD = 1 + i++;
ct.MaSP = Convert.ToInt32(masp);
ct.MaHDN = Convert.ToInt32(mahdn);
ct.SoLuongNhap = Convert.ToInt32(soluongnhap) + 1;
ct.DonGiaNhap = Convert.ToInt32(dongianhap);
ct.TongTien = Convert.ToDouble(tongtien);
NhapHangDal.LuuChiTietNhapHang(ct);
NhapHangDal.LuuChiTietNhapHang(ct);
//{
// MessageBox.Show("Lưu đơn đặt hàng thành công rồi!");
//}
//else
//{
// MessageBox.Show("Lưu đơn đặt hàng thất bại! Chúc bạn may mắn lần sau.");
//}
SANPHAM sp = new SANPHAM();
//sp.MaSP = Convert.ToInt32(masp);
//sp.TenSP = tensp;
//sp.DonGiaNhap = float.Parse(dongianhap);
//sp.DonGiaBan = float.Parse(dongiaban);
sp.SoLuongTon = (Convert.ToInt32(txtSoLuongTon.Text) + (Convert.ToInt32(soluongnhap)));
//sp.MoTa = txtMoTa.Text;
//sp.MaThuongHieu = Convert.ToInt32(mathuonghieu);
NhapHangDal.UpdateSanPham(Convert.ToInt32(masp), Convert.ToInt32(sp.SoLuongTon), Convert.ToInt32(dongianhap), Convert.ToInt32(dongiaban));
}
HOADONNHAP hd = new HOADONNHAP();
hd.ThanhTienHDN = Convert.ToInt32(txtThanhTienNew.Text);
NhapHangDal.UpdateThanhTienHD(Convert.ToInt32(txtMaHD.Text), Convert.ToInt32(txtThanhTienNew.Text));
MessageBox.Show("Nhập hàng thành công rồi!", "Thông Báo", MessageBoxButtons.OK, MessageBoxIcon.Information, MessageBoxDefaultButton.Button1);
}
public bool UpdateCT(int IDHoaDon)
{
var sv = new CT_HDNHAP
{
IDHang = view.IDHang,
IDHoaDon = IDHoaDon,
SoLuong = view.SoLuong,
DonGiaNhap = view.DonGiaNhap,
ThanhTien = view.SoLuong * view.DonGiaNhap
};
var hd = model.Get1Item(IDHoaDon);
var ct = modelCT.Get1Item(IDHoaDon, view.IDHang);
hd.TongTien += sv.ThanhTien - ct.ThanhTien;
var hang = modelHang.Get1Hang(view.IDHang);
hang.SLTon += sv.SoLuong - ct.SoLuong;
model.Update(hd);
return(modelCT.Update(sv));
}
public bool InseartCT(int idHoaDon)
{
var sv = new CT_HDNHAP
{
IDHang = view.IDHang,
IDHoaDon = idHoaDon,
SoLuong = view.SoLuong,
DonGiaNhap = view.DonGiaNhap,
ThanhTien = view.SoLuong * view.DonGiaNhap
};
var hd = model.Get1Item(idHoaDon);
var hang = modelHang.Get1Hang(view.IDHang);
hang.DonGiaNhap = view.DonGiaNhap;
hang.DonGiaBan = 2 * view.DonGiaNhap;
hang.SLTon += sv.SoLuong;
modelHang.Update(hang);
hd.TongTien += sv.ThanhTien;
model.Update(hd);
return(modelCT.Insert(sv));
}
