public JsonResult SaveData(string maphieunhap, string mancc, string ngaynhap, string masp, int soluongnhap, int dongia)
{
int thanhtien = soluongnhap * dongia;
PhieuNhap pn = new PhieuNhap();
pn.MaPhieuNhap = maphieunhap;
pn.MaNCC = mancc;
pn.NgayNhap = DateTime.Parse(ngaynhap);
pn.ThanhTien = thanhtien;
ChiTietPN cpn = new ChiTietPN();
cpn.MaPhieuNhap = maphieunhap;
cpn.MaSP = masp;
cpn.SoLuongNhap = soluongnhap;
cpn.DonGia = dongia;
NhapHangBus mhb = new NhapHangBus();
mhb.SuaHang(pn, thanhtien, cpn);
ChiTietPNModel pnb = new ChiTietPNModel();
//var ds = ssp.LaySanPham(masp);
//ds.SoLuongTon += soluongnhap;
//ds.NgayCapNhat = DateTime.Parse(ngaynhap);
return(Json(new { success = true, ms = "thanh cong" }, JsonRequestBehavior.AllowGet));
}
public List <ChiTietPN> LayDsPnTheoMaFull(string ma)
{
dt = db.LayDuLieu("select cp.MaPhieuNhap,cp.MaSP,cp.SoLuongNhap,cp.DonGia,p.MaNCC,p.NgayNhap,p.ThanhTien from ChiTietPN cp inner join PhieuNhap p on cp.MaPhieuNhap = p.MaPhieuNhap where p.MaPhieuNhap = '" + ma + "'");
List <ChiTietPN> ds = new List <ChiTietPN>();
foreach (DataRow r in dt.Rows)
{
ChiTietPN l = new ChiTietPN();
l.MaPhieuNhap = Convert.ToString(r[0]);
l.MaSP = Convert.ToString(r[1]);
l.SoLuongNhap = Convert.ToInt32(r[2]);
l.DonGia = Convert.ToInt32(r[3]);
var MaNCC = Convert.ToString(r[4]);
l.PhieuNhap = new PhieuNhap
{
MaNCC = Convert.ToString(r[4]),
NgayNhap = Convert.ToDateTime(r[5]),
ThanhTien = Convert.ToInt32(r[6])
};
//try
//{
// l.PhieuNhap.MaNCC = MaNCC;
// l.PhieuNhap.NgayNhap = Convert.ToDateTime(r[5]);
// l.PhieuNhap.NgayNhap = Convert.ToDateTime(r[6]);
//}
//catch (NullReferenceException e)
//{
// var aa = e.ToString();
//}
ds.Add(l);
}
return(ds);
}
private void btnIn_Click(object sender, EventArgs e)
{
string maPN = cbxPhieuNhap.SelectedValue.ToString();
DataRow pn = handle.phieunhap.find(maPN);
if (pn != null)
{
DataRow nguoidung = handle.nguoidung.findID(pn["ID_NV"].ToString());
ChiTietPN rpt = new ChiTietPN();
DataTable CTPN = handle.phieunhap.getTableCTPN(maPN);
rpt.SetDataSource(CTPN);
rpt.SetParameterValue("MaPN", maPN);
rpt.SetParameterValue("HoTen", nguoidung["HOTEN"]);
rpt.SetParameterValue("DienThoai", nguoidung["DIENTHOAI"]);
rpt.SetParameterValue("DiaChi", nguoidung["DIACHI"]);
rpt.SetParameterValue("ThanhToan", CTPN.AsEnumerable().Sum(t => t.Field <Int64>("THANHTIEN")));
rpt.SetParameterValue("NgayXuatHD", pn["NGAYNHAP"]);
crystalReportViewer1.ReportSource = rpt;
crystalReportViewer1.Refresh();
}
}
public IActionResult Post([FromBody] ChiTietPN ctPn)
{
var roweffect = _chiTietPNService.addChiTietPN(ctPn);
//if (roweffect == 400)
// return Created("Thông báo", "Mã hóa đơn đã tồn tại");
return(Ok(roweffect));
}
public void SuaHang(PhieuNhap kh, int thanhtien, ChiTietPN ds)
{
PhieuNhapModel ddb = new PhieuNhapModel();
//kh.NgayNhap = DateTime.Now;
kh.ThanhTien = thanhtien;
ddb.UpdatePN(kh);
ChiTietPNModel cdb = new ChiTietPNModel();
cdb.SuaCTPN(ds);
//int sl = cdb.LaySoluongTheoMaSPN(ma, ds.MaSP);
//SanPhamModel ssp = new SanPhamModel();
//SanPham dss = ssp.LaySanPhamTheoMa(ds.MaSP);
//dss.SoLuongTon += sl;
}
public ActionResult NhapHangDon(PhieuNhap model, ChiTietPN ctpn)
{
ViewBag.MaNCC = new SelectList(db.NhaCungCaps.OrderBy(n => n.TenNCC), "MaNCC", "TenNCC", model.MaNCC);
model.NgayNhap = DateTime.Now;
model.DaXoa = false;
db.PhieuNhaps.Add(model);
db.SaveChanges();
ctpn.MaPN = model.MaPN;
SanPham sp = db.SanPhams.Single(n => n.MaSP == ctpn.MaSP);
sp.SoLuongTon += ctpn.SoLuongNhap;
db.ChiTietPNs.Add(ctpn);
db.SaveChanges();
return(View());
}
public List <ChiTietPN> LayDsPnTheoMa(string ma)
{
dt = db.LayDuLieu("select * from ChiTietPN inner join PhieuNhap on ChiTietPN.MaPhieuNhap = PhieuNhap.MaPhieuNhap where PhieuNhap.MaPhieuNhap='" + ma + "'");
List <ChiTietPN> ds = new List <ChiTietPN>();
foreach (DataRow r in dt.Rows)
{
ChiTietPN l = new ChiTietPN();
l.MaPhieuNhap = Convert.ToString(r[0]);
l.MaSP = Convert.ToString(r[1]);
l.SoLuongNhap = Convert.ToInt32(r[2]);
l.DonGia = Convert.ToInt32(r[3]);
ds.Add(l);
}
return(ds);
}
public ActionResult NhapHang(string mancc, string masp, string ngaynhap, int soluongnhap, int dongia)
{
int tongtien = soluongnhap * dongia;
PhieuNhap sp = new PhieuNhap();
//sp.MaPhieuNhap = mapn;
sp.MaNCC = mancc;
sp.NgayNhap = DateTime.Parse(ngaynhap);
ChiTietPN pn = new ChiTietPN();
pn.MaSP = masp;
pn.SoLuongNhap = soluongnhap;
pn.DonGia = dongia;
NhapHangBus mhb = new NhapHangBus();
mhb.NhaphangDon(sp, tongtien, pn);
ChiTietPNModel pnb = new ChiTietPNModel();
//var ds = ssp.LaySanPham(masp);
//ds.SoLuongTon += soluongnhap;
//ds.NgayCapNhat = DateTime.Parse(ngaynhap);
return(Json(new { success = true, ms = "thanh cong" }, JsonRequestBehavior.AllowGet));
}
public void NhaphangDon(PhieuNhap kh, int thanhtien, ChiTietPN ds)
{
string ngay = DateTime.Now.Year.ToString() + DateTime.Now.Month.ToString() + DateTime.Now.Day.ToString();
PhieuNhapModel ddb = new PhieuNhapModel();
string MHMax = ddb.LayDonHangCungNgay(ngay);
//Xử lý sinh mã hóa đơn theo quy tắc
string ma = SinhMa(MHMax, ngay);
//End
kh.MaPhieuNhap = ma;
//kh.NgayNhap = DateTime.Now;
kh.ThanhTien = thanhtien;
ddb.ThemDonHang(kh);
ChiTietPNModel cdb = new ChiTietPNModel();
ds.MaPhieuNhap = ma;
cdb.LuuCTPN(ds);
int sl = cdb.LaySoluongTheoMaSPN(ma, ds.MaSP);
SanPhamModel ssp = new SanPhamModel();
SanPham dss = ssp.LaySanPhamTheoMa(ds.MaSP);
dss.SoLuongTon += sl;
}
public ChiTietPN LayPnTheoMaSP(string ma)
{
dt = db.LayDuLieu("select cp.MaPhieuNhap,cp.MaSP,cp.SoLuongNhap,cp.DonGia,p.MaNCC,p.NgayNhap,p.ThanhTien from ChiTietPN cp inner join PhieuNhap p on cp.MaPhieuNhap = p.MaPhieuNhap where cp.MaPhieuNhap = '" + ma + "'");
ChiTietPN l = new ChiTietPN();
if (dt.Rows.Count > 0)
{
l.MaPhieuNhap = Convert.ToString(dt.Rows[0][0]);
l.MaSP = Convert.ToString(dt.Rows[0][1]);
l.SoLuongNhap = Convert.ToInt32(dt.Rows[0][2]);
l.DonGia = Convert.ToInt32(dt.Rows[0][3]);
l.PhieuNhap = new PhieuNhap
{
MaNCC = Convert.ToString(dt.Rows[0][4]),
NgayNhap = Convert.ToDateTime(dt.Rows[0][5]),
ThanhTien = Convert.ToInt32(dt.Rows[0][6])
};
}
else
{
l = null;
}
return(l);
}
public int addChiTietPN(ChiTietPN chiTietPN)
{
var roweffect = _dbConnection.Execute($"Insert into ChitietPN values('{chiTietPN.masp}', '{chiTietPN.soluong}')", commandType: CommandType.Text);
return(roweffect);
}
public int addChiTietPN(ChiTietPN chiTietPN)
{
var roweffect = _chiTietPNRepository.addChiTietPN(chiTietPN);
return(roweffect);
}
public void SuaCTPN(ChiTietPN l)
{
string se = "update ChiTietPN set SoLuongNhap='" + l.SoLuongNhap + "',DonGia='" + l.DonGia + "' where MaPhieuNhap='" + l.MaPhieuNhap + "' and MaSP='" + l.MaSP + "'";
db.ExcuteNonQuery(se);
}
public void LuuCTPN(ChiTietPN l)
{
string se = "insert into ChiTietPN values('" + l.MaPhieuNhap + "', '" + l.MaSP + "', '" + l.SoLuongNhap + "', '" + l.DonGia + "')";
db.ExcuteNonQuery(se);
}
public Boolean Update(ChiTietPN l)
{
return(db.ExcuteNonQuery("update ChiTietPN set MaSP='" + l.MaSP + "',SoLuongNhap='" + l.SoLuongNhap + "',DonGia='" + l.DonGia + "' where MaPhieuNhap='" + l.MaPhieuNhap + "'"));
}
public Boolean Insert(ChiTietPN l)
{
return(db.ExcuteNonQuery("insert into ChiTietPN values('" + l.MaPhieuNhap + "','" + l.MaSP + "','" + l.SoLuongNhap + "','" + l.DonGia + "')"));
}
public int updateChiTietPN(ChiTietPN chiTietPN)
{
var roweffect = _dbConnection.Execute($"Update ChiTietPN SET masp = '{chiTietPN.masp}', soluong = '{chiTietPN.soluong}' where mapn = '{chiTietPN.mapn}'", commandType: CommandType.Text);
return(roweffect);
}
public IActionResult Put([FromBody] ChiTietPN chiTietPN)
{
var roweffect = _chiTietPNService.updateChiTietPN(chiTietPN);
return(Ok(roweffect));
}
public int updateChiTietPN(ChiTietPN chiTietPN)
{
var roweffect = _chiTietPNRepository.updateChiTietPN(chiTietPN);
return(roweffect);
}
