public ActionResult EditAccount()
{
try
{
var account = Request["account"];
var j_account = JObject.Parse(account);
using (FinalProjectEntities db = new FinalProjectEntities())
{
var u_account = db.Users.Find(Convert.ToInt32(j_account.GetValue("id")));
if (u_account != null)
{
u_account.Password = j_account.GetValue("password").ToString();
u_account.Name = j_account.GetValue("name").ToString();
u_account.Email = j_account.GetValue("email").ToString();
u_account.CV_Link = j_account.GetValue("cv_link").ToString();
u_account.RoleID = Convert.ToInt32(j_account.GetValue("role_id").ToString());
db.SaveChanges();
return(Json(new { success = true, title = "Thành công", message = "Cập nhật tài khoản thành công." }));
}
else
{
return(Json(new { success = false, title = "Lỗi", message = "Cập nhật tài khoản lỗi." }));
}
}
}
catch (Exception e)
{
return(Json(new { error = true, message = "Có lỗi xảy ra." }));
}
}
public ActionResult getAccountByID()
{
try
{
var user_id = Request["user_id"];
using (FinalProjectEntities db = new FinalProjectEntities())
{
var mySql = @"select
u.*,
us.Name as 'RoleName'
from [User] u join User_roles us on u.RoleID = us.ID
where u.ID = @user_id" ;
var accountByID = db.Database.SqlQuery <Account>(mySql, new SqlParameter("@user_id", user_id)).FirstOrDefault();
if (accountByID != null)
{
return(Json(new { success = true, accountByID = accountByID }));
}
else
{
return(Json(new { success = false, title = "Lỗi", message = "Lấy dữ liệu tài khoản gặp lỗi." }));
}
}
}
catch (Exception e)
{
return(Json(new { error = true, message = "Có lỗi xảy ra." }));
}
}
//
// GET: /Dashboard/
public JsonResult ReportUnitData1(int date, int month, int year)
{
FinalProjectEntities data = new FinalProjectEntities();
var timestamp = DateTime.Now;
string[] array = //Data Fine1
{
"PV(FIC-071)", "PV(FIC-072)", "SFU07",
//Data Fine2
"PV(FIC-181)", "SFU18",
//Data Fine3
"SFU16", "SIFU16",
//Data CEX
"PV(FIC-051)", "PV(FIC-052)", "SFU05",
//Data PEX1
"PV(FIC-091)", "WAFU09", "SFU09",
//Data PEX2
"PV(FIC-111)", "WAFU11", "SFU11",
//Data PEX3
"SFU12", "PIFU12"
};
var v = from a in data.HistoryDatas
where a.gettime.Day == date && a.gettime.Month == month && a.gettime.Year == year &&
array.Contains(a.parameter)
orderby a.gettime ascending
select a;
var jsonResult = Json(v, JsonRequestBehavior.AllowGet);
jsonResult.MaxJsonLength = Int32.MaxValue;
return(jsonResult);
}
private string AddFilterOfIdNumber(string command, string idNumber, out bool isCondition)
{
employee currentEmployee;
int employeeNumber;
if (idNumber.Length < 6 || idNumber.Length > 9 || Regex.IsMatch(idNumber, @"^[0-9]+$") == false)
{
isCondition = false;
return(command);
}
using (var DB = new FinalProjectEntities())
{
currentEmployee = DB.employees.Where(x => x.employeeId == idNumber).FirstOrDefault();
if (currentEmployee is employee)
{
employeeNumber = currentEmployee.employeeNumber;
}
else
{
isCondition = false;
return(command);
}
}
command += " where a.employeeNumber = " + employeeNumber;
isCondition = true;
return(command);
}
public JsonResult ReportUnitData3(int date, int month, int year)
{
FinalProjectEntities data = new FinalProjectEntities();
var timestamp = DateTime.Now;
string[] array =
{
//Data Dewatering
"PV(FIC-251)", "SFU25",
//Data Drying
"SFU26", "SIFU26",
//Data Packaging
"CPFU29", "CPOFU29","CPIFU29",
//Data computing
"CIFU01", "WAFU02", "W2FEXU02", "SOFU01",
//Material consumption
"SUFU8", "WFU12", "WFU22", "PV(FIC-152)", "WIFU20"
};
var v = from a in data.HistoryDatas
where a.gettime.Day == date && a.gettime.Month == month && a.gettime.Year == year &&
array.Contains(a.parameter)
orderby a.gettime ascending
select a;
var jsonResult = Json(v, JsonRequestBehavior.AllowGet);
jsonResult.MaxJsonLength = Int32.MaxValue;
return(jsonResult);
}
public ActionResult ApplyDone()
{
FinalProjectEntities db = new FinalProjectEntities();
String cv = Request["real"];
if (cv == null || cv.Equals(""))
{
String job_id = Request["jobid"];
int jobid = Convert.ToInt32(job_id);
User u = Session["account"] as User;
ViewBag.jobid = jobid;
ViewBag.name = u.Name;
ViewData["Notification"] = "Bạn phải upload CV file";
return(View("~/Views/JobSeeker/Apply.cshtml"));
}
else
{
String job_id = Request["jobid"];
int jobid = Convert.ToInt32(job_id);
User u = Session["account"] as User;
int jskid = u.ID;
User_Job uj = new User_Job();
uj.CV = cv;
uj.JobID = jobid;
uj.JskID = jskid;
db.User_Job.Add(uj);
db.SaveChanges();
ViewBag.name = u.Name;
ViewBag.jobid = jobid;
return(Redirect("/OnlineJobSearching/Jobseeker/Index"));
}
}
public ActionResult AddAccount()
{
try
{
var username = Request["username"];
var password = Request["password"];
using (FinalProjectEntities db = new FinalProjectEntities())
{
var duplicateUser = db.Users.Where(s => s.Username == username).FirstOrDefault();
if (duplicateUser == null)
{
User us = new User();
us.Username = username;
us.Password = password;
us.RoleID = 2;
db.Users.Add(us);
db.SaveChanges();
return(Json(new { success = true, title = "Thành công", message = "Thêm tài khoản thành công." }));
}
else
{
return(Json(new { success = false, title = "Lỗi", message = "Tên tài khoản đã có, hãy chọn tên tài khoản khác." }));
}
}
}
catch (Exception e)
{
return(Json(new { error = true, message = "Có lỗi xảy ra." }));
}
}
public JsonResult ReportUnitData2(int date, int month, int year)
{
FinalProjectEntities data = new FinalProjectEntities();
var timestamp = DateTime.Now;
string[] array =
{
//Data BeltPulp
"CEX04INU12", "POFU12",
//Data SEP0
"SFU21", "WAIFU21",
//Data SEP1
"PV(FIC-151)", "SLFU15",
//Data SEP2
"PV(FIC-201)", "SFU20",
//Data SEP3
"PV(FIC-231)", "SFU23", "WAFU23",
};
var v = from a in data.HistoryDatas
where a.gettime.Day == date && a.gettime.Month == month && a.gettime.Year == year &&
array.Contains(a.parameter)
orderby a.gettime ascending
select a;
var jsonResult = Json(v, JsonRequestBehavior.AllowGet);
jsonResult.MaxJsonLength = Int32.MaxValue;
return(jsonResult);
}
public ActionResult DeleteAccount()
{
try
{
var user_id = Request["user_id"];
using (FinalProjectEntities db = new FinalProjectEntities())
{
var account = db.Users.Find(Convert.ToInt32(user_id));
if (account != null)
{
db.Users.Remove(account);
db.SaveChanges();
return(Json(new { success = true, title = "Thành công", message = "Xóa tài khoản thành công." }));
}
else
{
return(Json(new { success = true, title = "Lỗi", message = "Không tìm thấy tài khoản cần xóa." }));
}
}
}
catch (Exception e)
{
return(Json(new { error = true, message = "Có lỗi xảy ra." }));
}
}
public async Task <ActionResult> Register(RegisterViewModel model)
{
if (ModelState.IsValid)
{
var user = new ApplicationUser {
UserName = model.Email, Email = model.Email
};
var result = await UserManager.CreateAsync(user, model.Password);
if (result.Succeeded)
{
#region Dealing with custom user details
UserDetail newUserDeets = new UserDetail();
newUserDeets.UserId = user.Id;
newUserDeets.FirstName = model.FirstName;
newUserDeets.LastName = model.LastName;
//--TODO: handle file upload
FinalProjectEntities db = new FinalProjectEntities(); db.UserDetails.Add(newUserDeets); db.SaveChanges();
#endregion
var code = await UserManager.GenerateEmailConfirmationTokenAsync(user.Id);
return(RedirectToAction("Login"));
}
AddErrors(result);
}
// If we got this far, something failed, redisplay form
return(View(model));
}
public ActionResult ChangePassDone()
{
User u = Session["account"] as User;
String pass = Request["password"];
String newpass = Request["newpass"];
String repass = Request["renew"];
FinalProjectEntities db = new FinalProjectEntities();
if (!u.Password.Equals(pass))
{
ViewBag.user = u;
ViewBag.name = u.Name;
ViewData["Notification"] = "Mật khẩu không đúng";
return(View("~/Views/JobSeeker/ChangePass.cshtml"));
}
else if (!newpass.Equals(repass))
{
ViewBag.user = u;
ViewBag.name = u.Name;
ViewData["Notification"] = "Mật khẩu không khớp";
return(View("~/Views/JobSeeker/ChangePass.cshtml"));
}
else
{
User user = db.Users.Find(u.ID);
user.Password = newpass;
db.SaveChanges();
ViewData["Notification"] = "Cập nhật thành công";
ViewBag.user = u;
ViewBag.name = u.Name;
return(View("~/Views/JobSeeker/Info.cshtml"));
}
}
public async Task <ActionResult> Register(RegisterViewModel model)
{
if (ModelState.IsValid)
{
var user = new ApplicationUser {
UserName = model.Email, Email = model.Email
};
var result = await UserManager.CreateAsync(user, model.Password);
if (result.Succeeded)
{
Employee newEmp = new Employee();
newEmp.UserID = user.Id;
newEmp.FirstName = model.FirstName;
newEmp.LastName = model.LastName;
FinalProjectEntities db = new FinalProjectEntities();
db.Employees.Add(newEmp);
db.SaveChanges();
var code = await UserManager.GenerateEmailConfirmationTokenAsync(user.Id);
var callbackUrl = Url.Action("ConfirmEmail", "Account", new { userId = user.Id, code = code }, protocol: Request.Url.Scheme);
await UserManager.SendEmailAsync(user.Id, "Confirm your account", "Please confirm your account by clicking this link: <a href=\"" + callbackUrl + "\">link</a>");
ViewBag.Link = callbackUrl;
return(View("DisplayEmail"));
}
AddErrors(result);
}
// If we got this far, something failed, redisplay form
return(View(model));
}
public void CreatePerson(BusinessLayer.PersonLibrary person)
{
using (databases = new FinalProjectEntities())
{
var databasePerson = Mapping.ToPersonEntity(person);
databases.PersonLibrary.Add(databasePerson);
databases.SaveChanges();
}
}
public void CreateAuthor(BusinessLayer.AuthorLibrary author)
{
using (databases = new FinalProjectEntities())
{
var databaseAuthor = Mapping.ToAuthorEntity(author);
databases.AuthorLibrary.Add(databaseAuthor);
databases.SaveChanges();
}
}
public void CreateBook(BusinessLayer.BookLibrary book)
{
using (databases = new FinalProjectEntities())
{
var databaseBook = Mapping.ToBookEntity(book);
databases.BookLibrary.Add(databaseBook);
databases.SaveChanges();
}
}
public ActionResult JobSeekerManagement()
{
//get list Role
using (FinalProjectEntities db = new FinalProjectEntities())
{
var listRole = db.User_roles.ToList();
ViewBag.user = (User)Session["account"];
ViewBag.listRole = listRole;
}
return(View("~/Views/Admin/JobSeeker/ListJobSeeker.cshtml"));
}
public ActionResult ListJobSeeker()
{
try
{
//params
string username_filter = Request["username_filter"];
int start = Convert.ToInt32(Request["start"]);
int length = Convert.ToInt32(Request["length"]);
string searchValue = Request["search[value]"];
string sortColumnName = Request["columns[" + Request["order[0][column]"] + "][name]"];
string sortDirection = Request["order[0][dir]"];
var mySql = "";
if (username_filter == null || username_filter == "")
{
mySql = @"select
u.ID,
u.Username,
u.Name,
u.Email,
us.Name as 'RoleName'
from [User] u join User_roles us on u.RoleID = us.ID
order by " + sortColumnName + " " + sortDirection + " OFFSET " + start + " ROWS FETCH NEXT " + length + " ROWS ONLY";
}
else
{
mySql = @"select
u.ID,
u.Username,
u.Name,
u.Email,
us.Name as 'RoleName'
from [User] u join User_roles us on u.RoleID = us.ID
where Username = @username_filter
order by " + sortColumnName + " " + sortDirection + " OFFSET " + start + " ROWS FETCH NEXT " + length + " ROWS ONLY";
}
using (FinalProjectEntities db = new FinalProjectEntities())
{
var listAccount = (username_filter == null || username_filter == "")
? db.Database.SqlQuery <Account>(mySql).ToList()
: db.Database.SqlQuery <Account>(mySql, new SqlParameter("@username_filter", username_filter)).ToList();
int totalrows = listAccount.Count();
int totalrowsafterfiltering = totalrows;
return(Json(new { recordsTotal = totalrows, recordsFiltered = totalrowsafterfiltering, listAccount = listAccount }));
}
}
catch (Exception e)
{
return(View("~/Views/Error.cshtml"));
}
}
public BusinessLayer.AuthorLibrary GetAuthor(int id)
{
using (databases = new FinalProjectEntities())
{
var author = databases.AuthorLibrary.FirstOrDefault(x => x.id == id);
if (author != null)
{
return(Mapping.ToBussinessAuthor(author));
}
return(null);
}
}
public void DeleteBook(int UniqueID)
{
using (databases = new FinalProjectEntities())
{
var book = databases.BookLibrary.FirstOrDefault(x => x.UniqueID == UniqueID);
if (book != null)
{
databases.BookLibrary.Remove(book);
}
databases.SaveChanges();
}
}
public void DeleteAuthor(int id)
{
using (databases = new FinalProjectEntities())
{
var author = databases.AuthorLibrary.FirstOrDefault(x => x.id == id);
if (author != null)
{
databases.AuthorLibrary.Remove(author);
}
databases.SaveChanges();
}
}
public BusinessLayer.BookLibrary GetBook(int UniqueID)
{
using (databases = new FinalProjectEntities())
{
var book = databases.BookLibrary.FirstOrDefault(x => x.UniqueID == UniqueID);
if (book != null)
{
return(Mapping.ToBusinessBook(book));
}
return(null);
}
}
public BusinessLayer.PersonLibrary GetPerson(int id)
{
using (databases = new FinalProjectEntities())
{
var person = databases.PersonLibrary.FirstOrDefault(x => x.id == id);
if (person != null)
{
return(Mapping.ToBussinessPerson(person));
}
return(null);
}
}
public void DeletePerson(int id)
{
using (databases = new FinalProjectEntities())
{
var person = databases.PersonLibrary.FirstOrDefault(x => x.id == id);
if (person != null)
{
databases.PersonLibrary.Remove(person);
}
databases.SaveChanges();
}
}
public JsonResult DataFine2(string valueS)
{
FinalProjectEntities data = new FinalProjectEntities();
string[] array = { "PV(FIC-181)", "SFU18", "PFU18" };
var v = from a in data.CurrentDatas
where array.Contains(a.parameter)
select a;
var jsonResult = Json(v, JsonRequestBehavior.AllowGet);
return(jsonResult);
}
public JsonResult DataPackagingHistory()
{
FinalProjectEntities data = new FinalProjectEntities();
string[] array = { "CPFU29", "CPOFU29", "CPIFU29" };
var v = from a in data.HistoryDatas
where array.Contains(a.parameter)
orderby a.gettime ascending
select a;
var jsonResult = Json(v, JsonRequestBehavior.AllowGet);
return(jsonResult);
}
public JsonResult DataPackaging(string valueS)
{
FinalProjectEntities data = new FinalProjectEntities();
string[] array = { "CPFU29", "CPOFU29", "CPIFU29" };
var v = from a in data.CurrentDatas
where array.Contains(a.parameter)
select a;
var jsonResult = Json(v, JsonRequestBehavior.AllowGet);
return(jsonResult);
}
public JsonResult DataMaterialPreparation()
{
FinalProjectEntities data = new FinalProjectEntities();
string[] array = { "CIFU01", "SOFU01", "WAFU02", "W2FEXU02" };
var v = from a in data.HistoryDatas
where array.Contains(a.parameter)
select a;
var jsonResult = Json(v, JsonRequestBehavior.AllowGet);
return(jsonResult);
}
public JsonResult DataSeperator3History()
{
FinalProjectEntities data = new FinalProjectEntities();
string[] array = { "PV(FIC-231)", "SFU23", "WAFU23", "WFU22" };
var v = from a in data.HistoryDatas
where array.Contains(a.parameter)
orderby a.gettime ascending
select a;
var jsonResult = Json(v, JsonRequestBehavior.AllowGet);
return(jsonResult);
}
public JsonResult DataSeperator0(string valueS)
{
FinalProjectEntities data = new FinalProjectEntities();
string[] array = { "SFU21", "WAFU21", "WAIFU21" };
var v = from a in data.CurrentDatas
where array.Contains(a.parameter)
select a;
var jsonResult = Json(v, JsonRequestBehavior.AllowGet);
return(jsonResult);
}
public JsonResult DataBeltPulpHistory()
{
FinalProjectEntities data = new FinalProjectEntities();
string[] array = { "CEX04INU12", "POFU12", "WAFU12" };
var v = from a in data.HistoryDatas
where array.Contains(a.parameter)
orderby a.gettime ascending
select a;
var jsonResult = Json(v, JsonRequestBehavior.AllowGet);
return(jsonResult);
}
