public IHttpActionResult PostHT_NGUOI_DUNG(HT_NGUOI_DUNG hT_NGUOI_DUNG) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } db.HT_NGUOI_DUNG.Add(hT_NGUOI_DUNG); try { db.SaveChanges(); } catch (DbUpdateException) { if (HT_NGUOI_DUNGExists(hT_NGUOI_DUNG.USERNAME)) { return(Conflict()); } else { throw; } } return(CreatedAtRoute("DefaultApi", new { id = hT_NGUOI_DUNG.USERNAME }, hT_NGUOI_DUNG)); }
public IHttpActionResult PutHT_NGUOI_DUNG(string id, HT_NGUOI_DUNG hT_NGUOI_DUNG) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != hT_NGUOI_DUNG.USERNAME) { return(BadRequest()); } db.Entry(hT_NGUOI_DUNG).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!HT_NGUOI_DUNGExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
public IHttpActionResult GetHT_NGUOI_DUNG(string id) { HT_NGUOI_DUNG hT_NGUOI_DUNG = db.HT_NGUOI_DUNG.Find(id); if (hT_NGUOI_DUNG == null) { return(NotFound()); } return(Ok(hT_NGUOI_DUNG)); }
public IHttpActionResult PostHT_NGUOI_DUNG(HT_NGUOI_DUNG hT_NGUOI_DUNG) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } db.HT_NGUOI_DUNG.Add(hT_NGUOI_DUNG); db.SaveChanges(); return(CreatedAtRoute("DefaultApi", new { id = hT_NGUOI_DUNG.ID }, hT_NGUOI_DUNG)); }
public void PutHT_NGUOI_DUNG(string id, HT_NGUOI_DUNG hT_NGUOI_DUNG) { var nguoidung = db.HT_NGUOI_DUNG.Where(x => x.USERNAME == id).FirstOrDefault(); if (nguoidung != null) { nguoidung.AVATAR = hT_NGUOI_DUNG.AVATAR; } db.SaveChanges(); }
public IHttpActionResult DeleteHT_NGUOI_DUNG(string id) { HT_NGUOI_DUNG hT_NGUOI_DUNG = db.HT_NGUOI_DUNG.Find(id); if (hT_NGUOI_DUNG == null) { return(NotFound()); } db.HT_NGUOI_DUNG.Remove(hT_NGUOI_DUNG); db.SaveChanges(); return(Ok(hT_NGUOI_DUNG)); }
public ActionResult Lichsu(string id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } HT_NGUOI_DUNG hT_NGUOI_DUNG = db.HT_NGUOI_DUNG.Find(id); if (hT_NGUOI_DUNG == null) { return(HttpNotFound()); } return(View(hT_NGUOI_DUNG)); }
public void PutHT_NGUOI_DUNG(string id, string oldpw, HT_NGUOI_DUNG hT_NGUOI_DUNG) { var nguoidung = db.HT_NGUOI_DUNG.Where(x => x.USERNAME == id).ToList(); if (nguoidung.Count > 0) { var nd = nguoidung.FirstOrDefault(); if (nd.PASSWORD == oldpw) { nd.PASSWORD = hT_NGUOI_DUNG.PASSWORD; } } db.SaveChanges(); }
public ActionResult Details(string id) { using (var db = new ERP_DATABASEEntities()) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } HT_NGUOI_DUNG hT_NGUOI_DUNG = db.HT_NGUOI_DUNG.Find(id); if (hT_NGUOI_DUNG == null) { return(HttpNotFound()); } return(View(hT_NGUOI_DUNG)); } }
public IHttpActionResult PutHT_NGUOI_DUNG(string id, HT_NGUOI_DUNG hT_NGUOI_DUNG) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != hT_NGUOI_DUNG.USERNAME) { return(BadRequest()); } var query = db.HT_NGUOI_DUNG.Where(x => x.USERNAME == id).FirstOrDefault(); query.USERNAME = hT_NGUOI_DUNG.USERNAME; query.PASSWORD = hT_NGUOI_DUNG.PASSWORD; query.HO_VA_TEN = hT_NGUOI_DUNG.HO_VA_TEN; query.SDT = hT_NGUOI_DUNG.SDT; query.EMAIL = hT_NGUOI_DUNG.EMAIL; query.IS_ADMIN = hT_NGUOI_DUNG.IS_ADMIN; query.ALLOWED = hT_NGUOI_DUNG.ALLOWED; query.AVATAR = hT_NGUOI_DUNG.AVATAR; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!HT_NGUOI_DUNGExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
public ActionResult Register(String fullname, string email, string phone, string password, string confirmpassword) { HT_NGUOI_DUNG user = new HT_NGUOI_DUNG(); user.USERNAME = phone; user.HO_VA_TEN = fullname; user.EMAIL = email; user.PASSWORD = password; user.SDT = phone; user.IS_ADMIN = false; user.ALLOWED = false; user.MA_CONG_TY = "KHACH_VANG_LAI"; user.MA_XAC_NHAN = rd.RandomString(10); db.HT_NGUOI_DUNG.Add(user); db.SaveChanges(); ViewBag.info = "Cảm ơn bạn đã đăng ký tài khoản check giá tại Hoplongtech.com <br> Bạn vui lòng kiểm tra email để kích hoạt tài khoản"; MailMessage mm = new MailMessage(); mm.To.Add(new MailAddress(user.EMAIL, "Xác nhận tài khoản check giá tại Hoplongtech.com")); mm.From = new MailAddress("*****@*****.**"); mm.Body = "Dear " + user.HO_VA_TEN + ",<br /> <br /><br />Cảm ơn bạn đã đăng ký tài khoản check giá tại Hoplongtech.com <br /> Để hoàn tất việc đăng ký, bạn vui lòng nhấn vào liên kết bên dưới hoặc copy và dán vào trình duyệt để truy cập trang kích hoạt tài khoản: <br /> <a href='http://*****:*****@gmail.com", "135495706"); smcl.EnableSsl = true; smcl.Send(mm); return(View()); }
public ActionResult Import_Nhanvien(HttpPostedFileBase file) { try { if (Request != null) { HttpPostedFileBase filetonkho = Request.Files["UploadedFile"]; if ((filetonkho != null) && (filetonkho.ContentLength > 0) && !string.IsNullOrEmpty(filetonkho.FileName)) { string fileName = filetonkho.FileName; string fileContentType = filetonkho.ContentType; byte[] fileBytes = new byte[filetonkho.ContentLength]; var data = filetonkho.InputStream.Read(fileBytes, 0, Convert.ToInt32(filetonkho.ContentLength)); //var usersList = new List<Users>(); using (var package = new ExcelPackage(filetonkho.InputStream)) { var currentSheet = package.Workbook.Worksheets; var workSheet = currentSheet.First(); var noOfCol = workSheet.Dimension.End.Column; var noOfRow = workSheet.Dimension.End.Row; for (int rowIterator = 2; rowIterator <= noOfRow; rowIterator++) { HT_NGUOI_DUNG user = new HT_NGUOI_DUNG(); user.USERNAME = workSheet.Cells[rowIterator, 2].Value.ToString(); user.PASSWORD = workSheet.Cells[rowIterator, 3].Value.ToString(); user.HO_VA_TEN = workSheet.Cells[rowIterator, 1].Value.ToString(); if (workSheet.Cells[rowIterator, 6].Value != null) { user.SDT = workSheet.Cells[rowIterator, 6].Value.ToString(); } if (workSheet.Cells[rowIterator, 7].Value != null) { user.EMAIL = workSheet.Cells[rowIterator, 7].Value.ToString(); } if (workSheet.Cells[rowIterator, 10].Value != null) { user.AVATAR = workSheet.Cells[rowIterator, 10].Value.ToString(); } if (workSheet.Cells[rowIterator, 13].Value != null) { user.IS_ADMIN = Convert.ToBoolean(workSheet.Cells[rowIterator, 13].Value); } user.ALLOWED = Convert.ToBoolean(workSheet.Cells[rowIterator, 14].Value); user.MA_CONG_TY = workSheet.Cells[rowIterator, 12].Value.ToString(); db.HT_NGUOI_DUNG.Add(user); CCTC_NHAN_VIEN nhanvien = new CCTC_NHAN_VIEN(); nhanvien.USERNAME = workSheet.Cells[rowIterator, 2].Value.ToString(); if (workSheet.Cells[rowIterator, 5].Value != null) { nhanvien.GIOI_TINH = workSheet.Cells[rowIterator, 5].Value.ToString(); } if (workSheet.Cells[rowIterator, 4].Value != null) { nhanvien.NGAY_SINH = xulydate.Xulydatetime(workSheet.Cells[rowIterator, 4].Value.ToString()); } if (workSheet.Cells[rowIterator, 8].Value != null) { nhanvien.QUE_QUAN = workSheet.Cells[rowIterator, 8].Value.ToString(); } if (workSheet.Cells[rowIterator, 9].Value != null) { nhanvien.TRINH_DO_HOC_VAN = workSheet.Cells[rowIterator, 9].Value.ToString(); } if (workSheet.Cells[rowIterator, 11].Value != null) { nhanvien.MA_PHONG_BAN = workSheet.Cells[rowIterator, 11].Value.ToString(); } db.CCTC_NHAN_VIEN.Add(nhanvien); db.SaveChanges(); so_dong_thanh_cong++; dong = rowIterator - 1; } } } } } catch (Exception Ex) { ViewBag.Error = " Đã xảy ra lỗi, Liên hệ ngay với admin. " + Environment.NewLine + " Thông tin chi tiết về lỗi:" + Environment.NewLine + Ex; ViewBag.Information = "Lỗi tại dòng thứ: " + dong; } finally { ViewBag.Message = "Đã import thành công " + so_dong_thanh_cong + " dòng"; } return(View("Index")); }