public bool ChangeStatus(string id, int role)
{
var com = database.Organization.Find(id);
if (com.Status == true)
{
ChangesStatusOrgan(id, role, true);
com.Status = false;
}
else
{
ChangesStatusOrgan(id, role, false);
com.Status = true;
}
database.SaveChanges();
return(com.Status);
}
public ActionResult CreateUser(Users user)
{
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 Dele(int id)
{
var xoa = database.IntershipWithTask.Find(id);
var lsort = database.IntershipWithTask.Where(x => x.InternshipID == xoa.InternshipID && x.SORT > xoa.SORT).ToList();
foreach (var item in lsort)
{
item.SORT = item.SORT - 1;
database.SaveChanges();
}
int count = database.IntershipWithTask.Count();
var f = database.IntershipWithTask.Find(count);
xoa.InternshipID = f.InternshipID;
xoa.TaskID = f.TaskID;
xoa.SORT = f.SORT;
database.IntershipWithTask.Remove(f);
database.SaveChanges();
Session["InternshipID"] = xoa.InternshipID;
var tk = Convert.ToInt32(Session["InternshipID"]);
return(RedirectToAction("Index", new { id = tk }));
}
public bool CreateQ(Question question)
{
try
{
Question q = new Question();
int count = database.Question.Count();
q.QuestionID = count + 1;
q.Content = question.Content;
q.Answer = question.Answer;
q.A = question.A;
q.B = question.B;
q.C = question.C;
q.D = question.D;
q.TaskID = question.TaskID;
database.Question.Add(q);
database.SaveChanges();
return(true);
}
catch
{
return(false);
}
}
public bool extension(string id, int val)
{
try
{
var model = database.Organization.Find(id);
if (model.Status == true)
{
model.ExpiryDate += +val;
}
else
{
model.StartDay = DateTime.Now;
model.ExpiryDate = val;
model.SendEmail = false;
new Share().ChangeStatus(id, 3);
}
database.SaveChanges();
return(true);
}
catch
{
return(false);
}
}
public bool ChangeStatusLeader(string id)
{
var com = database.Users.SingleOrDefault(x => x.PersonID == id);
if (com.Status == true)
{
com.Status = false;
ChangeStatusInternShip(id, false);
}
else
{
com.Status = true;
ChangeStatusInternShip(id, true);
}
database.SaveChanges();
return(com.Status);
}
public bool UpdateAnswer(string id, int answer, int task)
{
try
{
TestResults testResults = new TestResults();
testResults.ID = database.TestResults.Count() + 1;
testResults.PersonID = id;
testResults.TaskID = task;
testResults.Answer = answer;
database.TestResults.Add(testResults);
var model = database.Intern.Find(id);
model.Result = model.Result + 1;
database.SaveChanges();
return(true);
}
catch
{
return(false);
}
}
public bool AddTask(List <int> listTask, int id)
{
try
{
foreach (var i in listTask)
{
IntershipWithTask addTask = new IntershipWithTask();
var count = database.IntershipWithTask.Count();
addTask.ID = count + 1;
addTask.InternshipID = id;
addTask.TaskID = i;
var sort = database.IntershipWithTask.Where(x => x.InternshipID == id).Count();
addTask.SORT = sort + 1;
database.IntershipWithTask.Add(addTask);
database.SaveChanges();
}
return(true);
}
catch
{
return(false);
}
}
public ActionResult Edit(InternDatabase intern)
{
if (ModelState.IsValid)
{
var model = database.Person.Find(intern.PersonID);
model.PersonID = intern.PersonID;
model.LastName = intern.LastName;
model.FirstName = intern.FirstName;
model.Birthday = intern.Birthday;
model.Gender = intern.Gender;
model.Address = intern.Address;
model.Phone = intern.Phone;
model.Email = intern.Email;
model.Image = intern.Image;
model.CompanyID = intern.CompanyID;
var model1 = database.Intern.Find(intern.PersonID);
model1.StudentCode = intern.StudentCode;
database.SaveChanges();
}
return(RedirectToAction("Index"));
}
public bool Create(Organization organi, int roleId)
{
try
{
Organization organ = new Organization();
Share share = new Share();
string comID;
do
{
comID = new Share().RandomText();
} while (new CompanyAndSchool().FindOrgan(comID) == false);
organ.ID = comID;
organ.Name = organi.Name;
organ.Address = organi.Address;
organ.Phone = organi.Phone;
organ.Fax = organi.Fax;
organ.Image = organi.Image;
organ.Logo = organi.Logo;
organ.Note = organi.Note;
organ.Email = organi.Email;
organ.StartDay = DateTime.Now;
organ.ExpiryDate = 1;
organ.Status = true;
organ.SendEmail = false;
database.Organization.Add(organ);
database.SaveChanges();
var model = database.Organization.Find(comID);
if (model == null)
{
return(false);
}
else
{
string personID;
do
{
personID = share.RandomText();
} while (personID == comID && FindPerson(personID) == false);
if (roleId == 2)
{
if (share.insertPerson(personID, comID, null, 2))
{
database.Person.Find(personID).Email = organi.Email;
database.SaveChanges();
return(true);
}
else
{
return(false);
}
}
else
{
if (share.insertPerson(personID, null, comID, 3))
{
database.Person.Find(personID).Email = organi.Email;
database.SaveChanges();
return(true);
}
else
{
return(false);
}
}
}
}
catch
{
return(false);
}
}