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 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();
//var apiKey = Environment.GetEnvironmentVariable("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");
var apiKey = ("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");
var client = new SendGridClient(apiKey);
var from = new EmailAddress("*****@*****.**", "Meeting Invitation");
var Emailsubject = "Meeting Invitation";
foreach (var address in user.NewClientEmail.Split(new[] { "," }, StringSplitOptions.RemoveEmptyEntries))
{
var to = new EmailAddress(address);
var plainTextContent = "Meeting Invitation";
string htmlContent = "Dear Sir/Ma’am,";
htmlContent += "<br /><br />You are being invited to the meeting by Izingodla Engineering.";
htmlContent += "<br /><br /> Subject : " + Subject + "";
htmlContent += "<br /> Location : " + Description + "";
htmlContent += "<br /> Start Time : " + StartDate + "";
htmlContent += "<br /> End Time : " + EndDate + "";
htmlContent += "<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.";
htmlContent += "<br /><br />Thanks <br /> Izingodla Team";
var msg = MailHelper.CreateSingleEmail(from, to, Emailsubject, plainTextContent, htmlContent);
var response = client.SendEmailAsync(msg);
}
}
}
public List <AssignedPM> GetPM(DateTime afterDate)
{
using (IdaDBEntities db = new IdaDBEntities())
{
return(db.AssignedPMs.Where(a => a.DateAssigned > afterDate).OrderByDescending(a => a.DateAssigned).ToList());
}
}
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 JsonResult GetMeetings()
{
using (IdaDBEntities dc = new IdaDBEntities())
{
var meetings = dc.Meetings.ToList();
return(new JsonResult {
Data = meetings, JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
}
public ActionResult Progress()
{
IdaDBEntities sample = new IdaDBEntities();
var getEmpList = sample.Employees.ToList();
SelectList list = new SelectList(getEmpList, "Name", "Surname");
ViewBag.EmployeeList = list;
return(View(db.Tasks.ToList()));
}
public ActionResult ForgotPassword(User tb)//Forgot password
{
if (ModelState.IsValid)
{
IdaDBEntities db = new IdaDBEntities();
var user = (from userlist in db.Users
where userlist.Username == tb.Username
select new
{
userlist.UserId,
userlist.Username,
userlist.Password,
}).ToList();
if (user.FirstOrDefault() == null)
{
ViewBag.MessageError = "System cannot recognise your emai!!";
}
else if (user.FirstOrDefault() != null)
{
Session["Username"] = user.FirstOrDefault().Username;
Session["UserId"] = user.FirstOrDefault().UserId;
Session["Password"] = user.FirstOrDefault().Password;
string message = string.Empty;
switch (tb.UserId)
{
case -1:
message = "";
break;
case -2:
message = "";
break;
default:
message = "Password sent successful.\\nUser Id: " + tb.UserId.ToString();
SendPasswordToEmail(tb);
break;
}
ViewBag.MessageSuccess = "Password sent!! Please check your email";
}
else
{
ModelState.AddModelError("", "Invalid Email Provided");
}
}
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 JsonResult GetMeetings(int?id)
{
id = Convert.ToInt32(Session["ClientId"]);
using (IdaDBEntities dc = new IdaDBEntities())
{
var meetings = dc.Meetings.ToList();
List <Meeting> meet = new List <Meeting>();
foreach (var item in meetings)
{
if (item.ClientId == id)
{
meet.Add(item);
}
}
return(new JsonResult {
Data = meet, JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
}
