public JsonResult SaveData(Employee model)
{
var mgr = Session["mgr"].ToString();
var dep = Session["dep"].ToString();
var result = false;
try
{
if (model.emp_ssn > 0)
{
using (ExcelsystemsEntities2 db = new ExcelsystemsEntities2())
{
Employee e = new Employee();
e = db.Employees.SingleOrDefault(x => x.emp_ssn == model.emp_ssn);
if (e != null)
{
e.emp_ssn = model.emp_ssn;
e.name = model.name;
e.Email = model.Email;
e.mgr_ssn = model.mgr_ssn;
// e.Total_Available_days = model.Total_Available_days;
e.Casual_vacation = model.Casual_vacation;
e.Regular_vacation = model.Regular_vacation;
e.Dno = model.Dno;
e.Hiring_Date = model.Hiring_Date;
db.SaveChanges();
result = true;
}
else
{
e = new Employee();
e.emp_ssn = model.emp_ssn;
e.name = model.name;
e.Email = model.Email;
e.mgr_ssn = model.mgr_ssn;
// e.Total_Available_days = model.Total_Available_days;
e.Casual_vacation = model.Casual_vacation;
e.Regular_vacation = model.Regular_vacation;
e.Dno = model.Dno;
e.isManager = 0;
e.Hiring_Date = model.Hiring_Date;
db.Employees.Add(e);
db.SaveChanges();
result = true;
}
}
}
}
catch (Exception e)
{
return(null);
}
return(Json(result, JsonRequestBehavior.AllowGet));
}
public ActionResult Create([Bind(Include = "emp_ssn,name,Email,mgr_ssn,Dno,Total_Available_days")] Employee employee)
{
if (ModelState.IsValid)
{
db.Employees.Add(employee);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.Dno = new SelectList(db.Departments, "dep_no", "name", employee.Dno);
ViewBag.mgr_ssn = new SelectList(db.Employees, "emp_ssn", "name", employee.mgr_ssn);
return(View(employee));
}
public ActionResult Create([Bind(Include = "empID,vacID,date")] request request)
{
if (ModelState.IsValid)
{
db.requests.Add(request);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.empID = new SelectList(db.Employees, "emp_ssn", "name", request.empID);
ViewBag.vacID = new SelectList(db.vacations, "vac_ID", "vac_ID", request.vacID);
return(View(request));
}
public JsonResult DeleteEmployeeRecord(int id)
{
bool result = false;
Employee u = db.Employees.SingleOrDefault(x => x.emp_ssn == id);
if (u != null)
{
db.Employees.Remove(u);
db.SaveChanges();
result = true;
}
return(Json(result, JsonRequestBehavior.AllowGet));
}
public JsonResult approval(int check, string text, string ComingPassword)
{
if (string.IsNullOrEmpty(text))
{
text = "no reason typed";
}
string CominPass = ComingPassword;
var name = Session["name"].ToString();
int ssn = Int32.Parse(Session["ssn"].ToString());
var empSender = db.Employees.SingleOrDefault(x => x.emp_ssn == ssn);
var request = db.vacations.Where(r => r.vac_ID == VacationID);
int requesterSSN = request.SingleOrDefault().requests.SingleOrDefault().empID;
string requesterEmail = db.Employees.SingleOrDefault(f => f.emp_ssn == requesterSSN).Email;
string HREmail = db.Employees.SingleOrDefault(h => h.emp_ssn == 1011).Email;
int hrSSN = db.Employees.SingleOrDefault(r => r.Department.dep_no == 4).emp_ssn;
string userMail;
string userPass;
//string HRPassword = ComingPassword;
if (ssn == hrSSN)
{
userMail = HREmail;
userPass = ComingPassword;
}
else
{
userMail = empSender.Email;
userPass = ComingPassword;
}
//var vid = Session["VacationID"].ToString();
//var from = Session["from"].ToString();
//var to = Session["to"].ToString();
//bool.TryParse(Session["cas"].ToString(), out casual);
//bool.TryParse(Session["type"].ToString(), out permission);
if (permission == true && casual == false && regular == false)
{
if (check == 1)
{
MailMessage mail = new MailMessage();
mail.To.Add(requesterEmail);
// mail.CC.Add(HREmail);
mail.From = new MailAddress(userMail);
mail.Subject = "PermissionApproval";
string Body = @"<h2>Permission Approval </h2><br /> your requested Permission for " + hours + " Hours <label> from </label> " + from + " <label>To</label> " + to + " <br /> is ACCEPTED, enjoy ur time..";
mail.Body = Body;
mail.IsBodyHtml = true;
SmtpClient smtp = new SmtpClient();
smtp.Host = "mail.excelsystems-eg.com";
smtp.Port = 587;
smtp.UseDefaultCredentials = true;
System.Net.NetworkCredential NetworkCredential = new NetworkCredential(userMail, ComingPassword);
smtp.Credentials = NetworkCredential; // Enter seders User name and password
smtp.EnableSsl = false;
smtp.Send(mail);
db.requests.SingleOrDefault(e => e.vacID == VacationID).approval = 1;
db.SaveChanges();
}
else if (check == 2)
{
// ssn = Session["ssn"].ToString();
//empSender = db.Employees.SingleOrDefault(x => x.emp_ssn == ssn);
// userMail = empSender.Email;
// userPass = empSender.password;
MailMessage mail = new MailMessage();
mail.To.Add(requesterEmail);
// mail.CC.Add(HREmail);
mail.From = new MailAddress(userMail);
mail.Subject = "PermissionApproval";
string Body = @"<h2>Permission Approval </h2><br /> sorry to inform u that your requested permission for " + hours + " hours <label> from </label> " + from + " <label>To</label> " + to + " <br /> is rejected with the reason: " + text;
mail.Body = Body;
mail.IsBodyHtml = true;
SmtpClient smtp = new SmtpClient();
smtp.Host = "mail.excelsystems-eg.com";
smtp.Port = 587;
smtp.UseDefaultCredentials = true;
NetworkCredential Networkcredential = new NetworkCredential(userMail, ComingPassword);
smtp.Credentials = Networkcredential; // Enter seders User name and password
smtp.EnableSsl = false;
smtp.Send(mail);
db.requests.SingleOrDefault(e => e.vacID == VacationID).approval = -1;
db.SaveChanges();
}
}
else if (permission == false && casual == true && regular == false)
{
if (check == 1)
{
var requstd = Session["days"].ToString();
//var empSender = db.Employees.SingleOrDefault(x => x.emp_ssn.ToString() == ssn);
//string username = empSender.Email;
//string userPass = empSender.password;
MailMessage mail = new MailMessage();
mail.To.Add(requesterEmail);
// mail.CC.Add(HREmail);
mail.From = new MailAddress(userMail);
mail.Subject = "VacationApproval";
string Body = @"<h2>Vacation Approval </h2><br /> your requested vacation for " + requstd + " days <label> from </label> " + from + " <label>To</label> " + to + " <br /> as a casual vaction is <b> ACCEPTED</b>, enjoy ur time..";
mail.Body = Body;
mail.IsBodyHtml = true;
SmtpClient smtp = new SmtpClient();
smtp.Host = "mail.excelsystems-eg.com";
smtp.Port = 587;
smtp.UseDefaultCredentials = true;
System.Net.NetworkCredential NetworkCredential = new NetworkCredential(userMail, ComingPassword);
smtp.Credentials = NetworkCredential; // Enter seders User name and password
smtp.EnableSsl = false;
smtp.Send(mail);
db.requests.SingleOrDefault(e => e.vacID == VacationID).approval = 1;
db.Employees.SingleOrDefault(e => e.emp_ssn.ToString() == requesterSSN.ToString()).Total_Available_days -= (Int32.Parse(requstd));
db.Employees.SingleOrDefault(e => e.emp_ssn.ToString() == requesterSSN.ToString()).Casual_vacation += (Int32.Parse(requstd));
db.SaveChanges();
}
else if (check == 2)
{
//var name = Session["name"].ToString();
var requstd = Session["days"].ToString();
MailMessage mail = new MailMessage();
mail.To.Add(requesterEmail);
// mail.CC.Add(HREmail);
mail.From = new MailAddress(userMail);
mail.Subject = "VacationRequetApproval";
string Body = @"<h2>Vacation Approval </h2><br /> sorry to inform u that your requested vacation for " + requstd + " days <label> from </label> " + from + " <label>To</label> " + to + " <br /> is rejected with the reason: " + text;
mail.Body = Body;
mail.IsBodyHtml = true;
SmtpClient smtp = new SmtpClient();
smtp.Host = "mail.excelsystems-eg.com";
smtp.Port = 587;
smtp.UseDefaultCredentials = true;
NetworkCredential Networkcredential = new NetworkCredential(userMail, ComingPassword);
smtp.Credentials = Networkcredential; // Enter seders User name and password
smtp.EnableSsl = false;
smtp.Send(mail);
db.requests.SingleOrDefault(e => e.vacID == VacationID).approval = -1;
db.SaveChanges();
}
}
else if (permission == false && casual == false && regular == true)
{
if (check == 1)
{
var requstd = Session["days"].ToString();
MailMessage mail = new MailMessage();
mail.To.Add(requesterEmail);
// mail.CC.Add(HREmail);
mail.From = new MailAddress(userMail);
mail.Subject = "VacationApproval";
string Body = @"<h2>Vacation Approval </h2><br /> your requested vacation for " + requstd + " days <label> from </label> " + from + " <label>To</label> " + to + " <br /> as a Regular vaction is <b> ACCEPTED</b>, enjoy ur time..";
mail.Body = Body;
mail.IsBodyHtml = true;
SmtpClient smtp = new SmtpClient();
smtp.Host = "mail.excelsystems-eg.com";
smtp.Port = 587;
smtp.UseDefaultCredentials = true;
System.Net.NetworkCredential NetworkCredential = new NetworkCredential(userMail, ComingPassword);
smtp.Credentials = NetworkCredential; // Enter seders User name and password
smtp.EnableSsl = false;
smtp.Send(mail);
db.requests.SingleOrDefault(e => e.vacID == VacationID).approval = 1;
//db.Employees.SingleOrDefault(e => e.emp_ssn == ssn).Regular_vacation -= (Int32.Parse(requstd));
db.Employees.SingleOrDefault(e => e.emp_ssn.ToString() == requesterSSN.ToString()).Regular_vacation += (Int32.Parse(requstd));
db.Employees.SingleOrDefault(e => e.emp_ssn.ToString() == requesterSSN.ToString()).Total_Available_days -= (Int32.Parse(requstd));
db.SaveChanges();
}
else if (check == 2)
{
var requstd = Session["days"].ToString();
MailMessage mail = new MailMessage();
mail.To.Add(requesterEmail);
// mail.CC.Add(HREmail);
mail.From = new MailAddress(userMail);
mail.Subject = "PermissionApproval";
string Body = @"<h2>Vacation Approval </h2><br /> sorry to inform u that your requested vacation for " + requstd + " days <label> from </label> " + from + " <label>To</label> " + to + " <br /> is rejected with the reason: " + text;
mail.Body = Body;
mail.IsBodyHtml = true;
SmtpClient smtp = new SmtpClient();
smtp.Host = "mail.excelsystems-eg.com";
smtp.Port = 587;
smtp.UseDefaultCredentials = true;
NetworkCredential Networkcredential = new NetworkCredential(userMail, ComingPassword);
smtp.Credentials = Networkcredential; // Enter seders User name and password
smtp.EnableSsl = false;
smtp.Send(mail);
db.requests.SingleOrDefault(e => e.vacID == VacationID).approval = -1;
db.SaveChanges();
}
}
return(null);
}
public ActionResult sendMail(string ComingPassword)
{
bool flagCa;
bool flagreg;
bool permissionFlag;
var name = Session["name"].ToString();
var ssn = Session["ssn"].ToString();
var casualAvail = Session["casual"].ToString();
var regularAvail = Session["regular"].ToString();
var requested = Session["days"].ToString();
var from = DateTime.Parse(Session["from"].ToString());
var to = DateTime.Parse(Session["to"].ToString());
var id = Session["lastID"].ToString();
var isCasual = Session["cas"].ToString();
var isRegular = Session["reg"].ToString();
var reason = Session["reason"].ToString();
var isPermission = Session["permisstion"].ToString();
int Hours = (Int32.Parse(Session["Hours"].ToString()));
bool.TryParse(isCasual, out flagCa);
bool.TryParse(isRegular, out flagreg);
bool.TryParse(isPermission, out permissionFlag);
var empSender = db.Employees.SingleOrDefault(x => x.emp_ssn.ToString() == ssn);
string username = empSender.Email;
string userPass = ComingPassword;
MailMessage mail = new MailMessage();
mail.To.Add(empSender.Employee2.Email);
mail.From = new MailAddress(empSender.Email);
// mail.Subject = "VacationRequet";
if (flagCa == true && flagreg == false && permissionFlag == false)
{
subject = "VacationRequet";
Body = @"<h2>Vacation Request </h2><br /> " + name + "   requested a vacation for " + requested +
"  days <label> from </label> " + from + " <label>To</label> " + to + "   as a casual vacation for " + reason + "   knowing that he has " + casualAvail + "  available casual vacation days " +
@" <br /> for approval plz click <a href='http://*****:*****@"<h2>Vacation Request </h2><br /> " + name + "   requested a vacation for " + requested +
"   days <label> from </label> " + from + "   <label>To</label> " + to + "   as a Regular vacation for " + reason + "   knowing that he has " + regularAvail + "   available regular vacation days " +
@" <br /> for approval plz click <a href='http://*****:*****@"<h2>Permission Request </h2><br /> " + name + "   requested a Permission for " + Hours +
"   Hours <label> from </label> " + from + "  <label>To</label> " + to + "   for " + reason + "  ." +
@" <br /> for approval plz click <a href='http://localhost:2982/Approval/index'> Here</a> ";
}
mail.Subject = subject;
mail.Body = Body;
mail.IsBodyHtml = true;
SmtpClient smtp = new SmtpClient();
smtp.Host = "mail.excelsystems-eg.com";
smtp.Port = 587;
smtp.UseDefaultCredentials = true;
System.Net.NetworkCredential NetworkCredential = new NetworkCredential(username, userPass);
smtp.Credentials = NetworkCredential; // Enter seders User name and password
smtp.EnableSsl = false;
smtp.Send(mail);
//try
//{
// vacation v = new vacation();
// v.fromDate = from;
// v.toDate = to;
// v.num_days = Int32.Parse(requested);
// v.isCasual = false;
// v.isRegular = true;
// db.vacations.Add(v);
// db.SaveChanges();
// lastID = v.vac_ID;
//}
//catch (Exception ex)
//{
// return null;
//}
try
{
request r = new request();
r.date = DateTime.Now;
r.empID = Int32.Parse(ssn);
r.vacID = Int32.Parse(id);
r.approval = 0;
db.requests.Add(r);
db.SaveChanges();
}
catch (Exception e)
{
return(null);
}
//string msg = Body;
return(RedirectToAction("UserDashBoard", "testLogin"));
}
public JsonResult SaveEvent(Event e)
{
var status = false;
int lastID;
vacation vac = new vacation();
if (e.EventID > 0)
{
//Update the event
var v = db.Events.Where(a => a.EventID == e.EventID).FirstOrDefault();
if (v != null)
{
v.Subject = e.Subject;
v.Start = e.Start;
v.End = e.End;
v.Description = e.Description;
v.IsFullDay = e.IsFullDay;
v.ThemeColor = e.ThemeColor;
v.isCasual = e.isCasual;
v.isRegular = e.isRegular;
v.isPermission = e.isPermission;
}
}
else
{
db.Events.Add(e);
vac.fromDate = e.Start;
vac.toDate = e.End;
vac.Reason = e.Description;
vac.num_days = (int)e.days;
vac.isCasual = (bool)e.isCasual;
vac.isRegular = (bool)e.isRegular;
vac.isPermission = (bool)e.isPermission;
vac.hours = e.hours;
db.vacations.Add(vac);
Session["from"] = (vac.fromDate).ToString();
Session["to"] = (vac.toDate).ToString();
Session["days"] = (vac.num_days).ToString();
Session["cas"] = (vac.isCasual).ToString();
Session["reg"] = (vac.isRegular).ToString();
Session["permisstion"] = (vac.isPermission).ToString();
Session["hours"] = (vac.hours).ToString();
if (string.IsNullOrEmpty(vac.Reason))
{
string x = "special reason";
Session["reason"] = x.ToString();
}
else
{
Session["reason"] = (vac.Reason).ToString();
}
db.SaveChanges();
lastID = vac.vac_ID;
Session["lastID"] = lastID.ToString();
}
db.SaveChanges();
status = true;
return(new JsonResult {
Data = new { status = status }
});
}