public ActionResult Create([Bind(Include = "ProjectId,ProjectName,Date_Started,Date_Concluded,ClientId,EmpId")] Project project)
{
if (ModelState.IsValid)
{
db.Projects.Add(project);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(project));
}
public ActionResult AddVehicle(Vehicle v)
{
if (ModelState.IsValid)
{
v.Status = "RoadWorthy";
v.DateRegisterd = DateTime.Now;
db.Vehicles.Add(v);
db.SaveChanges();
return(RedirectToAction("getVehicles", "Logistic"));
}
return(View());
}
public ActionResult LeaveApplication([Bind(Include = "LeaveId,AppDate,Duration,Status,DateApproved,EmpId,ReasonForApplying,FromDate,ToDate,NoOfDays,Comment")] Leave leave)
{
if (ModelState.IsValid)
{
leave.EmpId = Convert.ToInt32(Session["EmpId"]);
leave.Status = "Pending";
leave.AppDate = DateTime.Now;
leave.ApplicantName = Session["Name"].ToString() + " " + Session["Surname"].ToString();
db.Leaves.Add(leave);
db.SaveChanges();
return(RedirectToAction("LeaveList"));
}
return(View(leave));
}
public ActionResult newProject(FormCollection f, HttpPostedFileBase file)
{
// user.UserId = Convert.ToInt32(Session["UserId"]);
if (ModelState.IsValid)
{
Project p = new Project();
if (file != null && file.ContentLength > 0)
{
var fileName = Path.GetFileName(file.FileName);
var path1 = Path.Combine(Server.MapPath("~/MD/img"), fileName);
file.SaveAs(path1);
p.FilePath = path1;
p.ProjectName = f["ProjectName"];
p.DateRequested = DateTime.Now;
p.ClientId = Convert.ToInt32(Session["ClientId"]);
p.Description = f["Description"];
p.Status = "Pending";
p.ProjectType = "Client Request";
p.AdvertDate = Convert.ToDateTime(f["AdvertDate"]);
p.BriefingDate = Convert.ToDateTime(f["BriefingDate"]);
p.SubmitionDate = Convert.ToDateTime(f["SubmitionDate"]);
String name = "";
DateTime dt = DateTime.Now;
name = p.ProjectName.Substring(0, 4);
p.ProjectNumber = name + dt.Month + "/" + dt.Year;
p.ContractNumber = name + dt.Month + "/" + dt.Year;
p.ContractorType = f["ContractorType"];
p.SourceOfFunding = f["SourceOfFunding"];
p.ProjectT = f["ProjectT"];
p.Municipality = f["Municipality"];
p.Province = f["Province"];
p.MunicipalityNo = f["MunicipalityNo"];
p.MunicipalityTelNo = f["MunicipalityTelNo"];
p.MunicipalityFaxNo = f["MunicipalityFaxNo"];
p.ContactPerson = f["ContactPerson"];
try
{
db.Projects.Add(p);
db.SaveChanges();
ViewBag.Message = "Submitted successfully";
}
catch
{
}
}
}
return(View());
}
public ActionResult AddMeeting(Meeting user)
{
// int EmpId = Convert.ToInt32(Session["EmpId"]);
if (ModelState.IsValid)
{
IdaDBEntities db = new IdaDBEntities();
user.TDate = DateTime.Now;
user.EmpId = Convert.ToInt32(Session["EmpId"]);
user.ClientId = null;
db.Meetings.Add(user);
db.SaveChanges();
switch (user.MeetingId)
{
case -1:
break;
case -2:
break;
default:
SendEmail(user);
break;
}
}
else
{
ViewBag.MessageError = "Error!!";
}
return(RedirectToAction("Meeting", "Staff"));
}
public ActionResult Create([Bind(Include = "EmpId,Name,Surname,Email,PhoneNo,Address,Gender,IDNumber,Salary,Position,HireDate")] Employee employee)
{
User u = new User();
if (ModelState.IsValid)
{
db.Employees.Add(employee);
u.EmpId = employee.EmpId;
u.Username = employee.Email;
u.Password = employee.IDNumber;
db.Users.Add(u);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(employee));
}
public void SendEmail(Meeting user)
{
using (var ctx = new IdaDBEntities())
{
var MeetingNo = ctx.Database.SqlQuery <string>("SELECT MeetingNo from Meeting where TDate=(SELECT MAX(TDate) FROM Meeting)").SingleOrDefault();
var StartDate = ctx.Database.SqlQuery <DateTime>("select StartDate from Meeting where TDate=(SELECT MAX(TDate) FROM Meeting)").SingleOrDefault();
var EndDate = ctx.Database.SqlQuery <DateTime>("SELECT EndDate from Meeting where TDate=(SELECT MAX(TDate) FROM Meeting)").SingleOrDefault();
var Subject = ctx.Database.SqlQuery <string>("SELECT Subject from Meeting where TDate=(SELECT MAX(TDate) FROM Meeting)").SingleOrDefault();
var Description = ctx.Database.SqlQuery <string>("SELECT Description from Meeting where TDate=(SELECT MAX(TDate) FROM Meeting)").SingleOrDefault();
if (string.IsNullOrWhiteSpace(user.MeetingId.ToString()))
{
ViewBag.Message = "Email required!!!!";
}
Guid activationCode = Guid.NewGuid();
IdaDBEntities usersEntities = new IdaDBEntities();
usersEntities.Tbl_UserActivation.Add(new Tbl_UserActivation
{
ClientId = user.MeetingId,
ActivationCode = activationCode
});
usersEntities.SaveChanges();
using (MailMessage mm = new MailMessage("*****@*****.**", user.NewClientEmail))
{
try
{
mm.Subject = "Meeting Invitation";
string body = "Dear Sir/Ma'am,";
body += "<br /><br />You are being invited to the meeting by Izingodla Engineering.";
body += "<br /><br /><b>Meeting ID: </b>" + MeetingNo;
body += "<br /><br />Subject: " + Subject;
body += "<br /><br />Start Time: " + StartDate;
body += "<br /><br />End Time: " + EndDate;
body += "<br /><br />Location: " + Description;
body += "<br /><br />Please click the following link if you won't be available";
body += "<br /><a href = '" + string.Format("{0}://{1}/Employees/Feedback/{2}", Request.Url.Scheme, Request.Url.Authority, null) + "'>Click here to give feedback.</a>";
body += "<br /><br /> We would be awaiting your esteemed presence in the meeting. Please feel free to contact us anytime, if you require any change in the meeting schedule.";
body += "<br /><br />Thanks <br /> Izingodla Team";
mm.Body = body;
mm.IsBodyHtml = true;
SmtpClient smtp = new SmtpClient();
smtp.Host = "smtp.gmail.com";
smtp.EnableSsl = true;
NetworkCredential NetworkCred = new NetworkCredential("*****@*****.**", "izingodla@123");
smtp.UseDefaultCredentials = true;
smtp.Credentials = NetworkCred;
smtp.Port = 8889;
smtp.Send(mm);
}
catch (SmtpException)
{
ViewBag.ErrorMessage = "Server Error";
}
}
}
}
public ActionResult ProjectRequest([Bind(Include = "id,ProjectName,DateRequested,ClientId")] Project_Request pr)
{
if (ModelState.IsValid)
{
db.Project_Request.Add(pr);
db.SaveChanges();
return(RedirectToAction("Index", "Client"));
}
return(View());
}
public ActionResult SignUp(Client model)
{
User u = new User();
var user = new IdaDBEntities();
using (var context = new IdaDBEntities())
{
context.Clients.Add(model);
u.Username = model.Email;
u.Password = model.Password;
u.ClientId = model.ClientId;
context.Users.Add(u);
context.SaveChanges();
}
return(RedirectToAction("Login"));
}
public void SendEmail(Meeting user)
{
using (var ctx = new IdaDBEntities())
{
var StartDate = ctx.Database.SqlQuery <DateTime>("select StartDate from Meeting where TDate=(SELECT MAX(TDate) FROM Meeting)").SingleOrDefault();
var EndDate = ctx.Database.SqlQuery <DateTime>("SELECT EndDate from Meeting where TDate=(SELECT MAX(TDate) FROM Meeting)").SingleOrDefault();
var Subject = ctx.Database.SqlQuery <string>("SELECT Subject from Meeting where TDate=(SELECT MAX(TDate) FROM Meeting)").SingleOrDefault();
var Description = ctx.Database.SqlQuery <string>("SELECT Description from Meeting where TDate=(SELECT MAX(TDate) FROM Meeting)").SingleOrDefault();
if (string.IsNullOrWhiteSpace(user.MeetingId.ToString()))
{
ViewBag.Message = "Email required!!!!";
}
Guid activationCode = Guid.NewGuid();
IdaDBEntities usersEntities = new IdaDBEntities();
usersEntities.Tbl_UserActivation.Add(new Tbl_UserActivation
{
ClientId = user.MeetingId,
ActivationCode = activationCode
});
usersEntities.SaveChanges();
using (MailMessage mm = new MailMessage("*****@*****.**", user.NewClientEmail))
{
mm.Subject = "Meeting Invitation";
string body = "Dear Sir/Ma'am,";
body += "<br /><br />You are being invited to the meeting by Izingodla Engineering.";
body += "<br /><br />Subject: " + Subject;
body += "<br /><br />Start Time: " + StartDate;
body += "<br /><br />End Time: " + EndDate;
body += "<br /><br />Location: " + Description;
body += "<br /><br /> We would be awaiting your esteemed presence in the meeting. Please feel free to contact us anytime, if you require any change in the meeting schedule.";
body += "<br /><br />Thanks <br /> Izingodla Team";
mm.Body = body;
mm.IsBodyHtml = true;
SmtpClient smtp = new SmtpClient();
smtp.Host = "smtp.gmail.com";
smtp.EnableSsl = true;
NetworkCredential NetworkCred = new NetworkCredential("*****@*****.**", "izingodla@123");
smtp.UseDefaultCredentials = true;
smtp.Credentials = NetworkCred;
smtp.Port = 587;
smtp.Send(mm);
}
}
}
private void SendPasswordToEmail(User user)//Send password to user email address
{
try
{
if (string.IsNullOrWhiteSpace(user.Username))
{
ViewBag.Message = "Email required!!!!";
}
string pass = Session["Password"].ToString();
long Password = long.Parse(pass);
string Username = Session["Username"].ToString();
Guid activationCode = Guid.NewGuid();
IdaDBEntities usersEntities = new IdaDBEntities();
usersEntities.Tbl_UserActivation.Add(new Tbl_UserActivation
{
ClientId = user.UserId,
ActivationCode = activationCode
});
usersEntities.SaveChanges();
using (MailMessage mm = new MailMessage("*****@*****.**", user.Username))
{
mm.Subject = "Password Recovery";
string body = "Hello " + Username + ",";
body += "<br /><br />Your password is:" + Password + "";
body += "<br /><br />Please click the following link to login to your account";
body += "<br /><a href = '" + string.Format("{0}://{1}/Account/Login/{2}", Request.Url.Scheme, Request.Url.Authority, activationCode) + "'>Click here to login to your account.</a>";
body += "<br /><br />Thanks";
mm.Body = body;
mm.IsBodyHtml = true;
SmtpClient smtp = new SmtpClient();
smtp.Host = "smtp.gmail.com";
smtp.EnableSsl = true;
NetworkCredential NetworkCred = new NetworkCredential("*****@*****.**", "izingodla@123");
smtp.UseDefaultCredentials = true;
smtp.Credentials = NetworkCred;
smtp.Port = 587;
smtp.Send(mm);
}
}
catch (Exception ex)
{
ViewBag.Message = "Error" + ex.Message;
}
}
public ActionResult ActivationPassword()
{
ViewBag.Message = "Invalid Password.";
if (RouteData.Values["id"] != null)
{
Guid activationCode = new Guid(RouteData.Values["id"].ToString());
IdaDBEntities usersEntities = new IdaDBEntities();
Tbl_UserActivation userActivation = usersEntities.Tbl_UserActivation.Where(p => p.ActivationCode == activationCode).FirstOrDefault();
if (userActivation != null)
{
usersEntities.Tbl_UserActivation.Remove(userActivation);
usersEntities.SaveChanges();
ViewBag.Message = "Password successful.";
}
}
return(View());
}
private void SendActivationEmail(Client user)//send account activation email to user after registration
{
Guid activationCode = Guid.NewGuid();
IdaDBEntities usersEntities = new IdaDBEntities();
usersEntities.Tbl_UserActivation.Add(new Tbl_UserActivation
{
ClientId = user.ClientId,
ActivationCode = activationCode
});;
usersEntities.SaveChanges();
using (MailMessage mm = new MailMessage("*****@*****.**", user.Email))
{
try
{
mm.Subject = "Account Activation";
string body = "Hello " + user.Name + ",";
body += "<br /><br />Please click the following link to activate your account";
body += "<br /><a href = '" + string.Format("{0}://{1}/Account/Login/{2}", Request.Url.Scheme, Request.Url.Authority, activationCode) + "'>Click here to activate your account.</a>";
body += "<br /><br />Thanks";
mm.Body = body;
mm.IsBodyHtml = true;
SmtpClient smtp = new SmtpClient();
smtp.Host = "smtp.gmail.com";
smtp.EnableSsl = true;
NetworkCredential NetworkCred = new NetworkCredential("*****@*****.**", "izingodla@123");
smtp.UseDefaultCredentials = true;
smtp.Credentials = NetworkCred;
smtp.Port = 587;
smtp.Send(mm);
}
catch (SmtpException)
{
ViewBag.ErrorMessage = "Email entered does not exist";
}
//To fix the smt error use link bellow
//https://stackoverflow.com/questions/20906077/gmail-error-the-smtp-server-requires-a-secure-connection-or-the-client-was-not
//mvc charts
//https://canvasjs.com/asp-net-mvc-charts/
//GmailAccount is => [email protected] -- Password is => booking@123
}
}
public ActionResult Edit([Bind(Include = "EmpId,Name,Surname,Email,PhoneNo,Address,Gender,IDNumber,Salary,Position,HireDate")] Employee employee)
{
try
{
if (Session["Position"].Equals("CEO"))
{
if (ModelState.IsValid)
{
db.Entry(employee).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(employee));
}
else
{
return(RedirectToAction("Login", "Account"));
}
}
catch (Exception ex)
{
return(View(ex.Message));
}
}