// DELETE api/<controller>/5
public void Delete(int id)
{
QuanLyKhoHang obj = db.QuanLyKhoHangs.Where(o => o.Id == id).SingleOrDefault();
db.QuanLyKhoHangs.DeleteOnSubmit(obj);
db.SubmitChanges();
}
// PUT api/<controller>/5
public void Put(int id, [FromBody] QuanLyKhoHang value)
{
QuanLyKhoHang obj = db.QuanLyKhoHangs.Where(o => o.Id == id).SingleOrDefault();
QuanLyKhoHang newobj = value;// JsonConvert.DeserializeObject<QuanLyKhoHang>(value);
if (newobj.TinhTrang != null)
{
obj.TinhTrang = newobj.TinhTrang;
}
if (newobj.TenKho != null)
{
obj.TenKho = newobj.TenKho;
}
if (newobj.GhiChu != null)
{
obj.GhiChu = newobj.GhiChu;
}
if (newobj.DiaChiKhoHang != null)
{
obj.DiaChiKhoHang = newobj.DiaChiKhoHang;
}
if (newobj.CapKho != null)
{
obj.CapKho = newobj.CapKho;
}
db.SubmitChanges();
}
public IEnumerable <QuanLyKhoHang> Get()
{
string filter = HttpContext.Current.Request.Params.Get("filter");
if (string.IsNullOrEmpty(filter))
{
List <QuanLyKhoHang> lst = (from table in db.QuanLyKhoHangs
select table).ToList();
return(lst);
//string json = JsonConvert.SerializeObject(lst);
//return new string[] { json };
}
else
{
QuanLyKhoHang obj = JsonConvert.DeserializeObject <QuanLyKhoHang>(filter);
List <QuanLyKhoHang> lst = (from table in db.QuanLyKhoHangs
where
(obj.CapKho == null || obj.CapKho == table.CapKho) &&
(obj.DiaChiKhoHang == null || obj.DiaChiKhoHang == table.DiaChiKhoHang) &&
(obj.TenKho == null || obj.TenKho == table.TenKho) &&
(obj.TinhTrang == null || obj.TinhTrang == table.TinhTrang)
select table).ToList();
return(lst);
//string json = JsonConvert.SerializeObject(lst);
//return new string[] { json };
}
}
public bool ChinhSua(QuanLyKhoHang entity)
{
try
{
var nhom = db.QuanLyKhoHangs.Find(entity.STT);
nhom.MaNguoiDung = entity.MaNguoiDung;
nhom.NgayPhan = entity.NgayPhan;
db.SaveChanges();
return(true);
}
catch (Exception)
{
return(false);
}
}
public ActionResult CapNhat(QuanLyKhoHang qh)
{
qh.NgayPhan = DateTime.Now;
var dao = new QuanLyKhoHangDao();
var cq = dao.ChinhSua(qh);
if (cq == true)
{
SetAlert("Cap nhat thanh cong", "success");
return(RedirectToAction("Index", "QuanLyKhoHang"));
}
else
{
return(RedirectToAction("CapNhat", "QuanLyKhoHang"));
}
}
public ActionResult ThemMoi(QuanLyKhoHang ql)
{
if (ql.MaNguoiDung != null)
{
ql.NgayPhan = DateTime.Now;
var dao = new QuanLyKhoHangDao();
var id = dao.ThemMoi(ql);
if (id > 0)
{
SetAlert("Thêm quyền thành công", "success");
return(RedirectToAction("Index", "QuanLyKhoHang"));
}
else
{
return(RedirectToAction("ThemMoi", "QuanLyKhoHang"));
}
}
SetAlert("Chưa chọn người quản lý", "error");
return(RedirectToAction("ThemMoi", "QuanLyKhoHang"));
}
private bool ExportData(QuanLyKhoHang ql)
{
bool result = false;
try
{
//String fileName = Server.MapPath("/") + "export\\XuatHang_" + DateTime.Now.ToString("hh:mm:ss_ddMMyy") + ".xlsx";
ExcelPackage pck = new ExcelPackage();
var ws = pck.Workbook.Worksheets.Add("Danh sách xuất hàng ngày "
+ DateTime.Now.ToString("hh:mm:ss_ddMMyy"));//Student sheet
var sessionCart = (List <CartItem>)Session[CartSesstion];
//var lathongtin = Session[CommonConstants.MaND_SESSTION];
//var mand = Convert.ToString(lathongtin);
//string maNguoiDung = mand;
//var kq = new NguoiDungDao().ViewDentail(maNguoiDung);
var student = sessionCart;
int startRow = 1;
foreach (var item in student)
{
if (startRow == 1)
{
ws.Cells[startRow, 1].Value = "Người xuất hàng";
ws.Cells[startRow, 2].Value = ql.DanhSachNguoiDung.TenNguoiDung + " (" + ql.MaNguoiDung + ")";
ws.Cells[startRow + 1, 1].Value = "Ngày Xuất";
ws.Cells[startRow + 1, 2].Value = DateTime.Now.ToString("dd_MM_yyy");
startRow = startRow + 3;
}
if (startRow == 4)
{
ws.Cells[startRow, 1].Value = "Mã Hàng";
ws.Cells[startRow, 2].Value = "Tên Hàng";
ws.Cells[startRow, 3].Value = "Số lượng";
ws.Cells[startRow, 4].Value = "Đơn giá";
ws.Cells[startRow, 5].Value = "Thành tiền";
startRow++;
}
if (startRow > 4)
{
ws.Cells[startRow, 1].Value = item.Hang_Hoa.MaHang;
ws.Cells[startRow, 2].Value = item.Hang_Hoa.TenHang;
ws.Cells[startRow, 3].Value = item.SoLuong;
ws.Cells[startRow, 4].Value = item.Hang_Hoa.DonGia;
ws.Cells[startRow, 5].Value = (item.Hang_Hoa.DonGia * item.SoLuong);
startRow++;
}
}
ws.Cells[startRow + 1, 4].Value = "Tổng tiền: ";
ws.Cells[startRow + 1, 5].Value = Sum();
Response.Clear();
Response.ContentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet";
Response.AddHeader("content-disposition", "attachment: filename=" + "ExcelReport.xlsx");
Response.BinaryWrite(pck.GetAsByteArray());
Response.End();
return(result = true);
}
catch (Exception ex)
{
}
return(result);
}
public int ThemMoi(QuanLyKhoHang ma)
{
db.QuanLyKhoHangs.Add(ma);
db.SaveChanges();
return(ma.STT);
}
// POST api/<controller>
public void Post([FromBody] QuanLyKhoHang value)
{
//QuanLyKhoHang newobj = (QuanLyKhoHang)JsonConvert.DeserializeObject(value);
db.QuanLyKhoHangs.InsertOnSubmit(value);
db.SubmitChanges();
}
