public async Task <IActionResult> Insert()
{
try
{
IFormFile files = HttpContext.Request.Form.Files[0];
string ext = Path.GetExtension(files.FileName).ToLowerInvariant();
string fileName = DateTime.UtcNow.AddMinutes(345).ToString("yyyyMMddHHmmssffff") + ext;
string path = _webHostEnvironment.WebRootPath + "\\Teacher\\" + fileName;
using (FileStream fileStream = System.IO.File.Create(path))
{
await files.CopyToAsync(fileStream);
}
TeacherDetail teacherDetail = new TeacherDetail();
teacherDetail.TeacherId = HttpContext.Request.Form["TeacherId"];
teacherDetail.FirstName = HttpContext.Request.Form["FirstName"];
teacherDetail.LastName = HttpContext.Request.Form["LastName"];
teacherDetail.DepartmentId = int.Parse(HttpContext.Request.Form["Id"]);
teacherDetail.Email = HttpContext.Request.Form["Email"];
teacherDetail.ContactNumber = HttpContext.Request.Form["Contact"];
teacherDetail.ImageName = fileName;
teacherDetail.CitizenshipNo = HttpContext.Request.Form["CitizenshipNo"];
await _libraryRepository.Insert(teacherDetail);
return(Ok("New Teacher has been successfully added."));
}
catch (Exception ex)
{
return(BadRequest(ex.Message));
}
}
public IHttpActionResult SaveTeacherDetail(TeacherDetail entity)
{
return(ApiResult <bool>(() =>
{
return CoreBusinessRules.SaveTeacherDetail(entity);
}));
}
public IActionResult Insert(TeacherDetail model)
{
try
{
if (int.Parse(model.YearsOfExperience) < 0)
{
ViewBag.Message = "You could not have had a negative years experience...";
}
else
{
if (ModelState.IsValid)
{
db.TeacherDetails.Add(model);
db.SaveChanges();
ViewBag.SuccessMessage = "Yay! You are now listed as a teacher on HomeTeach";
}
}
}
catch (Exception ex)
{
string errorMessage = ex.Message;
ViewBag.Message = "Oh No! Please input Values";
}
return(View(model));
}
public override int UpdateTeacherDetail(TeacherDetail entity)
{
return TccContext.Tcc.DB.Update("TeacherDetail")
.Column("Resume", entity.Resume)
.Column("UpdateByPersonId", entity.UpdateByPersonId)
.Column("UpdateDate", DateTime.Now)
.Where("Id", entity.Id).
Execute();
}
public DataSet Get(string command, string intSchool_id)
{
TeacherDetail teacherdetail = new TeacherDetail();
teacherdetail.intSchool_id = Convert.ToInt32(intSchool_id);
DataSet ds = record.StaffDetails(command, teacherdetail);
return(ds);
}
private void BtnDetailTeacher_Click(object sender, EventArgs e)
{
error.Clear();
if (dtgvTeacher.SelectedRows.Count == 0)
{
error.SetError(btnDetailTeacher, "Vui lòng chọn giáo viên");
return;
}
TeacherDetail form = new TeacherDetail(checkMGV);
form.ShowDialog();
}
public override int InsertTeacherDetail(TeacherDetail entity)
{
return TccContext.Tcc.DB.Insert("TeacherDetail")
.Column("TeacherId", entity.TeacherId)
.Column("Resume", entity.Resume)
.Column("UpdateDate", entity.UpdateDate)
.Column("CreateDate", entity.CreateDate)
.Column("IsDeleted", entity.IsDeleted)
.Column("CreateByPersonId", entity.CreateByPersonId)
.Column("UpdateByPersonId", entity.UpdateByPersonId)
.Column("UniqueId", entity.UniqueId)
.ExecuteReturnLastId<int>();
}
public async Task <IActionResult> updateInsert(TeacherDetail teacherdetail)
{
//var imgNmae = Guid.NewGuid().ToString();
try
{
teacherdetail.DepartmentId = teacherdetail.Department.Id;
await _libraryRepository.updateInsert(teacherdetail);
return(Ok("Successfully Updated"));
}
catch (Exception ex)
{
return(BadRequest(ex.Message));
}
}
//
// GET: /Parent/
public ActionResult Index()
{
if (Session[Configuration.SESSION_USER_ID] == null)
{
return RedirectToAction("Index", "Login");
}
int school_id = SchoolID();
TeacherDetail _td = new TeacherDetail();
ViewBag.teachers_list = _td.GetAll(school_id);
ClassDetails _cd = new ClassDetails();
ViewBag.classes_list = _cd.GetAll(school_id);
var result = _sd.GetAll(school_id).ToList();
return View(result);
}
public async Task <IActionResult> SearchTeacherWithId(string teacherId)
{
try
{
TeacherDetail teacherDetail = await _teacherSearchRepository.SearchTeacherWithId(teacherId);
//var response = teacherDetail.ImageName;
//var img = _webHostEnvironment.WebRootPath + "\\Teacher\\" + response;
//teacherDetail.ImageName = img;
//teacherDetail.ImagePath= $"{Request.Scheme}://{Request.Host}/Teacher/" + teacherDetail.ImageName;
return(Ok(teacherDetail));
}
catch (Exception ex)
{
return(BadRequest(ex.Message));
}
}
public bool SaveTeacherDetail(TeacherDetail entity)
{
entity.UpdateDate = DateTime.Now;
entity.UpdateByPersonId = 2;
entity.IsDeleted = false;
if (entity.Id > 0)
{
SqlCoreProvider.UpdateTeacherDetail(entity);
SqlCoreProvider.DeleteQualification(entity.Id);
foreach (var item in entity.Qualifications)
{
item.TeacherDetailId = entity.Id;
item.CreateByPersonId = 2;
item.UpdateByPersonId = 2;
item.CreateDate = DateTime.Now;
item.UpdateDate = item.CreateDate;
item.IsDeleted = false;
item.UniqueId = Guid.NewGuid();
SqlCoreProvider.InsertQualification(item);
}
}
else
{
entity.UniqueId = Guid.NewGuid();
entity.CreateDate = DateTime.Now;
entity.CreateByPersonId = 2;
var result = SqlCoreProvider.InsertTeacherDetail(entity);
foreach (var item in entity.Qualifications)
{
item.CreateByPersonId = 2;
item.UpdateByPersonId = 2;
item.CreateDate = DateTime.Now;
item.UpdateDate = DateTime.Now;
item.IsDeleted = false;
item.UniqueId = Guid.NewGuid();
item.TeacherDetailId = result;
SqlCoreProvider.InsertQualification(item);
}
}
return(true);
}
//
// GET: /Parent/
public ActionResult Index()
{
int school_id = SessionHandler.GetSchoolID();
TeacherDetail _td = new TeacherDetail();
var teachers = _td.GetAll(school_id);
ViewBag.teachers_list = teachers;
var result = _cd.GetAll(school_id).ToList();
foreach(var cls in result)
{
foreach(var teacher in teachers)
{
if (cls.teacher_id == teacher.user_id)
{
cls.teacher_name = teacher.full_name;
}
}
}
return View(result);
}
public virtual int UpdateTeacherDetail(TeacherDetail entity)
{
throw new NotImplementedException();
}
public IActionResult SeeProfile(int id)
{
TeacherDetail model = db.TeacherDetails.Find(id);
return(View(model));
}
public new ActionResult Profile(TeacherProfileModel profile, HttpPostedFileBase file)
{
UnitOfWork uow = new UnitOfWork();
UserService userService = new UserService();
var userId = Session["UserId"].ToString();
ViewBag.TeacherStages = uow.TeacherRepository.GetTeacherStages(userId.ToString());
ViewBag.TeacherQualifications = uow.TeacherQualifications.Get(a => a.TeacherID == userId).ToList();
ViewBag.TeacherCertification = uow.TeacherCertifications.Get(a => a.TeacherId == userId).ToList();
ViewBag.Stages = uow.Stages.Get().ToList();
User user = userService.GetProfile(userId);
if (file != null)
{
profile.ProfileImage = Guid.NewGuid().ToString() + Path.GetFileName(file.FileName);
string path = Path.Combine(Server.MapPath("~/Content/images/"), profile.ProfileImage);
file.SaveAs(path);
//byte[] bytes;
//using (BinaryReader br = new BinaryReader(file.InputStream))
//{
// bytes = br.ReadBytes(file.ContentLength);
//}
Session["Picture"] = profile.ProfileImage;
user.Picture = profile.ProfileImage;
}
if (user != null)
{
if (user.Email != Encryptor.Encrypt(profile.Email))
{
string Token = Encryptor.Encrypt(DateTime.Now.Ticks.ToString());
user.ValidationToken = Token;
var scheme = Request.Url.Scheme + "://";
var host = Request.Url.Host + ":";
var port = Request.Url.Port;
string host1 = scheme + host + port;
string bodyHtml = "<p>Welcome to Chill Learn</p> <p> please <a href='" + host1 + "/account/emailconfirmation?token=" + Token + "'>Click Here</a> to confirm email </p>";
user.Status = (int)UserStatus.Pending;
uow.UserRepository.SendEmail(profile.Email, "Chill Learn Recover Password", bodyHtml);
}
user.Email = Encryptor.Encrypt(profile.Email);
user.FirstName = profile.FirstName;
user.LastName = profile.LastName;
user.Address = profile.Address;
user.City = profile.City;
user.Country = profile.Country;
user.ContactNumber = profile.FullPhone;
user.UpdateDate = DateTime.Now;
uow.Users.Update(user);
TeacherDetail teacherDetail = uow.TeacherDetails.Get(a => a.TeacherID == user.UserID).FirstOrDefault();
if (teacherDetail != null)
{
teacherDetail.University = profile.Title;
teacherDetail.Qualification = profile.Qualification;
teacherDetail.YearsExperience = profile.Experience;
teacherDetail.Description = profile.Description;
uow.TeacherDetails.Update(teacherDetail);
}
else
{
TeacherDetail teacher = new TeacherDetail
{
University = profile.Title,
Description = profile.Description,
CreationDate = DateTime.Now,
Qualification = profile.Qualification,
Status = 1,
YearsExperience = profile.Experience,
TeacherID = userId
};
uow.TeacherDetails.Insert(teacher);
}
uow.Save();
}
//profile.ContactNumber = profile.FullPhone;
//return View(profile);
return(RedirectToAction("profile", "tutor"));
}
public async Task <IActionResult> DeleteTeacherDetails(TeacherDetail teacherdetail)
{
await _libraryRepository.DelById(teacherdetail);
return(Ok("Teacher has been successfully deleted"));
}
public IActionResult FilterTeacherBySubject(string Subject)
{
TeacherDetail model = db.TeacherDetails.Find(Subject);
return(View(model));
}
//public LibraryRepository()
//{
// LibraryDBContext libraryDBContext = new LibraryDBContext();
//}
public async Task Insert(TeacherDetail teacherdetail)
{
await _LibraryDBContext.TeacherDetails.AddAsync(teacherdetail);
await _LibraryDBContext.SaveChangesAsync();
}
public async Task updateInsert(TeacherDetail teacherdetail)
{
_LibraryDBContext.TeacherDetails.Update(teacherdetail);
await _LibraryDBContext.SaveChangesAsync();
}
public async Task DelById(TeacherDetail teacherdetail)
{
_LibraryDBContext.TeacherDetails.Remove(teacherdetail);
await _LibraryDBContext.SaveChangesAsync();
}
public ActionResult Tutor(TutorRegistration userView, IEnumerable <HttpPostedFileBase> filesF)
{
UnitOfWork uow = new UnitOfWork();
ViewBag.Countries = uow.Countries.Get().ToList();
ViewBag.Subjects = uow.Subjects.Get().ToList();
//ViewBag.Languages = GetLanguages();
ViewBag.Languages = uow.Languages.Get(x => x.IsActive == true).ToList();
ViewBag.LanguageLevel = GetLanguageLevel();
if (!ModelState.IsValid)
{
userView.ContactNumber = userView.FullPhone;
ModelState.AddModelError("error", Resources.Resources.ValidInfo);
return(View(userView));
}
string encryptedEmail = Encryptor.Encrypt(userView.Email);
string encryptedPassword = Encryptor.Encrypt(userView.Password);
string Token = Encryptor.Encrypt(DateTime.Now.Ticks.ToString());
UserService us = new UserService();
if (!us.DoesEmailExist(encryptedEmail))
{
bool contactVerified = us.DoesContactNoExist(userView.ContactNumber);
if (!contactVerified)
{
User user = new User()
{
UserID = Guid.NewGuid().ToString(),
FirstName = userView.FirstName,
LastName = userView.LastName,
ContactNumber = userView.FullPhone,
CreationDate = DateTime.Now,
Email = encryptedEmail,
Password = encryptedPassword,
UserRole = (int)UserRoles.Teacher,
Status = (int)UserStatus.Pending,
ValidationToken = Token,
Source = (int)SignupSource.App,
Picture = "NoImage.jpg",
Country = userView.Country
};
TeacherDetail teacherDetail = new TeacherDetail
{
TeacherID = user.UserID,
University = userView.University,
SubjectExperties = userView.Subject,
Qualification = userView.HigherQualification,
Description = userView.Description,
PreferedTime = userView.PreferedTime,
YearsExperience = userView.Experience,
CreationDate = DateTime.Now,
Status = 1
};
TeacherAccountDetail accountDetail = new TeacherAccountDetail
{
AccountName = userView.AccountHolder,
AccountNo = userView.AccountNo,
BranchCode = userView.BranchCode,
BranchName = userView.BranchName,
PinNo = userView.Pin,
Status = 1,
TeacherId = user.UserID
};
if (userView.SubjectTutored != null)
{
for (int i = 0; i < userView.SubjectTutored.Length; i++)
{
TeacherStage teacherStage = new TeacherStage
{
SubjectID = Convert.ToInt32(userView.SubjectTutored[i]),
TeacherID = user.UserID
};
uow.TeacherStages.Insert(teacherStage);
}
}
//Teacher Languages
//userView.Language = userView.Language.Remove(0, 1);
//string[] langs = Regex.Split(userView.Language, "-");
//if(langs != null)
//{
// for (int i = 0; i < langs.Length; i++)
// {
// string[] langa = Regex.Split(langs[i], ",");
// TeacherLanguage lang = new TeacherLanguage
// {
// Language = Convert.ToInt32(langa[0]),
// LangLevel = Convert.ToInt32(langa[1]),
// TeacherID = user.UserID
// };
// TeacherLanguage teacherLang = uow.TeacherLanguages.Get()
// .Where(a => a.LangLevel == lang.LangLevel && a.Language == lang.Language && a.TeacherID == lang.TeacherID).FirstOrDefault();
// if (teacherLang == null)
// {
// uow.TeacherLanguages.Insert(lang);
// }
// }
//}
TeacherLanguage lang = new TeacherLanguage
{
Language = Convert.ToInt32(userView.Language),
LangLevel = Convert.ToInt32(userView.LangLevel),
TeacherID = user.UserID
};
uow.TeacherLanguages.Insert(lang);
uow.Users.Insert(user);
uow.TeacherDetails.Insert(teacherDetail);
uow.TeacherAccountDetails.Insert(accountDetail);
if (filesF != null)
{
foreach (var file in filesF)
{
if (file != null)
{
string fileName = Guid.NewGuid().ToString() + Path.GetFileName(file.FileName);
string path = Path.Combine(Server.MapPath("~/Content/images/teacher/"), fileName);
file.SaveAs(path);
TeacherFile teacherFile = new TeacherFile
{
FileName = fileName,
TeacherID = user.UserID,
Type = 1
};
uow.TeacherFiles.Insert(teacherFile);
}
}
}
uow.Save();
//send notification to admin
Common.AddNotification(user.FirstName + " submitted his profile", "", user.UserID, "admin", "/admin/detail?id=" + user.UserID, (int)NotificationType.Teacher);
//send confirmation Email start
var scheme = Request.Url.Scheme + "://";
var host = Request.Url.Host + ":";
var port = Request.Url.Port;
string host1 = scheme + host + port;
string activationLink = "<a href='" + host1 + "/account/emailconfirmation?token=" + Token + "'>" + Resources.Resources.ClickHere + "</a>";
Utility.SendAccountActivationEmail(userView.Email, userView.FirstName, activationLink);
//send confirmation Email end
ModelState.AddModelError("success", Resources.Resources.AccountSuccess);
TempData["Success"] = Resources.Resources.AccountSuccess;
return(RedirectToAction("Login", "Account"));
}
else
{
ModelState.AddModelError("error", Resources.Resources.PhoneExists);
}
}
else
{
ModelState.AddModelError("error", Resources.Resources.EmailAlreadyExists);
}
return(View(userView));
}
