//Xóa 1 bài học
public int DeleteTask(int id)
{
WebDatabaseEntities database = new WebDatabaseEntities();
Company company = new Company();
if (company.DeleteListQuestion(id) == true && company.DeleteListIntershipWithTask(id, 0) == true)
{
database.Task.Remove(database.Task.Find(id));
database.SaveChanges();
return(1);
}
else
{
if (company.DeleteListQuestion(id) == false)
{
return(2);
}
else
{
if (company.DeleteListIntershipWithTask(id, 0) == false)
{
return(3);
}
else
{
return(4);
}
}
}
}
public ActionResult cvOrgan(string id)
{
WebDatabaseEntities database = new WebDatabaseEntities();
var model = database.Organization.SingleOrDefault(x => x.ID == id);
return(View(model));
}
public ActionResult Edit(int id)
{
WebDatabaseEntities database = new WebDatabaseEntities();
var model = database.Task.Find(id);
return(View(model));
}
public ActionResult PasswordRetrieval(RestartPassword restart)
{
if (ModelState.IsValid)
{
WebDatabaseEntities database = new WebDatabaseEntities();
// Kiểm tra Object User có tồn tại hay không
var model = database.Users.Find(restart.UserName);
if (model == null)
{
ModelState.AddModelError("", "UserName không tồn tại");
}
else
{
var findPer = database.Person.Find(model.PersonID);
if (findPer.Email == restart.Email)
{
var newPass = new Share().RandomText();
if (SendPass(findPer.PersonID, newPass))
{
UpdateUser(findPer.PersonID, newPass);
}
else
{
ModelState.AddModelError("", "Lỗi gửi Email");
}
}
else
{
ModelState.AddModelError("", "Email không chính xác!");
}
}
}
return(View("PasswordRetrieval"));
}
public ActionResult CreateUser(Users user)
{
WebDatabaseEntities database = new WebDatabaseEntities();
var findU = database.Users.Find(user.UserName);
if (findU != null)
{
ModelState.AddModelError("", "UserName đã tồn tại");
}
else
{
var findP = database.Person.Find(user.PersonID);
if (findP == null)
{
ModelState.AddModelError("", "Sai mã xác nhận");
}
else
{
Users tk = new Users();
tk.UserName = user.UserName;
tk.PassWord = MaHoaMd5.MD5Hash(user.PassWord);
tk.PersonID = user.PersonID;
tk.Status = true;
database.Users.Add(tk);
database.SaveChanges();
ModelState.AddModelError("", "Đăng ký thành công");
}
}
return(View("CreateUser"));
}
public ActionResult Edit(string id)
{
WebDatabaseEntities database = new WebDatabaseEntities();
var model = database.Organization.Find(id);
return(View(model));
}
public int DeleteFaculty(string id)
{
var company = Session["CompanyID"].ToString();
var re = new Share().UpdateIntern(id, company);
if (re == true)
{
try
{
WebDatabaseEntities database = new WebDatabaseEntities();
var list = database.Person.Where(x => x.SchoolID == id && x.RoleID == 3).ToList();
if (list != null)
{
foreach (var item in list)
{
new Share().DeletePerson(item.PersonID);
}
}
return(1);
}
catch
{
return(2);
}
}
else
{
return(3);
}
}
public bool Extension(string id, int val)
{
try
{
WebDatabaseEntities database = new WebDatabaseEntities();
var list = database.Organization.Where(x => x.PersonID == id).ToList();
foreach (var item in list)
{
if (item.Status == true)
{
item.ExpiryDate += +val;
}
else
{
item.StartDay = DateTime.Now;
item.ExpiryDate = val;
item.SendEmail = false;
new Share().ChangeStatus(id, 2);
}
database.SaveChanges();
}
return(true);
}
catch
{
return(false);
}
}
public ActionResult Delete(string id)
{
JsonSerializerSettings json = new JsonSerializerSettings {
ReferenceLoopHandling = ReferenceLoopHandling.Ignore
};
var result = "";
switch (DeleteFaculty(id))
{
case 1:
WebDatabaseEntities database = new WebDatabaseEntities();
var model = database.Organization.Find(id);
database.Organization.Remove(model);
database.SaveChanges();
result = JsonConvert.SerializeObject("Xóa thành công", Formatting.Indented, json);
break;
case 2:
result = JsonConvert.SerializeObject("Không thể xóa Giáo vụ", Formatting.Indented, json);
break;
case 3:
result = JsonConvert.SerializeObject("Không thể câp nhật thực tập sinh", Formatting.Indented, json);
break;
}
return(this.Json(result, JsonRequestBehavior.AllowGet));
}
public bool DeleteOrganzation(string id, int roleId)
{
if (new Company().UpdatePersonOfOrganzation(id))
{
WebDatabaseEntities database = new WebDatabaseEntities();
Person person = new Person();
if (roleId == 2)
{
person = database.Person.SingleOrDefault(x => x.CompanyID == id && x.RoleID == 2);
}
else
{
person = database.Person.SingleOrDefault(x => x.CompanyID == id && x.RoleID == 6);
}
if (new Share().DeletePerson(person.PersonID))
{
return(new Company().deleteOrganzation(id));
}
else
{
return(false);
}
}
else
{
return(false);
}
}
public bool UpdateIntern(string schoolId, string newSchoolID)
{
try
{
WebDatabaseEntities database = new WebDatabaseEntities();
var listIntern = database.Person.Where(x => x.SchoolID == schoolId && x.RoleID == 5).ToList();
if (listIntern != null)
{
if (newSchoolID != null)
{
foreach (var item in listIntern)
{
item.SchoolID = newSchoolID;
}
}
else
{
foreach (var item in listIntern)
{
item.SchoolID = null;
}
}
database.SaveChanges();
}
return(true);
}
catch
{
return(false);
}
}
public bool DeleteQuestion(int id)
{
try
{
WebDatabaseEntities database = new WebDatabaseEntities();
//Đếm table quesition có báo nhiêu row
var count = database.Question.ToList().Count;
// kiểm tra count và id có bằng nhau không
if (count == id)
{
database.Question.Remove(database.Question.Find(id));
}
else
{
var modelend = database.Question.Find(count);
// Tìm model
var model = database.Question.Find(id);
// remove model đối đối tượng chứ không phải remove id
model.TaskID = modelend.TaskID;
model.Content = modelend.Content;
model.Answer = modelend.Answer;
model.A = modelend.A;
model.B = modelend.B;
model.C = modelend.C;
model.D = modelend.D;
database.Question.Remove(modelend);
}
database.SaveChanges();
return(true);
}
catch
{
return(false);
}
}
public bool CreateInternShip(InternShip ish)
{
try
{
WebDatabaseEntities database = new WebDatabaseEntities();
InternShip i = new InternShip();
i.InternshipID = database.InternShip.Count() + 1;
i.CourseName = ish.CourseName;
i.Note = ish.Note;
i.StartDay = ish.StartDay;
i.ExpiryDate = ish.ExpiryDate;
i.Status = false;
i.CompanyID = Session["CompanyID"].ToString();
var ro = Convert.ToInt32(Session["Role"]);
if (ish.PersonID != null)
{
i.PersonID = ish.PersonID;
}
else if (ro == 4)
{
var pid = Session["Person"].ToString();
i.PersonID = pid;
}
database.InternShip.Add(i);
database.SaveChanges();
return(true);
}
catch
{
return(false);
}
}
public void deleteInternShip(int id)
{
WebDatabaseEntities database = new WebDatabaseEntities();
var count = database.InternShip.ToList().Count();
var modelend = database.InternShip.SingleOrDefault(x => x.InternshipID == count);
var model = database.InternShip.SingleOrDefault(c => c.InternshipID == id);
model.CourseName = modelend.CourseName;
model.Note = modelend.Note;
model.PersonID = modelend.PersonID;
model.CompanyID = modelend.CompanyID;
model.StartDay = modelend.StartDay;
model.ExpiryDate = modelend.ExpiryDate;
model.Status = modelend.Status;
var list = database.IntershipWithTask.Where(a => a.InternshipID == count).ToList();
if (list != null)
{
foreach (var item in list)
{
database.IntershipWithTask.Find(item.ID).InternshipID = id;
}
database.SaveChanges();
}
database.InternShip.Remove(modelend);
database.SaveChanges();
}
public List <InternShip> listIShip()
{
var personID = Session["Person"].ToString();
var role = Convert.ToInt32(Session["Role"]);
WebDatabaseEntities database = new WebDatabaseEntities();
List <InternShip> model = new List <InternShip>();
if (role == 4)
{
var mo = database.InternShip.Where(x => x.PersonID == personID).ToList();
foreach (var item in mo)
{
model.Add(item);
}
}
else
{
var find = database.Person.Find(personID);
var list = database.InternShip.Where(x => x.CompanyID == find.CompanyID);
foreach (var item in list)
{
model.Add(item);
}
}
return(model.ToList());
}
public ActionResult Edit(string id)
{
var role = Convert.ToInt32(Session["Role"]);
SetViewBag();
SetViewBagS();
SetViewBagG();
if (role != 3)
{
SetViewBagI();
}
WebDatabaseEntities database = new WebDatabaseEntities();
var findP = database.Person.Find(id);
var findI = database.Intern.Find(id);
InternClass model = new InternClass();
model.PersonID = findP.PersonID;
model.LastName = findP.LastName;
model.FirstName = findP.FirstName;
model.Birthday = findP.Birthday;
model.Gender = findP.Gender;
model.Address = findP.Address;
model.Phone = findP.Phone;
model.Email = findP.Email;
model.Image = findP.Image;
model.SchoolID = findP.SchoolID;
model.SchoolID = findP.CompanyID;
model.StudentCode = findI.StudentCode;
return(View(model));
}
// GET: Representative
public ActionResult Index(string id)
{
WebDatabaseEntities database = new WebDatabaseEntities();
var company = Session["CompanyID"].ToString();
var list = (from a in database.Person
join b in database.Users on a.PersonID equals b.PersonID
join c in database.Organization on a.CompanyID equals c.ID
where a.CompanyID == company && a.RoleID == 3
select new RepresentativeClass()
{
PersonID = a.PersonID,
FullName = a.LastName + " " + a.FirstName,
SchoolID = a.SchoolID,
Address = a.Address,
Phone = a.Phone,
Email = a.Email,
Status = b.Status,
}).ToList();
if (id != null)
{
list = list.Where(x => x.SchoolID == id).ToList();
}
return(View(list));
}
public void ChangeStatusInternShip(string id, bool status)
{
WebDatabaseEntities database = new WebDatabaseEntities();
var list = new List <InternShip>();
var date = DateTime.Now;
if (status == false)
{
list = database.InternShip.Where(x => x.PersonID == id && x.Status == true).ToList();
foreach (var item in list)
{
item.Status = false;
}
database.SaveChanges();
}
else
{
list = database.InternShip.Where(x => x.PersonID == id).ToList();
foreach (var item in list)
{
if (item.StartDay > date)
{
item.Status = false;
}
else if (item.StartDay.AddMonths(item.ExpiryDate) > date)
{
item.Status = true;
}
}
database.SaveChanges();
}
}
public void InsertInt(Intern intern)
{
WebDatabaseEntities database = new WebDatabaseEntities();
database.Intern.Add(intern);
database.SaveChanges();
}
public void SetViewBagI(string selectedID)
{
WebDatabaseEntities database = new WebDatabaseEntities();
var list = database.InternShip.Where(x => x.PersonID == selectedID).ToList();
ViewBag.IList = list;
}
//Xóa Row IntershipWithTask có TaskId = id
public void DeleteIntershipWithTask(int id)
{
WebDatabaseEntities database = new WebDatabaseEntities();
// Tìm IntershipWithTask theo id
var model = database.IntershipWithTask.Find(id);
// lưu các biến internshipId , sort
var internshipId = model.InternshipID;
var sort = model.Sort;
// tìm IntershipWithTask cuối cùng trong table IntershipWithTask
var count = database.IntershipWithTask.ToList().Count();
var modelend = database.IntershipWithTask.Find(count);
//Gán các giá trị của modelend vào model
model.InternshipID = modelend.InternshipID;
model.TaskID = modelend.TaskID;
model.Sort = modelend.Sort;
//Remove modelend
database.IntershipWithTask.Remove(modelend);
database.SaveChanges();
//lấy listIntershipWithTask dựa trên internshipId
var listIntershipWithTask = database.IntershipWithTask.Where(x => x.InternshipID == internshipId).OrderBy(c => c.Sort).ToList();
// Update sort trong listIntershipWithTask
foreach (var item in listIntershipWithTask)
{
if (item.Sort > sort)
{
item.Sort = item.Sort - 1;
database.SaveChanges();
}
}
}
// GET: Leader
public ActionResult Index(string id = null)
{
WebDatabaseEntities database = new WebDatabaseEntities();
var company = Session["CompanyID"].ToString();
var model = (from a in database.Person
join b in database.Users on a.PersonID equals b.PersonID
where a.CompanyID == company && a.RoleID == 4
select new LeaderClass()
{
PersonID = a.PersonID,
LastName = a.LastName,
FirstName = a.FirstName,
Address = a.Address,
Phone = a.Phone,
Email = a.Email,
Status = b.Status,
}).OrderByDescending(x => x.PersonID).ToList();
if (id == null)
{
Session["PersonID"] = model[0].PersonID;
SetViewBagI(model[0].PersonID);
}
else
{
Session["PersonID"] = id;
SetViewBagI(id);
}
return(View(model));
}
//Xóa list row IntershipWithTask
public bool DeleteListIntershipWithTask(int taskId, int internshipId)
{
try
{
WebDatabaseEntities database = new WebDatabaseEntities();
// Tạo ListTasks
List <IntershipWithTask> ListTasks = new List <IntershipWithTask>();
if (taskId != 0)
{
// Nếu taskId != 0
ListTasks = database.IntershipWithTask.Where(x => x.TaskID == taskId).ToList();
}
else
{
// Nếu taskId == 0
ListTasks = database.IntershipWithTask.Where(x => x.InternshipID == internshipId).ToList();
}
if (ListTasks != null)
{
foreach (var item in ListTasks)
{
//Delete row in IntershipWithTask dựa vào id of row
DeleteIntershipWithTask(item.ID);
}
}
return(true);
}
catch
{
return(false);
}
}
public bool ChangeStatusUser(string id, int roleId)
{
WebDatabaseEntities database = new WebDatabaseEntities();
var com = database.Organization.SingleOrDefault(x => x.ID == id);
if (com.Status == true)
{
var listPerson = database.Person.Where(x => x.SchoolID == id && x.RoleID == roleId).ToList();
if (listPerson != null)
{
foreach (var item in listPerson)
{
var model = database.Users.SingleOrDefault(a => a.PersonID == item.PersonID);
if (model.Status == true)
{
model.Status = false;
database.SaveChanges();
}
}
}
com.Status = false;
}
else
{
com.Status = true;
}
database.SaveChanges();
return(com.Status);
}
public ActionResult IndexInternShipv2()
{
WebDatabaseEntities database = new WebDatabaseEntities();
string personID = Session["Person"].ToString();
var find = database.Intern.Find(personID);
// Chưa tính trường hợp Intership đã bị khóas
var statu = database.InternShip.Find(find.InternshipID).Status;
if (statu)
{
Session["Result"] = find.Result;
var list = database.IntershipWithTask.Where(x => x.InternshipID == find.InternshipID).OrderBy(x => x.Sort).ToList();
List <Task> model = new List <Task>();
foreach (var item in list)
{
var model1 = database.Task.Find(item.TaskID);
model.Add(model1);
}
return(View(model));
}
else
{
return(RedirectToAction("IndexInternShipv1", new { id = find.InternshipID }));
}
}
public ActionResult IndexInternShipv1(int id)
{
WebDatabaseEntities database = new WebDatabaseEntities();
var model = database.InternShip.Find(id);
return(View(model));
}
public bool ChangeStatusInternS(int id)
{
WebDatabaseEntities database = new WebDatabaseEntities();
var com = database.InternShip.Find(id);
if (com.Status == true)
{
com.Status = false;
}
else
{
var date = DateTime.Now;
if (com.StartDay > date)
{
com.StartDay = date;
com.Status = true;
}
else if (com.StartDay.AddMonths(com.ExpiryDate) > date)
{
com.Status = true;
}
}
database.SaveChanges();
return(com.Status);
}
public List <InternClass> ListInternOfCompany(string companyID, int internShipId)
{
WebDatabaseEntities database = new WebDatabaseEntities();
List <InternClass> listIntern = new List <InternClass>();
if (internShipId == 0)
{
listIntern = (from a in database.Person
join b in database.Intern on a.PersonID equals b.PersonID into joinl1
from j in joinl1.DefaultIfEmpty()
join f in database.Organization on a.SchoolID equals f.ID into join4
from p in join4.DefaultIfEmpty()
where a.CompanyID == companyID && a.RoleID == 5 && j.InternshipID == null
select new InternClass()
{
StudentCode = j.StudentCode,
PersonID = a.PersonID,
FullName = a.LastName + " " + a.FirstName,
Birthday = a.Birthday,
CompanyID = a.CompanyID,
NameOfCompany = database.Organization.FirstOrDefault(x => x.ID == a.CompanyID).Name,
InternshipID = j.InternshipID,
NameOfInternship = database.InternShip.FirstOrDefault(c => c.InternshipID == j.InternshipID).CourseName,
SchoolID = a.SchoolID,
NameOfSchool = database.Organization.FirstOrDefault(h => h.ID == (database.Person.FirstOrDefault(c => c.PersonID == (database.Organization.FirstOrDefault(x => x.ID == a.SchoolID).PersonID)).CompanyID)).Name,
Result = j.Result,
}).ToList();
}
else
{
listIntern = (from a in database.Person
join b in database.Intern on a.PersonID equals b.PersonID into joinl1
from j in joinl1.DefaultIfEmpty()
join f in database.Organization on a.SchoolID equals f.ID into join4
from p in join4.DefaultIfEmpty()
where a.CompanyID == companyID && a.RoleID == 5 && j.InternshipID != null
select new InternClass()
{
StudentCode = j.StudentCode,
PersonID = a.PersonID,
FullName = a.LastName + " " + a.FirstName,
Birthday = a.Birthday,
CompanyID = a.CompanyID,
NameOfCompany = database.Organization.FirstOrDefault(x => x.ID == a.CompanyID).Name,
InternshipID = j.InternshipID,
NameOfInternship = database.InternShip.FirstOrDefault(c => c.InternshipID == j.InternshipID).CourseName,
SchoolID = a.SchoolID,
NameOfSchool = database.Organization.FirstOrDefault(h => h.ID == (database.Person.FirstOrDefault(c => c.PersonID == (database.Organization.FirstOrDefault(x => x.ID == a.SchoolID).PersonID)).CompanyID)).Name,
//NameOfSchool = p.Name,
Result = j.Result,
}).ToList();
if (internShipId != 0)
{
listIntern = listIntern.Where(x => x.InternshipID == internShipId).ToList();
}
}
return(listIntern);
}
// GET: Question
public ActionResult Index()
{
WebDatabaseEntities database = new WebDatabaseEntities();
// Lấy roleID
var role = Convert.ToInt32(Session["Role"].ToString());
// Đối với Leader
if (role == 4)
{
//Sau khi làm sprint Login thì mở lại
var personID = Session["Person"].ToString();
var list = (from a in database.Person
join c in database.Task on a.PersonID equals c.PersonID
join d in database.Question on c.TaskID equals d.TaskID
where a.PersonID == personID
select new QuestionClass()
{
QuestionID = d.QuestionID,
Content = d.Content,
Answer = d.Answer,
A = d.A,
B = d.B,
C = d.C,
D = d.D,
TaskID = c.TaskID,
TaskName = c.TaskName,
PersonID = a.PersonID,
FullName = a.LastName + " " + a.FirstName
}).OrderBy(x => x.TaskID).ToList();
var count = list.Count();
return(View(list));
}
//Đối với manager
else
{
//Sau khi làm sprint Login thì mở lại
var companyID = Session["CompanyID"].ToString();
var list = (from a in database.Person
join c in database.Task on a.PersonID equals c.PersonID
join d in database.Question on c.TaskID equals d.TaskID
where a.CompanyID == companyID && a.RoleID == 4
select new QuestionClass()
{
QuestionID = d.QuestionID,
Content = d.Content,
Answer = d.Answer,
A = d.A,
B = d.B,
C = d.C,
D = d.D,
TaskID = c.TaskID,
TaskName = c.TaskName,
PersonID = a.PersonID,
FullName = a.LastName + " " + a.FirstName
}).OrderBy(x => x.TaskID).ToList();
var count = list.Count();
return(View(list));
}
}
public ActionResult Edit(string id)
{
WebDatabaseEntities database = new WebDatabaseEntities();
var model = database.Person.Find(id);
SetViewBagG();
return(View(model));
}
