private void ShowInfoDonNhapHang(DonNhapHang donNhapHang)
{
txtMaHD.Text = donNhapHang.MaDNH;
nhaCungCap = nhacungcapBLL.GetNhaCungCapByID(donNhapHang.MaNCC);
txtTenNCC.Text = nhaCungCap.Ten;
txtNgayLap.Text = donNhapHang.NgayLap.ToString();
txtSDT.Text = nhaCungCap.SoDienThoai;
txtDiaChi.Text = nhaCungCap.DiaChi;
txtEmail.Text = nhaCungCap.Email;
dgvCTDNH.Rows.Clear();
dgvCTDNH.Refresh();
foreach (HangHoa hh in donNhapHang.DSHangHoa)
{
DataGridViewRow row = (DataGridViewRow)dgvCTDNH.Rows[0].Clone();
row.Cells[0].Value = hh.MaHH;
row.Cells[3].Value = hh.GiaGoc;
row.Cells[4].Value = hh.SoLuong;
int thanhtien = hh.GiaGoc * hh.SoLuong;
row.Cells[5].Value = thanhtien.ToString();
HangHoa hh2 = hangBLL.GetHangHoaByID(hh.MaHH);
row.Cells[1].Value = hh2.TenHH;
row.Cells[2].Value = hh2.LoaiHang;
dgvCTDNH.Rows.Add(row);
}
lblTotalPrice.Text = donNhapHang.TongTien.ToString();
lblDaTra.Text = donNhapHang.DaTra.ToString();
lblConLai.Text = donNhapHang.ConLai.ToString();
}
public bool updateDonDatHang(DonNhapHang _donNhapHang)
{
try
{
SqlCommand cmd = new SqlCommand("DONHAPHANG_Update", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@maDNH", SqlDbType.VarChar, 10)).Value = _donNhapHang.MaDNH;
cmd.Parameters.Add(new SqlParameter("@ngayLap", SqlDbType.Date)).Value = _donNhapHang.NgayLap;
cmd.Parameters.Add(new SqlParameter("@maNV", SqlDbType.VarChar, 10)).Value = _donNhapHang.MaNV;
cmd.Parameters.Add(new SqlParameter("@maNCC", SqlDbType.VarChar, 10)).Value = _donNhapHang.MaNCC;
cmd.Parameters.Add(new SqlParameter("@tongTien", SqlDbType.Int)).Value = _donNhapHang.TongTien;
cmd.Parameters.Add(new SqlParameter("@ngayGiaoDuKien", SqlDbType.Date)).Value = _donNhapHang.NgayGiaoDuKien;
cmd.Parameters.Add(new SqlParameter("@ghiChu", SqlDbType.VarChar, 100)).Value = _donNhapHang.GhiChu;
cmd.Parameters.Add(new SqlParameter("@isActive", SqlDbType.Bit)).Value = _donNhapHang.IsActive;
if (conn.State != ConnectionState.Open)
{
conn.Open();
}
cmd.ExecuteNonQuery();
conn.Close();
return(true);
}
catch (Exception e)
{
conn.Close();
Console.WriteLine("Lỗi: " + e.Message);
return(false);
}
}
private void btn_yeucaunhaphang_Click(object sender, EventArgs e)
{
DonNhapHang dnh = new DonNhapHang()
{
LyDo = txt_lydo.Text,
NguoiLap = this.NhanVien.ID,
NCC = ((NhaCungCap)comb_ncc.SelectedItem).ID,
NgayLap = DateTime.Now
};
DonNhapHang kq = DonNhapHang_BUL.Them(dnh);
if (kq != null)
{
bool rs1 = ChiTietDonNhapHang_BUL.themList(kq.ID, this.ListChiTietDNH);
if (rs1)
{
MessageSucess();
}
else
{
MesageFaild();
}
}
else
{
MesageFaild();
}
}
private void dgvDSDonNhapHang_CellClick(object sender, DataGridViewCellEventArgs e)
{
if (e.RowIndex > -1)
{
donNhapHang = donnhaphangBLL.GetDonNhapHangByID(dgvDSDonNhapHang.Rows[e.RowIndex].Cells[0].Value.ToString());
ShowInfoDonNhapHang(donNhapHang);
}
}
private void frmAddDonNhapHang_Load(object sender, EventArgs e)
{
donNhapHang = new DonNhapHang();
dgvHangHoa.DataSource = hangBLL.LoadDanhSachHHCungCap();
cboLoaiHang.DataSource = loaiBLL.LoadAll();
cboLoaiHang.DisplayMember = "TenLoai";
cboLoaiHang.ValueMember = "ID";
cboLoaiHang.SelectedIndex = -1;
}
public HttpResponseMessage PostDonNhapHang(DonNhapHang item)
{
DonNhapHangServices.AddDonNhapHang(item);
var response = Request.CreateResponse <DonNhapHang>(HttpStatusCode.Created, null);
string uri = Url.Link("DefaultApi", null);
response.Headers.Location = new Uri(uri);
return(response);
}
public bool CapNhatCongNo(DonNhapHang dnh, int traThem)
{
string spName = "UPDATE_DONNHAPHANG";
string[] pNames = { "@MADNH", "@MANCC", "@NGAYNHAP", "@TONGTIEN", "@DATRA" };
object[] pValues = { dnh.MaDNH, dnh.MaNCC, dnh.NgayLap, dnh.TongTien, dnh.DaTra + traThem };
int count = db.ExecuteStoredProcedure(spName, pNames, pValues);
return(count > 0);
}
public bool Them(DonNhapHang dnh)
{
string query = "Insert INTO DonNhapHang( MaDNH, MaDTBH, MaNV, NgayLap, LydoNhap, TongTien) VALUES ( @MaDTH , @MaDTBH , @MaNV , @NgayLap , @LyDoNhap , @TongTien ) ";
object[] para = new object[] { dnh.MaDNH, dnh.MaDT, dnh.MaNV, dnh.NgayLap, dnh.LyDo, dnh.TongTien };
if (DataProvider.Instance.ExecuteNonQuery(query, para) > 0)
{
return(true);
}
return(false);
}
public frmCapNhatCongNo(DonNhapHang donNhapHang, string tenNCC)
{
InitializeComponent();
this.donNhapHang = donNhapHang;
lblMaHD.Text = donNhapHang.MaDNH;
lblTen.Text = tenNCC;
lblNgayLap.Text = donNhapHang.NgayLap.ToString();
lblTongTien.Text = donNhapHang.TongTien.ToString();
lblConNo.Text = donNhapHang.ConLai.ToString();
lblConLai.Text = donNhapHang.ConLai.ToString();
}
static public DonNhapHang Them(DonNhapHang dnh)
{
DonNhapHang rs = null;
using (PTTKHTEntities context = new PTTKHTEntities())
{
context.DonNhapHangs.Add(dnh);
context.SaveChanges();
rs = dnh;
}
return(rs);
}
private void dgvHoaDon_CellClick(object sender, DataGridViewCellEventArgs e)
{
if (e.RowIndex > -1)
{
donNhapHangBLL = new DonNhapHangBLL();
string maHD = dgvHoaDon.Rows[e.RowIndex].Cells[0].Value.ToString();
donNhapHang = donNhapHangBLL.GetDonNhapHangByID(maHD);
txtMaHD.Text = donNhapHang.MaDNH;
txtNgayLap.Text = donNhapHang.NgayLap.ToString();
txtConNo.Text = donNhapHang.ConLai.ToString();
txtTongTien.Text = donNhapHang.TongTien.ToString();
}
}
public DonNhapHang GetDonNhapHangByID(string id)
{
DonNhapHang lh = new DonNhapHang();
foreach (DonNhapHang hd in list)
{
if (hd.MaDNH == id)
{
lh = hd;
break;
}
}
return(lh);
}
public static List <DonNhapHang> GetList()
{
DataAccessHelper db = new DataAccessHelper();
DataTable dt = db.GetDataTable("SELECT * FROM DonNhapHang");
List <DonNhapHang> list = new List <DonNhapHang>();
foreach (DataRow item in dt.Rows)
{
DonNhapHang hd = new DonNhapHang(item);
hd.DSHangHoa = GetHangHoaTrongDonNhapHang(hd.MaDNH);
list.Add(hd);
}
return(list);
}
public bool AddNewChiTietDNH(DonNhapHang dnh)
{
int count = 1;
string spName = "Insert_CTDNH";
string maHD = GetMaDNHLastest(dnh.MaNCC, dnh.NgayLap);
foreach (var hh in dnh.DSHangHoa)
{
string[] pNames = { "@MaDNH", "@MaHH", "@SoLuong" };
object[] pValues = { maHD, hh.MaHH, hh.SoLuong };
count *= db.ExecuteStoredProcedure(spName, pNames, pValues);
}
return(count > 0);
}
public bool AddNewDonNhapHang(DonNhapHang dnh)
{
string spName = "Insert_DonNhapHang";
string[] pNames = { "@MaNCC", "@NgayNhap", "@TongTien", "@DaTra" };
object[] pValues = { dnh.MaNCC, dnh.NgayLap, dnh.TongTien, dnh.DaTra };
int count = db.ExecuteStoredProcedure(spName, pNames, pValues);
if (count > 0)
{
return(AddNewChiTietDNH(dnh));
}
else
{
return(false);
}
}
public static bool XacNhanDonNhap(int IDDonTra, int IDNguoiXacNhan)
{
bool rs = false;
using (PTTKHTEntities context = new PTTKHTEntities())
{
DonNhapHang abc = context.DonNhapHangs.SingleOrDefault(b => b.ID == IDDonTra);
abc.NguoiXacNhan = IDNguoiXacNhan;
abc.NgayXacNhan = DateTime.Now;
foreach (ChiTietDonNhapHang ct in abc.ChiTietDonNhapHangs)
{
ct.HangHoa.SoLuongTra += ct.SoLuong;
}
int index = context.SaveChanges();
rs = true;
}
return(rs);
}
public static void AddDonNhapHang(DonNhapHang donNhapHang)
{
HttpClient client = new HttpClient();
client.BaseAddress = new Uri("https://localhost:44396/api/");
client.DefaultRequestHeaders.Accept.Clear();
client.DefaultRequestHeaders.Accept.Add(
new MediaTypeWithQualityHeaderValue("application/json"));
try
{
HttpResponseMessage response = client.PostAsJsonAsync("DonNhapHang", donNhapHang).Result;
response.EnsureSuccessStatusCode();
}
catch (Exception e)
{
throw e;
}
}
private void btnLapDon_Click(object sender, EventArgs e)
{
DonNhapHang dnh = new DonNhapHang(int.Parse(tbMaDNH.Text), int.Parse(cbDT.SelectedValue.ToString()), int.Parse(cbMaNV.SelectedValue.ToString()), DateTime.ParseExact(dtpk_NgayLap.Text, "dd-MM-yyyy", CultureInfo.InvariantCulture), tbLyDoNhap.Text, 0);
if (DonNhapHangBUS.Instance.Them(dnh))
{
MessageBox.Show("Thêm thành công");
dtgvDNH.DataSource = DonNhapHangBUS.Instance.HienThi();
//MHDonNhapHang_Load(sender, e);
MessageBox.Show("Thêm chi tiết đơn nhập hàng");
MHCTDonNhapHang nh = new MHCTDonNhapHang();
this.Hide();
nh.Show();
}
else
{
MessageBox.Show("Lỗi");
}
}
public bool addDonNhapHang(DonNhapHang _donNhapHang)
{
try
{
SqlCommand cmd = new SqlCommand("DONHAPHANG_Insert", conn);
cmd.CommandType = CommandType.StoredProcedure;
_maDNH = cmd.Parameters.Add(new SqlParameter("@maDNH", SqlDbType.VarChar, 10));
_ngayLap = cmd.Parameters.Add(new SqlParameter("@ngayLap", SqlDbType.Date));
_maNV = cmd.Parameters.Add(new SqlParameter("@maNV", SqlDbType.NVarChar, 10));
_maNCC = cmd.Parameters.Add(new SqlParameter("@maNCC", SqlDbType.NVarChar, 10));
_tongTien = cmd.Parameters.Add(new SqlParameter("@tongTien", SqlDbType.Int));
_ngayGiaoDuKien = cmd.Parameters.Add(new SqlParameter("@ngayGiaoDuKien", SqlDbType.Date));
_ghiChu = cmd.Parameters.Add(new SqlParameter("@ghiChu", SqlDbType.NVarChar, 100));
_isActive = cmd.Parameters.Add(new SqlParameter("@isActive", SqlDbType.Bit));
//Get value to parameters:
_maDNH.Value = _donNhapHang.MaDNH;
_ngayLap.Value = _donNhapHang.NgayLap;
_maNV.Value = _donNhapHang.MaNV;
_maNCC.Value = _donNhapHang.MaNCC;
_tongTien.Value = _donNhapHang.TongTien;
_ngayGiaoDuKien.Value = _donNhapHang.NgayGiaoDuKien;
_ghiChu.Value = _donNhapHang.GhiChu;
_isActive.Value = _donNhapHang.IsActive;
if (conn.State != ConnectionState.Open)
{
conn.Open();
}
cmd.ExecuteNonQuery();
conn.Close();
return(true);
}
catch (Exception e)
{
conn.Close();
Console.WriteLine("Lỗi: " + e.Message);
return(false);
}
}
public DonNhapHang DocThongTin(int madth)
{
string query = "Select * From DonNhapHang where MaDTH = @MaDTH ";
object[] para = new object[] { madth };
DataTable data = DataProvider.Instance.ExecuteQuery(query, para);
foreach (DataRow item in data.Rows)
{
int MaDNH = (int)item["MaDNH"];
int MaDT = (int)item["MaDTBH"];
int MaNV = (int)item["MaNV"];
DateTime NgayLap = DateTime.Parse(item["NgayLap"].ToString());
string Lydo = item["LyDoNhap"].ToString();
int TongTien = (int)item["TongTien"];
DonNhapHang newdnh = new DonNhapHang(MaDNH, MaDT, MaNV, NgayLap, Lydo, TongTien);
return(newdnh);
}
return(null);
}
public async Task <DonNhapHang> UpdateById(string id, DonNhapHangForUpdateDto donNhapHang)
{
var oldRecord = await _context.DanhSachDonNhapHang.AsNoTracking().FirstOrDefaultAsync(x => x.MaDonNhapHang == id);
var tinhTrang = "";
if (donNhapHang.DaThanhToan == 0)
{
tinhTrang = "Chưa thanh toán";
}
else if (donNhapHang.DaThanhToan != donNhapHang.ThanhTien && donNhapHang.DaThanhToan > 0)
{
tinhTrang = "Đã thanh toán một phần";
}
else
{
tinhTrang = "Đã thanh toán";
}
var donNhapHangToUpdateById = new DonNhapHang
{
MaDonNhapHang = id,
MaNhaCungCap = donNhapHang.MaNhaCungCap,
MaNhanVien = donNhapHang.MaNhanVien,
NgayGiaoHang = donNhapHang.NgayGiaoHang,
NgayLap = donNhapHang.NgayLap,
GhiChu = donNhapHang.GhiChu,
ThanhTien = donNhapHang.ThanhTien,
DaThanhToan = donNhapHang.DaThanhToan,
TinhTrang = tinhTrang,
TrangThai = donNhapHang.TrangThai,
ThoiGianTao = oldRecord.ThoiGianTao,
DaXoa = oldRecord.DaXoa
};
_context.DanhSachDonNhapHang.Update(donNhapHangToUpdateById);
await _context.SaveChangesAsync();
return(donNhapHangToUpdateById);
}
public async Task <DonNhapHang> Create(DonNhapHangForCreateDto donNhapHang)
{
var tinhTrang = "";
if (donNhapHang.DaThanhToan == 0)
{
tinhTrang = "Chưa thanh toán";
}
else if (donNhapHang.DaThanhToan != donNhapHang.ThanhTien && donNhapHang.DaThanhToan > 0)
{
tinhTrang = "Đã thanh toán một phần";
}
else
{
tinhTrang = "Đã thanh toán";
}
var newDonNhapHang = new DonNhapHang
{
MaDonNhapHang = GenerateId(),
MaNhaCungCap = donNhapHang.MaNhaCungCap,
MaNhanVien = donNhapHang.MaNhanVien,
NgayGiaoHang = donNhapHang.NgayGiaoHang,
NgayLap = donNhapHang.NgayLap,
GhiChu = donNhapHang.GhiChu,
ThanhTien = donNhapHang.ThanhTien,
DaThanhToan = donNhapHang.DaThanhToan,
TinhTrang = tinhTrang,
ThoiGianCapNhat = DateTime.Now,
ThoiGianTao = DateTime.Now,
TrangThai = 1,
DaXoa = 0
};
await _context.DanhSachDonNhapHang.AddAsync(newDonNhapHang);
await _context.SaveChangesAsync();
return(newDonNhapHang);
}
public bool lapdonnhaphang(int PNVQL)
{
DataTable Sanpham = Dal_hanghoa.GetNhapHang(PNVQL);
foreach (DataRow row in Sanpham.Rows)
{
DonNhapHang dnh = new DonNhapHang();
dnh.Masp = row.Field <int>("MASP");
dnh.NCC = row.Field <int>("NCC");
dnh.NVPhuTrach = PNVQL;
dnh.Soluong = row.Field <int>("SLToiDa") - row.Field <int>("SLTonKho");
DateTime NgayNhap = DateTime.Now;
dnh.NgayNhap = NgayNhap.Date.ToString("MM/dd/yyyy");
dnh.Lydo = "HET HANG";
dnh.XacNhan = 0;
if (!Dal_hanghoa.InsertNhapHang(dnh))
{
return(false);
}
}
return(true);
}
public bool InsertNhapHang(DonNhapHang DNH)
{
try
{
SqlConnection conn = DBUtils.GetDBConnection();
SqlCommand com = new SqlCommand("insert into LICHSU_NHAP_NHACUNGCAP (MASP, NGAYNHAP, SOLUONG, NVPHUTRACH, XACNHAN, NCC,LYDONHAPHANG,QUANLY) values (@MASP,@NGAYNHAP,@SOLUONG,@NVPHUTRACH,@XACNHAN,@NCC,@LYDO,NULL)", conn);
conn.Open();
com.Parameters.AddWithValue("@MASP", DNH.Masp);
com.Parameters.AddWithValue("@NGAYNHAP", DNH.NgayNhap);
com.Parameters.AddWithValue("@SOLUONG", DNH.Soluong);
com.Parameters.AddWithValue("@NVPHUTRACH", DNH.NVPhuTrach);
com.Parameters.AddWithValue("@XACNHAN", DNH.XacNhan);
com.Parameters.AddWithValue("@NCC", DNH.NCC);
com.Parameters.AddWithValue("@LYDO", DNH.Lydo);
com.ExecuteNonQuery();
conn.Close();
return(true);
}
catch
{
return(false);
}
}
public static void AddDonNhapHang(DonNhapHang item)
{
try
{
string connectionString = String.Format("Server={0};Database={1};Integrated Security={2};",
Properties.Resources.ServerName,
Properties.Resources.DatabaseName,
Properties.Resources.Integrated_Security
);
using (SqlConnection conn = new SqlConnection(connectionString))
{
conn.Open();
SqlCommand cmd = new SqlCommand("ADD_DONNHAPHANG", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@NGAYLAP", item.NgayLap));
cmd.Parameters.Add(new SqlParameter("@MANV", item.MaNV));
cmd.ExecuteNonQuery();
}
}
catch
{
throw;
}
}
public DonNhapHang getDonNhapHang(string _maDonNhapHang)
{
try
{
SqlCommand cmd = new SqlCommand("DONNHAPHANG_getDonNhapHang", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@maDNH", SqlDbType.VarChar, 10)).Value = _maDNH;
if (conn.State != ConnectionState.Open)
{
conn.Open();
}
SqlDataReader dr = cmd.ExecuteReader();
DonNhapHang donnhaphang = null;
if (dr.Read())
{
donnhaphang = new DonNhapHang();
donnhaphang.MaDNH = dr["MaNV"].ToString();
donnhaphang.NgayLap = (DateTime)dr["NgayLap"];
donnhaphang.MaNV = dr["MaNV"].ToString();
donnhaphang.MaNCC = dr["MaNCC"].ToString();
donnhaphang.TongTien = (int)dr["TongTien"];
donnhaphang.NgayGiaoDuKien = (DateTime)dr["NgayGiaoDuKien"];
donnhaphang.GhiChu = dr["GhiChu"].ToString();
donnhaphang.IsActive = (Convert.ToInt32(dr["IsActive"]) == 1) ? true : false;
}
conn.Close();
return(donnhaphang);
}
catch (Exception e)
{
conn.Close();
Console.WriteLine("Lỗi: " + e.Message);
return(null);
}
}
public bool updateDonDatHang(DonNhapHang _donnhaphang)
{
return(objDNH.updateDonDatHang(_donnhaphang));
}
public bool AddNewHoaDon(DonNhapHang dnh)
{
return(dal.AddNewDonNhapHang(dnh));
}
public bool Them(DonNhapHang dth)
{
return(DonNhapHangDAC.Instance.Them(dth));
}
public bool CapNhatCongNo(DonNhapHang dnh, int traThem)
{
return(dal.CapNhatCongNo(dnh, traThem));
}
