public IHttpActionResult PutCaiDat(int id, CaiDat caiDat)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != caiDat.MaCD)
{
return(BadRequest());
}
db.Entry(caiDat).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!CaiDatExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
private void btnCaiDat_Click(object sender, EventArgs e)
{
panelContainer.Controls.Clear();
CaiDat uc = new CaiDat();
uc.Dock = DockStyle.Fill;
panelContainer.Controls.Add(uc);
}
public ActionResult SuaCaiDat(CaiDat cd, HttpPostedFileBase file, string img)
{
if (Session["MaTKAdmin"] == null)
{
return(RedirectToAction("Login", "Admin"));
}
else
{
ShopEntities shop = new ShopEntities();
var caiDat = shop.CaiDats.SingleOrDefault(c => c.Id == 1);
file = file ?? Request.Files["file"];
if (file != null && file.ContentLength > 0)
{
var fileName = Path.GetFileName(file.FileName);
if (fileName != null)
{
var path = Path.Combine(Server.MapPath("~/Images/"), fileName);
file.SaveAs(path);
caiDat.Logo = "/Images/" + fileName;
caiDat.GioLamViec = cd.GioLamViec;
caiDat.GiaoHang = cd.GiaoHang;
caiDat.HoanTien = cd.HoanTien;
caiDat.SDTLienHe = cd.SDTLienHe;
caiDat.EmailLienHe = cd.EmailLienHe;
caiDat.FaceBook = cd.FaceBook;
caiDat.GooglePlus = cd.GooglePlus;
caiDat.Twiter = cd.Twiter;
caiDat.YouTube = cd.YouTube;
caiDat.Instargram = cd.Instargram;
caiDat.GoogleMap = cd.GoogleMap;
caiDat.MatKhauMail = cd.MatKhauMail;
shop.SaveChanges();
}
}
else
{
caiDat.Logo = img;
caiDat.GioLamViec = cd.GioLamViec;
caiDat.GiaoHang = cd.GiaoHang;
caiDat.HoanTien = cd.HoanTien;
caiDat.SDTLienHe = cd.SDTLienHe;
caiDat.EmailLienHe = cd.EmailLienHe;
caiDat.FaceBook = cd.FaceBook;
caiDat.GooglePlus = cd.GooglePlus;
caiDat.Twiter = cd.Twiter;
caiDat.YouTube = cd.YouTube;
caiDat.Instargram = cd.Instargram;
caiDat.GoogleMap = cd.GoogleMap;
caiDat.MatKhauMail = cd.MatKhauMail;
shop.SaveChanges();
}
var model = shop.CaiDats.ToList().Single();
return(View("HeThong", model));
}
}
public IHttpActionResult GetCaiDat(int id)
{
CaiDat caiDat = db.CaiDats.Find(id);
if (caiDat == null)
{
return(NotFound());
}
return(Ok(caiDat));
}
public IHttpActionResult PostCaiDat(CaiDat caiDat)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.CaiDats.Add(caiDat);
db.SaveChanges();
return(CreatedAtRoute("DefaultApi", new { id = caiDat.MaCD }, caiDat));
}
public IHttpActionResult DeleteCaiDat(int id)
{
CaiDat caiDat = db.CaiDats.Find(id);
if (caiDat == null)
{
return(NotFound());
}
db.CaiDats.Remove(caiDat);
db.SaveChanges();
return(Ok(caiDat));
}
//Dùng trong Index
public ActionResult PV_ThongKeThucDon()
{
int month = 1;
int year = 2018;
ViewBag.Month = month;
ViewBag.Year = year;
CaiDat config = data.CaiDats.SingleOrDefault(i => i.TenThamSo.Equals("top_thuc_don_take"));
int take = Convert.ToInt32(config.GiaTri);
ViewBag.Take = take;
List <V_ThongKeThucDon> all = data.V_ThongKeThucDons.Where(i => i.Thang == month && i.Nam == year).OrderByDescending(i => i.TongSoLuong).Take(take).ToList();
string list_labels = "[";
foreach (V_ThongKeThucDon item in all)
{
if (all.IndexOf(item) == all.Count - 1)
{
list_labels += "'" + item.TenThucDon + "'";
}
else
{
list_labels += "'" + item.TenThucDon + "'" + ",";
}
}
list_labels += "]";
ViewBag.List_labels = list_labels;
string list_data = "[";
foreach (V_ThongKeThucDon item in all)
{
if (all.IndexOf(item) == all.Count - 1)
{
list_data += "" + item.TongSoLuong + "";
}
else
{
list_data += "" + item.TongSoLuong + "" + ",";
}
}
list_data += "]";
ViewBag.List_data = list_data;
return(PartialView(all));
}
//Dùng trong Index
public ActionResult PV_ThongKeUser()
{
int month = 7;
int year = 2019;
ViewBag.Month = month;
ViewBag.Year = year;
CaiDat config = data.CaiDats.SingleOrDefault(i => i.TenThamSo.Equals("top_tai_khoan_take"));
int take = Convert.ToInt32(config.GiaTri);
ViewBag.Take = take;
List <V_ThongKeUser> all = data.V_ThongKeUsers.Where(i => i.Thang == month && i.Nam == year).OrderByDescending(i => i.TongThanhTien).Take(take).ToList();
string list_labels = "[";
foreach (V_ThongKeUser item in all)
{
if (all.IndexOf(item) == all.Count - 1)
{
list_labels += "'" + item.Username + "'";
}
else
{
list_labels += "'" + item.Username + "'" + ",";
}
}
list_labels += "]";
ViewBag.List_labels = list_labels;
string list_data_TongThanhTien = "[";
foreach (V_ThongKeUser item in all)
{
if (all.IndexOf(item) == all.Count - 1)
{
list_data_TongThanhTien += "" + item.TongThanhTien + "";
}
else
{
list_data_TongThanhTien += "" + item.TongThanhTien + "" + ",";
}
}
list_data_TongThanhTien += "]";
ViewBag.List_data_TongThanhTien = list_data_TongThanhTien;
return(PartialView(all));
}
public ActionResult PV_Header()
{
CaiDat logo = data.CaiDats.SingleOrDefault(i => i.TenThamSo.Equals("hinh_logo"));
ViewBag.UrlLogo = Url.Content("~/Images/LogoBanner/" + logo.GiaTri);
string[] banners = { "hinh_banner_1", "hinh_banner_2", "hinh_banner_3" };
foreach (string sbanner in banners)
{
CaiDat banner = data.CaiDats.SingleOrDefault(i => i.TenThamSo.Equals(sbanner));
ViewData["Url_" + sbanner] = Url.Content("~/Images/LogoBanner/" + banner.GiaTri);
}
return(PartialView());
}
public async Task <CaiDat> UpdateById(int id, CaiDatForUpdateDto caiDat)
{
var oldRecord = await _context.DanhSachCaiDat.AsNoTracking().FirstOrDefaultAsync();
var caiDatToUpdate = new CaiDat
{
MaCaiDat = id,
TenDonViChuQuan = caiDat.TenDonViChuQuan,
TenKhoa = caiDat.TenKhoa,
ThoiGianTao = oldRecord.ThoiGianTao,
ThoiGianCapNhat = DateTime.Now,
TrangThai = caiDat.TrangThai
};
_context.DanhSachCaiDat.Update(caiDatToUpdate);
await _context.SaveChangesAsync();
return(caiDatToUpdate);
}
public async Task <CaiDat> UpdateById(string id, CaiDatForUpdateDto caiDat)
{
var oldRecord = await _context.DanhSachCaiDat.AsNoTracking().FirstOrDefaultAsync();
var caiDatToUpdate = new CaiDat
{
MaCaiDat = oldRecord.MaCaiDat,
TenSanBong = caiDat.TenSanBong,
DiaChi = caiDat.DiaChi,
SoDienThoai = caiDat.SoDienThoai,
Fax = caiDat.Fax,
DiaChiTrenPhieu = caiDat.DiaChiTrenPhieu,
ThoiGianTao = oldRecord.ThoiGianTao,
ThoiGianCapNhat = DateTime.Now,
TrangThai = caiDat.TrangThai
};
_context.DanhSachCaiDat.Update(caiDatToUpdate);
await _context.SaveChangesAsync();
return(caiDatToUpdate);
}
