private void dataGridView1_CellContentDoubleClick(object sender, DataGridViewCellEventArgs e)
{
DataTable dsBanHang = new DataTable();
dsBanHang = con.GetDataInfo("SELECT NGUOIBAN.ID,NGUOIMUA.SDT,NGUOIMUA.TEN,NGUOIMUA.DIACHI,THUTIEN.PHUONGTHUCTHANHTOAN,THUTIEN.SOTIEN,BANHANG.GIAMGIA,BANHANG.TRANGTHAI FROM BANHANG INNER JOIN NGUOIBAN ON BANHANG.NGUOIBAN_ID = NGUOIBAN.ID INNER JOIN NGUOIMUA ON BANHANG.NGUOIMUA_ID = NGUOIMUA.ID INNER JOIN THUTIEN ON BANHANG.ID = THUTIEN.BANHANG_ID WHERE THUTIEN.BANHANG_ID = " + dataGridView1.Rows[e.RowIndex].Cells["id"].Value + "");
string idBanHang = dataGridView1.Rows[e.RowIndex].Cells["ID"].Value.ToString();
string idNguoiGui = dsBanHang.Rows[0]["ID"].ToString();
string sdtNguoiNhan_txt = dsBanHang.Rows[0]["SDT"].ToString();
string tenNguoiNhan_txt = dsBanHang.Rows[0]["TEN"].ToString();
string diaChiNguoiNhan = dsBanHang.Rows[0]["DIACHI"].ToString();
string nganHang_txt = dsBanHang.Rows[0]["PHUONGTHUCTHANHTOAN"].ToString();
string tienCoctxt = dsBanHang.Rows[0]["SOTIEN"].ToString();
string giamGiatxt = dsBanHang.Rows[0]["GIAMGIA"].ToString();
string trangthaibanhang = dsBanHang.Rows[0]["TRANGTHAI"].ToString();
List <string> soLuongHangBan = new List <string>();
List <string> giaBanHang = new List <string>();
for (int i = 0; i < dgv_temp.Rows.Count; i++)
{
soLuongHangBan.Add(con.LaySoLuongHangPhieuXuat(idBanHang, dgv_temp.Rows[i].Cells["ID"].Value.ToString()));
giaBanHang.Add(con.LayGiaHangPhieuXuat(idBanHang, dgv_temp.Rows[i].Cells["ID"].Value.ToString()));
//MessageBox.Show(soLuongHangBan[i] + "-"+giaBanHang[i]);
}
XUATHANG xUATHANG = new XUATHANG(idBanHang, idNguoiGui, sdtNguoiNhan_txt, tenNguoiNhan_txt, diaChiNguoiNhan, nganHang_txt, tienCoctxt, giamGiatxt, soLuongHangBan, giaBanHang, false, trangthaibanhang);
xUATHANG.Show();
}
public async Task <IHttpActionResult> GetXUATHANG(int id)
{
XUATHANG xUATHANG = await db.XUATHANG.FindAsync(id);
if (xUATHANG == null)
{
return(NotFound());
}
return(Ok(xUATHANG));
}
public async Task <IHttpActionResult> PostXUATHANG(XUATHANG xUATHANG)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.XUATHANG.Add(xUATHANG);
await db.SaveChangesAsync();
return(CreatedAtRoute("DefaultApi", new { id = xUATHANG.ID }, xUATHANG));
}
public async Task <IHttpActionResult> DeleteXUATHANG(int id)
{
XUATHANG xUATHANG = await db.XUATHANG.FindAsync(id);
if (xUATHANG == null)
{
return(NotFound());
}
db.XUATHANG.Remove(xUATHANG);
await db.SaveChangesAsync();
return(Ok(xUATHANG));
}
private void btnXuatHang_Click(object sender, EventArgs e)
{
foreach (LAYHANG l in lstLAYHANG)
{
XUATHANG xh = new XUATHANG();
xh.NHAPHANG_ID = l.IDNHAP;
xh.CHITIETDH_ID = CTDH.ID;
xh.SOLUONGXUAT = l.SOLUONGLAY;
xh.GIANHAP = l.GIANHAP;
xh.GIABAN = CTDH.DONGIA;
xhDAO.insertXUATHANG(xh);
//CHITIETNHAPHANG ctnh = new NhapHangDAO().GetCTNHbyId(xh.NHAPHANG_ID);
//ctnh.SOLUONGCONLAI = ctnh.SOLUONGNHAP - xh.SOLUONGXUAT;
//new NhapHangDAO().updateNHAPHANG(ctnh);
}
MessageBox.Show("Xong!");
}
public async Task <IHttpActionResult> PutXUATHANG(XUATHANG xUATHANG)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.Entry(xUATHANG).State = EntityState.Modified;
try
{
await db.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
}
return(StatusCode(HttpStatusCode.NoContent));
}
public void insertXUATHANG(XUATHANG xh)
{
cn.Post <XUATHANG>("api/XUATHANG/", xh);
}
