public IActionResult Edit(CInterviewEditViewModel I)
{
if (I != null)
{
TInterView table = myHR.TInterViews.Where(n => n.CInterVieweeId == I.CInterVieweeId).FirstOrDefault();
if (table != null)
{
table.CInterVieweeName = I.CInterVieweeName;
table.CInterViewStatusId = int.Parse(I.CStatus);
myHR.SaveChanges();
}
}
// 如果狀態為待報到 跳至新增帳號頁面
if (int.Parse(I.CStatus) == 3)
{
var interviewer = myHR.TInterViews.Where(n => n.CInterVieweeId == I.CInterVieweeId).FirstOrDefault();
//HttpContext.Session.SetObject<TInterView>(CDictionary.Register_User, interviewer);
TempData.Put("Register", interviewer);
AddNoti(1, "新人報到通知", $"貴部門 {interviewer.CInterVieweeName} 確認報到，已發送報到通知。");
return(RedirectToAction("register", "employee"));
}
TempData["Id"] = I.CInterVieweeId;
return(RedirectToAction("List"));
}
public IActionResult Delete(int?Id)
{
if (Id != null)
{
TInterView I = myHR.TInterViews.FirstOrDefault(n => n.CInterVieweeId == Id);
if (I != null)
{
myHR.TInterViews.Remove(I);
myHR.SaveChanges();
}
}
return(RedirectToAction("List"));
}
public IActionResult Edit(int?Id)
{
if (Id != null)
{
List <TInterViewStatus> status = GetStatus(); //從資料庫抓下拉式選單
ViewBag.Status = status;
TInterView I = myHR.TInterViews.FirstOrDefault(n => n.CInterVieweeId == Id);
if (I != null)
{
ViewBag.CurrentStatus = I.CInterViewStatusId;
return(PartialView("Edit", new CInterviewListViewModel(I)));
}
}
return(RedirectToAction("List"));
}
public CInterviewListViewModel()
{
iv_interview = new TInterView();
}
public CInterviewListViewModel(TInterView i)
{
iv_interview = i;
}
public IActionResult register(TUserViewModel _user)
{
ViewBag.CDepartmentId = db.TUserDepartments.ToList();
ViewBag.CJobTitleId = db.TUserJobTitles.ToList();
//新增員工
db.TUsers.Add(_user.tuserVM);
db.SaveChanges();
//給面試要報到的人employeeId
int id = db.TUsers.Where(n => n.CEmployeeName == _user.CEmployeeName).Select(n => n.CEmployeeId).FirstOrDefault();
TInterView table = db.TInterViews.Where(n => n.CEmployeeEnglishName == _user.CEmployeeEnglishName).FirstOrDefault();
if (table != null)
{
table.CInterViewerEmployeeId = id;
db.SaveChanges();
}
//開始寄信
int userid = db.TUsers.OrderByDescending(n => n.CEmployeeId).Select(c => c.CEmployeeId).FirstOrDefault(); //撈取新註冊的員工ID
string name = db.TUsers.Where(n => n.CEmployeeId == userid).Select(c => c.CEmployeeName).FirstOrDefault(); //撈取新註冊的員工NAME
string email = db.TUsers.Where(n => n.CEmployeeId == userid).Select(c => c.CEmail).FirstOrDefault(); //撈取新註冊的員工EMAIL
string password = db.TUsers.Where(n => n.CEmployeeId == userid).Select(c => c.CPassWord).FirstOrDefault(); //撈取新註冊的員工PASSWORD
string english = db.TUsers.Where(n => n.CEmployeeId == userid).Select(c => c.CEmployeeEnglishName).FirstOrDefault(); //撈取新註冊的員工PASSWORD
try
{
System.Net.Mail.MailMessage msg = new System.Net.Mail.MailMessage();
msg.To.Add(email);
msg.From = new MailAddress("*****@*****.**", "HELLOWORK公司", System.Text.Encoding.UTF8);
/* 上面3個參數分別是發件人地址，發件人姓名，編碼*/
msg.Subject = "錄取報到通知"; //郵件標題
msg.SubjectEncoding = System.Text.Encoding.UTF8; //郵件標題編碼
//郵件內容
msg.Body = name + " 您好，" + Environment.NewLine;
msg.Body += "您已錄取本公司，請至公司官網報到啟用帳號。" + Environment.NewLine;
msg.Body += "登入帳號:" + userid + Environment.NewLine;
msg.Body += "英文姓名:" + english + Environment.NewLine;
msg.Body += "密碼:" + password + Environment.NewLine;
//郵件內容
msg.BodyEncoding = System.Text.Encoding.UTF8; //郵件內容編碼
/* msg.Attachments.Add(new Attachment(@"D:\test2.docx")); */ //附件
msg.IsBodyHtml = true; //是否是HTML郵件
//msg.Priority = MailPriority.High;//郵件優先級
SmtpClient client = new SmtpClient();
client.Credentials = new System.Net.NetworkCredential("*****@*****.**", "izougqdehrjrufoh"); //這裡要填正確的帳號跟密碼
client.Host = "smtp.gmail.com"; //設定smtp Server
client.Port = 25; //設定Port
client.EnableSsl = true; //gmail預設開啟驗證
client.Send(msg); //寄出信件
client.Dispose();
msg.Dispose();
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
return(RedirectToAction("employeeList"));
}
