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"));
}
