public static void TemplateMissing(string template, string folder, string servername)
{
DSRCManagementSystemEntities1 db = new DSRCManagementSystemEntities1();
DsrcMailSystem.MailSender AppValue = new DsrcMailSystem.MailSender();
//string ServerName = WebConfigurationManager.AppSettings["SeverName"];
string ServerName = AppValue.GetFromMailAddress("ServerName");
DateTime indianTime = TimeZoneInfo.ConvertTimeFromUtc(DateTime.UtcNow, INDIAN_ZONE);
var UserID = Convert.ToInt64(System.Web.HttpContext.Current.Session["UserID"]);
var username = db.Users.Where(x => x.UserID == UserID).Select(o => o.FirstName + " " + o.LastName).FirstOrDefault();
DateTime currentdate = DateTime.Now;
var Assignobj = db.MissingTemplates.CreateObject();
Assignobj.TemplateName = template;
Assignobj.MissedProcess = folder;
Assignobj.ProcessedBy = username;
Assignobj.ProcessedDate = currentdate;
db.MissingTemplates.AddObject(Assignobj);
db.SaveChanges();
MailMessage mail = new System.Net.Mail.MailMessage();
string EmailAddres = "*****@*****.**";
mail.To.Add(EmailAddres);
mail.From = new MailAddress("*****@*****.**");
mail.Subject = "HRMS-Test Template Missing Exception";
var company = db.Master_ApplicationSettings.Where(x => x.AppKey == "Company Name").Select(o => o.AppValue).FirstOrDefault();
mail.Body = "Template Missing Exception: " + " " + template + " <br/><br/>ServerName: " + " " + servername + " <br/><br/>Date: " + " " + indianTime + " " + "<br/><br/>This email has been automatically generated.</br>Please do not reply to this email address as all responses are directed to an unattended,<br/>mailbox, and you will not receive a response.</p><br/><p style=font-size:15px>Thanks,<br/>" + company + "HRMS</p>";
mail.IsBodyHtml = true;
SmtpClient smtp = new SmtpClient();
string port = db.Master_ApplicationSettings.Where(x => x.AppKey == "Port").Select(o => o.AppValue).FirstOrDefault();
smtp.Host = db.Master_ApplicationSettings.Where(x => x.AppKey == "Host Name").Select(o => o.AppValue).FirstOrDefault();
smtp.Port = Convert.ToInt32(port.ToString());
smtp.UseDefaultCredentials = false;
smtp.Credentials = new System.Net.NetworkCredential
("*****@*****.**", "dsrc1234");// Enter senders User name and password
smtp.EnableSsl = false;
smtp.Send(mail);
}
public ActionResult AddNewRoll(QuickEnrollment role)
{
DSRCManagementSystemEntities1 db = new DSRCManagementSystemEntities1();
string ServerName = AppValue.GetFromMailAddress("ServerName");
string exp = "--";
string Date = null;
string Date1 = null;
//DateTime todate = (Convert.ToDateTime(role.DateOfJoin)); // added
var AddRoles = db.QuickEnrolls.CreateObject();
AddRoles.FirstName = role.FirstName;
AddRoles.LastName = role.LastName;
AddRoles.Address = role.Address;
AddRoles.Location = role.Location;
AddRoles.PhoneNumber = role.PhoneNumber;
//if (role.DateOfBirth != DateTime.MinValue)
//{
// AddRoles.DateOfBirth = Convert.ToDateTime(role.DateOfBirth);
//}
AddRoles.BranchID = role.BranchID;
if (role.DateOfJoin != null)
{
AddRoles.DateOfJoin = Convert.ToDateTime(role.DateOfJoin);
DateTime todate = (Convert.ToDateTime(role.DateOfJoin));
Date = todate.ToString("dd-MM-yyyy");
}
if (role.DateOfEnquiry != null)
{
AddRoles.DateOfEnquiry = Convert.ToDateTime(role.DateOfEnquiry);
DateTime endate = (Convert.ToDateTime(role.DateOfEnquiry));
Date1 = endate.ToString("dd-MM-yyyy");
}
//added on 9/9
if (role.Experience != "undefined.undefined")
{
exp = role.Experience;
}
else
{
exp = "0";
}
//ends
AddRoles.Experience = role.Experience;
AddRoles.PersonalMailAddress = role.PersonalEmailAddress;
AddRoles.DepartmentID = role.DepartmentName;
AddRoles.RoleID = (byte)role.RollID;
AddRoles.GenderID = role.GenderID;
AddRoles.DateOfEnquiry = role.DateOfEnquiry;
if (role.DepartmentGroup != 0)
{
AddRoles.DepartmentGroup = role.DepartmentGroup;
}
AddRoles.Comments = role.Comments;
AddRoles.Experience = role.Experience;
AddRoles.IsActive = true;
db.QuickEnrolls.AddObject(AddRoles);
db.SaveChanges();
if (role.QuickEnroll != null)
{
var checks = db.EmailTemplates.Where(x => x.TemplatePurpose == "AddEnroll").Select(o => o.EmailTemplateID).FirstOrDefault();
var folder = db.EmailTemplates.Where(o => o.TemplatePurpose == "AddEnroll").Select(x => x.TemplatePath).FirstOrDefault();
if ((checks != null) && (checks != 0))
{
var objnewuser = (from p in db.EmailPurposes.Where(x => x.EmailPurposeName == "AddEnroll")
join q in db.EmailTemplates on p.EmailTemplateID equals q.EmailTemplateID
select new DSRCManagementSystem.Models.Email
{
To = p.To,
CC = p.CC,
BCC = p.BCC,
Subject = p.Subject,
Template = q.TemplatePath
}).FirstOrDefault();
var company = db.Master_ApplicationSettings.Where(x => x.AppKey == "Company Name").Select(o => o.AppValue).FirstOrDefault();
string TemplatePathnewuser = Server.MapPath(objnewuser.Template);
string AddEnrollhtml = System.IO.File.ReadAllText(TemplatePathnewuser);
AddEnrollhtml = AddEnrollhtml.Replace("#Name", role.FirstName + " " + role.LastName);
AddEnrollhtml = AddEnrollhtml.Replace("#JoiningDate", Date);
AddEnrollhtml = AddEnrollhtml.Replace("#Experience", exp); //role.Experience);
AddEnrollhtml = AddEnrollhtml.Replace("#Date", Date);
AddEnrollhtml = AddEnrollhtml.Replace("#ServerName", ServerName);
AddEnrollhtml = AddEnrollhtml.Replace("#CompanyName", company);
if (objnewuser.To != "")
{
objnewuser.To = QuickEnrollController.GetUserEmailAddress(db, objnewuser.To);
}
if (objnewuser.CC != "")
{
objnewuser.BCC = QuickEnrollController.GetUserEmailAddress(db, objnewuser.CC);
}
if (objnewuser.BCC != "")
{
// objnewuser.BCC = QuickEnrollController.GetUserEmailAddress(db, objnewuser.BCC);
}
// var logo = db.Master_ApplicationSettings.Where(x => x.AppID == 7).Select(x => x).FirstOrDefault();
var logo = CommonLogic.getLogoPath();
//string ServerName = WebConfigurationManager.AppSettings["SeverName"];
int userId = int.Parse(Session["UserID"].ToString());
var userdetails = db.Users.FirstOrDefault(o => o.UserID == userId);
string MailID = userdetails.EmailAddress;
if (ServerName != "http://*****:*****@dsrc.co.in");
// MailIds.Add("*****@*****.**");
MailIds.Add("*****@*****.**");
MailIds.Add("*****@*****.**");
MailIds.Add("*****@*****.**");
MailIds.Add("*****@*****.**");
MailIds.Add("*****@*****.**");
MailIds.Add("*****@*****.**");
//MailIds.Add("*****@*****.**");
// MailIds.Add("*****@*****.**");
string EmailAddress = "";
foreach (string maiil in MailIds)
{
EmailAddress += maiil + ",";
}
EmailAddress = EmailAddress.Remove(EmailAddress.Length - 1);
Task.Factory.StartNew(() =>
{
// DsrcMailSystem.MailSender.SendMail(null, objnewuser.Subject + " - Test Mail Please Ignore", "", AddEnrollhtml + " - Testing Plaese ignore", "*****@*****.**", EmailAddress, Server.MapPath(logo.AppValue.ToString()));
DsrcMailSystem.MailSender.SendMail(null, objnewuser.Subject + " - Test Mail Please Ignore", "", AddEnrollhtml + " - Testing Plaese ignore", "*****@*****.**", EmailAddress, Server.MapPath(logo.ToString()));
});
}
else
{
Task.Factory.StartNew(() =>
{
// DsrcMailSystem.MailSender.SendMail(null, objnewuser.Subject, "", AddEnrollhtml, "*****@*****.**", MailID, Server.MapPath(logo.AppValue.ToString()));
DsrcMailSystem.MailSender.SendMail(null, objnewuser.Subject, "", AddEnrollhtml, "*****@*****.**", MailID, Server.MapPath(logo.ToString()));
});
}
}
else
{
// string ServerName = WebConfigurationManager.AppSettings["SeverName"];
ExceptionHandlingController.TemplateMissing("AddEnroll", folder, ServerName);
}
}
return(Json("Success", JsonRequestBehavior.AllowGet));
}
public ActionResult Mylearning(int Trainingid)
{
try
{
string ServerName = AppValue.GetFromMailAddress("ServerName");
int user = int.Parse(Session["UserID"].ToString());
DSRCManagementSystemEntities1 obj = new DSRCManagementSystemEntities1();
var instructor = obj.Trainings.Where(x => x.TrainingId == Trainingid && x.InstructorId == user).Select(o => o.InstructorId).FirstOrDefault();
var Training = obj.Trainings.Where(x => x.TrainingId == Trainingid).Select(o => o).FirstOrDefault();
var NomitionOne = obj.TrainingNominations.Where(x => x.UserId == user && x.TrainingId == Trainingid).Select(x => x).ToList();
int NomineeCount = NomitionOne.Count();
if (Trainingid == 0)
{
return(Json(new { Result = "Null" }, JsonRequestBehavior.AllowGet));
}
else if (instructor != null)
{
return(Json(new { Result = "Instructor" }, JsonRequestBehavior.AllowGet));
}
else if (Training.NumberOfNominated == Training.SeatingCapacity + 2)
{
return(Json(new { Result = "NoSeat" }, JsonRequestBehavior.AllowGet));
}
else if (NomineeCount != 0)
{
return(Json(new { Result = "Already" }, JsonRequestBehavior.AllowGet));
}
else
{
int userId = int.Parse(Session["UserID"].ToString());
var email = System.Web.HttpContext.Current.Application["UserName"].ToString();
DSRCManagementSystemEntities1 db = new DSRCManagementSystemEntities1();
var empid = db.Users.Where(x => x.UserID == userId).Select(o => o.EmpID).FirstOrDefault();
//int emp = Convert.ToInt32(empid);
DSRCManagementSystemEntities1 obf = new DSRCManagementSystemEntities1();
//var EMP = obf.Users.Where(x => x.UserID == userId).Select(o => o.EmpID).FirstOrDefault();
int k = Trainingid;
DSRCManagementSystemEntities1 objdb = new DSRCManagementSystemEntities1();
//var id = db.Users.Where(x => x.UserID == userId).Select(o => o.EmpID).FirstOrDefault();
//int? value = Convert.ToInt32(id);
var empname = objdb.Users.Where(x => x.UserID == userId).Select(o => o.FirstName + " " + o.LastName ?? "").FirstOrDefault();
// context.Authors.Where(a => a.Books.Any(b => b.BookID == bookID)).ToList();
var val = objdb.TrainingNominations.Where(x => x.UserId == userId && x.TrainingId == k).Select(o => o.TrainingId).FirstOrDefault();
int?instructorid = db.Trainings.Where(x => x.InstructorId == userId).Select(o => o.InstructorId).FirstOrDefault();
var technology = objdb.Trainings.Where(x => x.TrainingId == k).Select(o => o.TechnologyId).FirstOrDefault();
var LevelId = db.Trainings.Where(x => x.TrainingId == Trainingid).Select(x => x.LevelId).FirstOrDefault();
int?InsID = db.Trainings.Where(x => x.TrainingId == Trainingid).Select(o => o.InstructorId).FirstOrDefault();
//var trainwidgets = db.TrainingWeightages.CreateObject();
//trainwidgets.Trainee = user;
//trainwidgets.Instructor = InsID;
//trainwidgets.LevelId = LevelId;
//db.TrainingWeightages.AddObject(trainwidgets);
//db.SaveChanges();
DSRCManagementSystem.TrainingNomination nom = new DSRCManagementSystem.TrainingNomination();
nom.TrainingId = Trainingid;
nom.EmpId = empid;
nom.UserId = user;
nom.EmpName = empname;
nom.TechnologyId = technology;
nom.EmailId = email;
nom.NominationFlag = true;
// nom.CompletionFlag = true;
nom.CompletionFlag = true;
nom.IsActive = true;
objdb.AddToTrainingNominations(nom);
objdb.SaveChanges();
var Techref = db.Trainings.FirstOrDefault(o => o.TrainingId == k);
string Tid = k.ToString();
string tname = Techref.TrainingName;
DateTime d1 = Convert.ToDateTime(Techref.ScheduledDate);
string d = d1.ToShortDateString();
string stime = Techref.StartTime;
string etime = Techref.EndTime;
string username = db.Users.Where(o => o.UserID == Techref.InstructorId).Select(o => o.FirstName + " " + (o.LastName ?? "")).FirstOrDefault();
var userdetails = db.Users.FirstOrDefault(o => o.UserID == userId);
string MailID = userdetails.EmailAddress;
string EmpName = userdetails.FirstName + " " + userdetails.LastName ?? "";
//string mailMessage = MailBuilder.NominationConfirmation(EmpName, Tid, tname, d, stime, etime, username);
var check = objdb.EmailTemplates.Where(x => x.TemplatePurpose == "Nomination Confirmation").Select(o => o.EmailTemplateID).FirstOrDefault();
var folder = objdb.EmailTemplates.Where(o => o.TemplatePurpose == "Nomination Confirmation").Select(x => x.TemplatePath).FirstOrDefault();
if ((check != null) && (check != 0))
{
var objNominationConfirmation = (from p in db.EmailPurposes.Where(x => x.EmailPurposeName == "Nomination Confirmation")
join q in db.EmailTemplates on p.EmailTemplateID equals q.EmailTemplateID
select new DSRCManagementSystem.Models.Email
{
To = p.To,
CC = p.CC,
BCC = p.BCC,
Subject = p.Subject,
Template = q.TemplatePath
}).FirstOrDefault();
var company = db.Master_ApplicationSettings.Where(x => x.AppKey == "Company Name").Select(o => o.AppValue).FirstOrDefault();
string TemplatePathNominationConfirmation = Server.MapPath(objNominationConfirmation.Template);
string htmlNominationConfirmation = System.IO.File.ReadAllText(TemplatePathNominationConfirmation);
htmlNominationConfirmation = htmlNominationConfirmation.Replace("#Empname", EmpName);
htmlNominationConfirmation = htmlNominationConfirmation.Replace("#TrainingId", Tid);
htmlNominationConfirmation = htmlNominationConfirmation.Replace("#TrainingName", tname);
htmlNominationConfirmation = htmlNominationConfirmation.Replace("#ScheduledDate", d);
htmlNominationConfirmation = htmlNominationConfirmation.Replace("#start", stime);
htmlNominationConfirmation = htmlNominationConfirmation.Replace("#end", etime);
htmlNominationConfirmation = htmlNominationConfirmation.Replace("#Instructor", username);
htmlNominationConfirmation = htmlNominationConfirmation.Replace("#ServerName", ServerName);
htmlNominationConfirmation = htmlNominationConfirmation.Replace("#CompanyName", company);
//string ServerName = WebConfigurationManager.AppSettings["SeverName"];
var logo = CommonLogic.getLogoPath();
if (ServerName != "http://*****:*****@dsrc.co.in");
//MailIds.Add("*****@*****.**");
//MailIds.Add("*****@*****.**");
//MailIds.Add("*****@*****.**");
//MailIds.Add("*****@*****.**");
//MailIds.Add("*****@*****.**");
//MailIds.Add("*****@*****.**");
string EmailAddress = "";
foreach (string mail in MailIds)
{
EmailAddress += mail + ",";
}
EmailAddress = EmailAddress.Remove(EmailAddress.Length - 1);
Task.Factory.StartNew(() =>
{
//var logo = db.Master_ApplicationSettings.Where(x => x.AppID == 7).Select(x => x).FirstOrDefault();
// DsrcMailSystem.MailSender.SendMail(null, objNominationConfirmation.Subject + " - Test Mail Please Ignore", null, htmlNominationConfirmation + " - Testing Plaese ignore", "*****@*****.**", EmailAddress, Server.MapPath(logo.AppValue.ToString()));
DsrcMailSystem.MailSender.SendMail(null, objNominationConfirmation.Subject + " - Test Mail Please Ignore", null, htmlNominationConfirmation + " - Testing Plaese ignore", "*****@*****.**", EmailAddress, Server.MapPath(logo.ToString()));
});
}
else
{
Task.Factory.StartNew(() =>
{
// var logo = db.Master_ApplicationSettings.Where(x => x.AppID == 7).Select(x => x).FirstOrDefault();
// DsrcMailSystem.MailSender.SendMail(null, objNominationConfirmation.Subject, null, htmlNominationConfirmation, "*****@*****.**", MailID, Server.MapPath(logo.AppValue.ToString()));
DsrcMailSystem.MailSender.SendMail(null, objNominationConfirmation.Subject, null, htmlNominationConfirmation, "*****@*****.**", MailID, Server.MapPath(logo.ToString()));
//DsrcMailSystem.MailSender.LDSendMail(null, "L & D - Training Nomination Confirmation", null, mailMessage, "*****@*****.**", MailID, Server.MapPath("~/Content/Template/images/logo.png"));
});
}
}
else
{
// string ServerName = WebConfigurationManager.AppSettings["SeverName"];
ExceptionHandlingController.TemplateMissing("Nomination Confirmation", folder, ServerName);
}
//int k = Trainingid;
var value1 = obf.Trainings.Where(x => x.TrainingId == Trainingid).Select(o => o).FirstOrDefault();
value1.Flag = false;
obf.SaveChanges();
var No_Of_Nominees_Ref = db.Trainings.FirstOrDefault(o => o.TrainingId == Trainingid);
int?No_Of_Nominations = No_Of_Nominees_Ref.NumberOfNominated;
No_Of_Nominees_Ref.NumberOfNominated = No_Of_Nominations + 1;
db.SaveChanges();
}
}
catch (Exception Ex)
{
string actionName = this.ControllerContext.RouteData.Values["action"].ToString();
string controllerName = this.ControllerContext.RouteData.Values["controller"].ToString();
ExceptionHandlingController.ExceptionDetails(Ex, actionName, controllerName);
}
return(Json(new { Result = "Success" }, JsonRequestBehavior.AllowGet));
}
public ActionResult UserFeedbacks(UserFeedback userFeedback)
{
try
{
if (ModelState.IsValid)
{
DSRCManagementSystemEntities1 odb = new DSRCManagementSystemEntities1();
// var logo = odb.Master_ApplicationSettings.Where(x => x.AppID == 7).Select(x => x).FirstOrDefault();
string ServerName = AppValue.GetFromMailAddress("ServerName");
int userID = Convert.ToInt32(Session["UserID"]);
string email = Convert.ToString(Session["UserName"]);
string pathvalue = CommonLogic.getLogoPath();
//var logo = odb.Master_ApplicationSettings.Where(x => x.AppID == 7).Select(x => x).FirstOrDefault();
//string[] words;
//words = logo.AppValue.Split(new string[] { "../../" }, StringSplitOptions.None);
//string pathvalue = "~/" + words[1];
var obj = new UsersFeedback()
{
UserID = userID,
Feedback = userFeedback.Feedback,
FeedbackDate = DateTime.Now
};
db.UsersFeedbacks.AddObject(obj);
db.SaveChanges();
string MailMessage = MailBuilder.FeedBack(Session["FirstName"].ToString(), Session["LastName"].ToString(), userFeedback.Feedback.Replace(Environment.NewLine, "</br>"));
var check = db.EmailTemplates.Where(x => x.TemplatePurpose == "Feedback").Select(o => o.EmailTemplateID).FirstOrDefault();
var folder = db.EmailTemplates.Where(o => o.TemplatePurpose == "Feedback").Select(x => x.TemplatePath).FirstOrDefault();
if ((check != null) && (check != 0))
{
var objFeedback = (from p in db.EmailPurposes.Where(x => x.EmailPurposeName == "Feedback")
join q in db.EmailTemplates on p.EmailTemplateID equals q.EmailTemplateID
select new DSRCManagementSystem.Models.Email
{
To = p.To,
CC = p.CC,
BCC = p.BCC,
Subject = p.Subject,
Template = q.TemplatePath
}).FirstOrDefault();
string TemplatePathFeedback = Server.MapPath(objFeedback.Template);
var company = db.Master_ApplicationSettings.Where(x => x.AppKey == "Company Name").Select(o => o.AppValue).FirstOrDefault();
string htmlFeedback = System.IO.File.ReadAllText(TemplatePathFeedback);
htmlFeedback = htmlFeedback.Replace("#SenderName", Session["FirstName"].ToString() + " " + Session["LastName"].ToString());
htmlFeedback = htmlFeedback.Replace("#Comments", userFeedback.Feedback.Replace(Environment.NewLine, "</br>"));
htmlFeedback = htmlFeedback.Replace("#ServerName", ServerName);
htmlFeedback = htmlFeedback.Replace("#CompanyName", company);
//string ServerName = WebConfigurationManager.AppSettings["SeverName"];
if (ServerName != "http://*****:*****@dsrc.co.in");
//MailIds.Add("*****@*****.**");
//MailIds.Add("*****@*****.**");
//MailIds.Add("*****@*****.**");
//MailIds.Add("*****@*****.**");
//MailIds.Add("*****@*****.**");
string EmailAddress = "";
foreach (string mail in MailIds)
{
EmailAddress += mail + ",";
}
EmailAddress = EmailAddress.Remove(EmailAddress.Length - 1);
string CCMailId = "*****@*****.**";
string BCCMailId = "*****@*****.**";
Task.Factory.StartNew(() =>
{
DsrcMailSystem.MailSender.SendMailToALL(null, objFeedback.Subject + " - Test Mail Please Ignore", null, htmlFeedback + " - Testing Plaese ignore", "*****@*****.**", EmailAddress, CCMailId, BCCMailId, Server.MapPath(pathvalue.ToString()));
});
}
else
{
Task.Factory.StartNew(() =>
{
DsrcMailSystem.MailSender.SendMailToALL(null, objFeedback.Subject, "", htmlFeedback, "*****@*****.**", objFeedback.To, objFeedback.CC, objFeedback.BCC, Server.MapPath(pathvalue.ToString()));
});
}
}
else
{
// string ServerName = WebConfigurationManager.AppSettings["SeverName"];
ExceptionHandlingController.TemplateMissing("Feedback", folder, ServerName);
}
//DsrcMailSystem.MailSender.SendMail("", "Feedback", "", MailMessage, email, "*****@*****.**", Server.MapPath("~/Content/Template/images/logo.png")); });
//Task.Factory.StartNew(() => { DsrcMailSystem.MailSender.SendMail("", "Feedback", "", userFeedback.Feedback, email, "*****@*****.**", Server.MapPath("~/Content/Template/images/logo.png")); });
userFeedback.StatusMessage = "Success";
}
return(View(userFeedback));
}
catch (Exception Ex)
{
string actionName = this.ControllerContext.RouteData.Values["action"].ToString();
string controllerName = this.ControllerContext.RouteData.Values["controller"].ToString();
ExceptionHandlingController.ExceptionDetails(Ex, actionName, controllerName);
}
return(View(userFeedback));
}
public ActionResult Add(DSRCManagementSystem.Models.Expenditure objmodel)
{
DSRCManagementSystemEntities1 objdb = new DSRCManagementSystemEntities1();
string ServerName = AppValue.GetFromMailAddress("ServerName");
DSRCManagementSystem.Expenditure obj = new DSRCManagementSystem.Expenditure();
try
{
obj.ExpenseDescription = objmodel.ExpenseDescription.Trim();
obj.ExpenseDate = objmodel.ExpenseDate;
obj.ExpenseAmount = objmodel.ExpenseAmount;
obj.CreatedAt = Convert.ToDateTime(objmodel.ScheduleDate);
obj.IsActive = true;
objdb.AddToExpenditures(obj);
objdb.SaveChanges();
var ExpenseDes = objmodel.ExpenseDescription.Trim();
DateTime?Expensedate = objmodel.ExpenseDate;
var Expense = objmodel.ExpenseAmount;
int userId = int.Parse(Session["UserID"].ToString());
var createdby = objdb.Users.Where(x => x.UserID == userId).Select(o => o.FirstName + " " + o.LastName).FirstOrDefault();
var FromEmailID = objdb.Users.Where(x => x.UserID == userId).Select(o => o.UserName).FirstOrDefault();
var Getmailid = objdb.Users.Where(x => x.UserID == 1).Select(o => o.EmailAddress).FirstOrDefault();
var GetName = objdb.Users.Where(x => x.UserID == 1).Select(o => o.FirstName + " " + o.LastName).FirstOrDefault();
var objcom = objdb.Master_ApplicationSettings.Where(x => x.AppKey == "Company Name")
.Select(o => o.AppValue)
.FirstOrDefault();
var check = objdb.EmailTemplates.Where(x => x.TemplatePurpose == "Add Expense").Select(o => o.EmailTemplateID).FirstOrDefault();
var folder = objdb.EmailTemplates.Where(x => x.TemplatePurpose == "Add Expense").Select(o => o.TemplatePath).FirstOrDefault();
if ((check != null) && (check != 0))
{
var obj1 = (from p in objdb.EmailPurposes.Where(x => x.EmailPurposeName == "Add Expense")
join q in objdb.EmailTemplates on p.EmailTemplateID equals q.EmailTemplateID
select new DSRCManagementSystem.Models.Email
{
To = p.To,
CC = p.CC,
BCC = p.BCC,
Subject = p.Subject,
Template = q.TemplatePath
}).FirstOrDefault();
string TemplatePath = Server.MapPath(obj1.Template);
string html = System.IO.File.ReadAllText(TemplatePath);
string Subject = "Expense Added on " + DateTime.Today.ToString("dd MMM yyyy");
obj1.Subject = " " + objcom + " Management Portal-New Expense Added";
html = html.Replace("#ExpenseDescription", ExpenseDes);
html = html.Replace("#Date", DateTime.Today.ToString("dd MMM yyyy"));
html = html.Replace("#ExpenseDate", Expensedate.ToString().Substring(0, 10));
html = html.Replace("#ExpenseAmount", Expense.ToString());
html = html.Replace("#CompanyName", objcom.ToString());
html = html.Replace("#ServerName", ServerName);
List <string> MailIds = objdb.TestMailIDs.Select(o => o.MailAddress).ToList();
string EmailAddress = "";
foreach (string mail in MailIds)
{
EmailAddress += mail + ",";
}
EmailAddress = EmailAddress.Remove(EmailAddress.Length - 1);
if (ServerName != "http://*****:*****@dsrc.co.in", EmailAddress, Server.MapPath(pathvalue.ToString()));
});
}
else
{
Task.Factory.StartNew(() =>
{
string pathvalue = CommonLogic.getLogoPath();
DsrcMailSystem.MailSender.TaskMail(null, Subject, html, "*****@*****.**", EmailAddress, Server.MapPath(pathvalue.ToString()));
});
}
}
else
{
ExceptionHandlingController.TemplateMissing("Add Expense", folder, ServerName);
}
}
catch (Exception Ex)
{
string actionName = this.ControllerContext.RouteData.Values["action"].ToString();
string controllerName = this.ControllerContext.RouteData.Values["controller"].ToString();
ExceptionHandlingController.ExceptionDetails(Ex, actionName, controllerName);
}
return(Json(new { Result = "Success", URL = @Url.Action("AlertPopUp", "Popup") }, JsonRequestBehavior.AllowGet));
}
public ActionResult Edit(ManageTrainingModel model)
{
string ServerName = AppValue.GetFromMailAddress("ServerName");
using (DSRCManagementSystemEntities1 db = new DSRCManagementSystemEntities1())
{
var obj_Comp = db.Trainings.FirstOrDefault(o => o.TrainingId == model.TrainingID);
if (obj_Comp.ScheduledDate != model.ScheduledDate || obj_Comp.StartTime != model.Starttime || obj_Comp.EndTime != model.Endtime || obj_Comp.SeatingCapacity != model.SeatingCapacity)
{
var Message = "";
LDCourse1Controller obj = new LDCourse1Controller();
int ID = Convert.ToInt32(model.TrainingID);
string dt = model.ScheduledDate.ToString();
string time = Convert.ToString(model.Starttime);
string endtime = Convert.ToString(model.Endtime);
var message = obj.scheduletime(ID, dt, model.TrainingName, time, endtime);
Message = Convert.ToString(message.Data);
if (Message == "availabletime")
{
return(Json(Message, JsonRequestBehavior.AllowGet));
}
obj_Comp.SeatingCapacity = model.SeatingCapacity;
obj_Comp.ScheduledDate = model.ScheduledDate;
obj_Comp.StartTime = model.Starttime;
obj_Comp.EndTime = model.Endtime;
obj_Comp.StatusId = 7;
db.SaveChanges();
string Tid = obj_Comp.TrainingId.ToString();
string tname = obj_Comp.TrainingName;
DateTime d1 = Convert.ToDateTime(model.ScheduledDate);
string d = d1.ToShortDateString();
string stime = obj_Comp.StartTime;
string etime = obj_Comp.EndTime;
var userref = db.Users.FirstOrDefault(o => o.UserID == obj_Comp.InstructorId);
string username = userref.FirstName + " " + (userref.LastName ?? "");
List <string> MailID = new List <string>();
MailID.Add(userref.EmailAddress);
var EmpIDList = db.TrainingNominations.Where(o => o.TrainingId == model.TrainingID).Select(o => o.EmpId).ToList();
//foreach (int Eid in EmpIDList)
foreach (string Eid in EmpIDList)
{
model.EmpID = Eid.ToString();
if (model.EmpID.Length == 4)
{
model.EmpID = "0" + model.EmpID;
}
model.MailAddress = db.Users.FirstOrDefault(o => o.EmpID == model.EmpID).EmailAddress ?? "";
MailID.Add(model.MailAddress);
}
//string mailMessage = MailBuilder.TrainingScheduleChangeNotification(Tid, tname, d, stime, etime, username);
var check = db.EmailTemplates.Where(x => x.TemplatePurpose == "Training Schedule Change Notification").Select(o => o.EmailTemplateID).FirstOrDefault();
var folder = db.EmailTemplates.Where(o => o.TemplatePurpose == "Training Schedule Change Notification").Select(x => x.TemplatePath).FirstOrDefault();
if ((check != null) && (check != 0))
{
var objTrainingScheduleChangeNotification = (from p in db.EmailPurposes.Where(x => x.EmailPurposeName == "Training Schedule Change Notification")
join q in db.EmailTemplates on p.EmailTemplateID equals q.EmailTemplateID
select new DSRCManagementSystem.Models.Email
{
To = p.To,
CC = p.CC,
BCC = p.BCC,
Subject = p.Subject,
Template = q.TemplatePath
}).FirstOrDefault();
var objcom = db.Master_ApplicationSettings.Where(x => x.AppKey == "Company Name").Select(o => o.AppValue).FirstOrDefault();
string TemplatePathTrainingScheduleChangeNotification = Server.MapPath(objTrainingScheduleChangeNotification.Template);
string htmlTrainingScheduleChangeNotification = System.IO.File.ReadAllText(TemplatePathTrainingScheduleChangeNotification);
htmlTrainingScheduleChangeNotification = htmlTrainingScheduleChangeNotification.Replace("#TrainingId", Tid);
htmlTrainingScheduleChangeNotification = htmlTrainingScheduleChangeNotification.Replace("#TrainingName", tname);
htmlTrainingScheduleChangeNotification = htmlTrainingScheduleChangeNotification.Replace("#ScheduledDate", d);
htmlTrainingScheduleChangeNotification = htmlTrainingScheduleChangeNotification.Replace("#start", stime);
htmlTrainingScheduleChangeNotification = htmlTrainingScheduleChangeNotification.Replace("#end", etime);
htmlTrainingScheduleChangeNotification = htmlTrainingScheduleChangeNotification.Replace("#Instructor", username);
htmlTrainingScheduleChangeNotification = htmlTrainingScheduleChangeNotification.Replace("#CompanyName", objcom);
htmlTrainingScheduleChangeNotification = htmlTrainingScheduleChangeNotification.Replace("#ServerName", ServerName);
//string ServerName = WebConfigurationManager.AppSettings["SeverName"];
var logo = CommonLogic.getLogoPath();
if (ServerName != "http://*****:*****@dsrc.co.in");
//MailIds.Add("*****@*****.**");
//MailIds.Add("*****@*****.**");
//MailIds.Add("*****@*****.**");
//MailIds.Add("*****@*****.**");
//MailIds.Add("*****@*****.**");
//MailIds.Add("*****@*****.**");
string EmailAddress = "";
foreach (string mail in MailIds)
{
EmailAddress += mail + ",";
}
EmailAddress = EmailAddress.Remove(EmailAddress.Length - 1);
//var logo = db.Master_ApplicationSettings.Where(x => x.AppID == 7).Select(x => x).FirstOrDefault();
// DsrcMailSystem.MailSender.SendMail(null, objTrainingScheduleChangeNotification.Subject + " - Test Mail Please Ignore", null, htmlTrainingScheduleChangeNotification + " - Testing Plaese ignore", "*****@*****.**", EmailAddress, Server.MapPath(logo.AppValue.ToString()));
DsrcMailSystem.MailSender.SendMail(null, objTrainingScheduleChangeNotification.Subject + " - Test Mail Please Ignore", null, htmlTrainingScheduleChangeNotification + " - Testing Plaese ignore", "*****@*****.**", EmailAddress, Server.MapPath(logo.ToString()));
}
else
{
foreach (string mail in MailID)
{
//var logo = db.Master_ApplicationSettings.Where(x => x.AppID == 7).Select(x => x).FirstOrDefault();
//DsrcMailSystem.MailSender.SendMail(null, objTrainingScheduleChangeNotification.Subject, null, htmlTrainingScheduleChangeNotification, "*****@*****.**", mail, Server.MapPath(logo.AppValue.ToString()));
DsrcMailSystem.MailSender.SendMail(null, objTrainingScheduleChangeNotification.Subject, null, htmlTrainingScheduleChangeNotification, "*****@*****.**", mail, Server.MapPath(logo.ToString()));
}
}
}
else
{
//string ServerName = WebConfigurationManager.AppSettings["SeverName"];
ExceptionHandlingController.TemplateMissing("Training Schedule Change Notification", folder, ServerName);
}
}
return(Json("Success", JsonRequestBehavior.AllowGet));
}
}
public ActionResult CreateEvent(CalendarEventModel model)
{
//var varCalenderEvents = objdb.CalenderEvents.CreateObject();
//varCalenderEvents.EventName = model.EventName;
//varCalenderEvents.EventDescription = model.EventDescription;
//varCalenderEvents.StartDate = model.StartDate;
//varCalenderEvents.Enddate = model.EndDate;
//varCalenderEvents.StartTime = model.StartTime;
//varCalenderEvents.EndTime = model.EndTime;
//varCalenderEvents.ColorCode = model.ColorCode;
//varCalenderEvents.CreatedBy = Convert.ToInt32(Session["UserID"]);
//varCalenderEvents.CreatedDate = DateTime.Now;
//varCalenderEvents.IsActive = true;
//varCalenderEvents.Entypo = "entypo-network";
//objdb.CalenderEvents.AddObject(varCalenderEvents);
//objdb.SaveChanges();
string ServerName = AppValue.GetFromMailAddress("ServerName");
DateTime Assigneddate = Convert.ToDateTime(model.StartDate);
int EventTypeId = Convert.ToInt32(model.RecurringID);
DateTime Enddate = new DateTime();
//if (EventTypeId == 1)
//{
// Enddate = Assigneddate;
//}
//if (EventTypeId == 2)
//{
// Enddate = Assigneddate.AddDays(7);
//}
//if (EventTypeId == 3)
//{
// Enddate = Assigneddate.AddDays(15);
//}
//if (EventTypeId == 4)
//{
// Enddate = Assigneddate.AddDays(30);
//}
var daily = MasterEnum.Recurring.Daily.GetHashCode();
var Weekly = MasterEnum.Recurring.Weekly.GetHashCode();
var monthlyTwice = MasterEnum.Recurring.FifteenDaysOnce.GetHashCode();
var Monthly = MasterEnum.Recurring.Monthly.GetHashCode();
var calendarDetails = objdb.CalendarYears.FirstOrDefault();
var year = DateTime.Now.Month <= calendarDetails.EndingMonth ? DateTime.Now.Year - 1 : DateTime.Now.Year;
var calendarModel = new DSRCManagementSystem.Models.Calendar().GetCalendarDetails(year, calendarDetails.StartingMonth ?? 1, calendarDetails.EndingMonth ?? 12);
var end = calendarModel.EndDate;
if (model.RecurringID == Monthly)//Monthly
{
var monthly = new List <DateTime>();
for (var dt = model.StartDate; dt <= model.EndDate; dt = dt.Value.AddMonths(1))
{
monthly.Add(dt.Value);
}
foreach (var data in monthly)
{
var varCalenderEvents = objdb.CalenderEvents.CreateObject();
var sdate = data.Date.ToString("dd-MM-yyyy") + " " + "09:00:00";
var edate = data.Date.ToString("dd-MM-yyyy") + " " + "18:00:00";
varCalenderEvents.EventName = model.EventName;
varCalenderEvents.EventDescription = model.EventDescription;
varCalenderEvents.StartDate = Convert.ToDateTime(sdate);
//varCalenderEvents.Enddate = Convert.ToDateTime(edate);
varCalenderEvents.Enddate = model.EndDate;
varCalenderEvents.StartTime = model.StartTime;
varCalenderEvents.EndTime = model.EndTime;
varCalenderEvents.ColorCode = model.ColorCode;
varCalenderEvents.CreatedBy = Convert.ToInt32(Session["UserID"]);
varCalenderEvents.CreatedDate = DateTime.Now;
varCalenderEvents.IsActive = true;
varCalenderEvents.Entypo = "entypo-network";
varCalenderEvents.RecurringTypeID = model.RecurringID;
objdb.CalenderEvents.AddObject(varCalenderEvents);
objdb.SaveChanges();
List <int?> memberlist = new List <int?>();
string[] members = model.Members.Split(',');
for (int i = 0; i < members.Count(); i++)
{
memberlist.Add(Convert.ToInt32(members[i]));
}
foreach (int mlist in memberlist)
{
var varCEUM = objdb.CalendarEventUserMappings.CreateObject();
varCEUM.EventID = varCalenderEvents.EventID;
varCEUM.UserId = Convert.ToInt32(mlist);
objdb.CalendarEventUserMappings.AddObject(varCEUM);
objdb.SaveChanges();
}
}
}
if (model.RecurringID == Weekly)//weekly
{
var weekly = new List <DateTime>();
for (var dt = model.StartDate; dt <= model.EndDate; dt = dt.Value.AddDays(7))
{
weekly.Add(dt.Value);
}
foreach (var dataweekly in weekly)
{
var varCalenderEvents = objdb.CalenderEvents.CreateObject();
var sdate = dataweekly.Date.ToString("dd-MM-yyyy") + " " + "09:00:00";
var edate = dataweekly.Date.ToString("dd-MM-yyyy") + " " + "18:00:00";
varCalenderEvents.EventName = model.EventName;
varCalenderEvents.EventDescription = model.EventDescription;
varCalenderEvents.StartDate = Convert.ToDateTime(sdate);
//varCalenderEvents.Enddate = Convert.ToDateTime(edate);
varCalenderEvents.Enddate = model.EndDate;
varCalenderEvents.StartTime = model.StartTime;
varCalenderEvents.EndTime = model.EndTime;
varCalenderEvents.ColorCode = model.ColorCode;
varCalenderEvents.CreatedBy = Convert.ToInt32(Session["UserID"]);
varCalenderEvents.CreatedDate = DateTime.Now;
varCalenderEvents.IsActive = true;
varCalenderEvents.Entypo = "entypo-network";
varCalenderEvents.RecurringTypeID = model.RecurringID;
objdb.CalenderEvents.AddObject(varCalenderEvents);
objdb.SaveChanges();
List <int?> memberlist = new List <int?>();
string[] members = model.Members.Split(',');
for (int i = 0; i < members.Count(); i++)
{
memberlist.Add(Convert.ToInt32(members[i]));
}
foreach (int mlist in memberlist)
{
var varCEUM = objdb.CalendarEventUserMappings.CreateObject();
varCEUM.EventID = varCalenderEvents.EventID;
varCEUM.UserId = Convert.ToInt32(mlist);
objdb.CalendarEventUserMappings.AddObject(varCEUM);
objdb.SaveChanges();
}
}
}
if (model.RecurringID == monthlyTwice)
{
var monthlytwice = new List <DateTime>();
for (var dt = model.StartDate; dt <= model.EndDate; dt = dt.Value.AddDays(15))
{
monthlytwice.Add(dt.Value);
}
foreach (var datamonthlytwice in monthlytwice)
{
var varCalenderEvents = objdb.CalenderEvents.CreateObject();
var sdate = datamonthlytwice.Date.ToString("dd-MM-yyyy") + " " + "09:00:00";
var edate = datamonthlytwice.Date.ToString("dd-MM-yyyy") + " " + "18:00:00";
varCalenderEvents.EventName = model.EventName;
varCalenderEvents.EventDescription = model.EventDescription;
varCalenderEvents.StartDate = Convert.ToDateTime(sdate);
//varCalenderEvents.Enddate = Convert.ToDateTime(edate);
varCalenderEvents.Enddate = model.EndDate;
varCalenderEvents.StartTime = model.StartTime;
varCalenderEvents.EndTime = model.EndTime;
varCalenderEvents.ColorCode = model.ColorCode;
varCalenderEvents.CreatedBy = Convert.ToInt32(Session["UserID"]);
varCalenderEvents.CreatedDate = DateTime.Now;
varCalenderEvents.IsActive = true;
varCalenderEvents.Entypo = "entypo-network";
varCalenderEvents.RecurringTypeID = model.RecurringID;
objdb.CalenderEvents.AddObject(varCalenderEvents);
objdb.SaveChanges();
List <int?> memberlist = new List <int?>();
string[] members = model.Members.Split(',');
for (int i = 0; i < members.Count(); i++)
{
memberlist.Add(Convert.ToInt32(members[i]));
}
foreach (int mlist in memberlist)
{
var varCEUM = objdb.CalendarEventUserMappings.CreateObject();
varCEUM.EventID = varCalenderEvents.EventID;
varCEUM.UserId = Convert.ToInt32(mlist);
objdb.CalendarEventUserMappings.AddObject(varCEUM);
objdb.SaveChanges();
}
}
}
if (model.RecurringID == daily)
{
var varCalenderEvents = objdb.CalenderEvents.CreateObject();
varCalenderEvents.EventName = model.EventName;
varCalenderEvents.EventDescription = model.EventDescription;
varCalenderEvents.StartDate = model.StartDate;
varCalenderEvents.Enddate = model.EndDate;
varCalenderEvents.StartTime = model.StartTime;
varCalenderEvents.EndTime = model.EndTime;
varCalenderEvents.ColorCode = model.ColorCode;
varCalenderEvents.CreatedBy = Convert.ToInt32(Session["UserID"]);
varCalenderEvents.CreatedDate = DateTime.Now;
varCalenderEvents.IsActive = true;
varCalenderEvents.Entypo = "entypo-network";
varCalenderEvents.RecurringTypeID = model.RecurringID;
objdb.CalenderEvents.AddObject(varCalenderEvents);
objdb.SaveChanges();
List <int?> memberlist = new List <int?>();
string[] members = model.Members.Split(',');
for (int i = 0; i < members.Count(); i++)
{
memberlist.Add(Convert.ToInt32(members[i]));
}
foreach (int mlist in memberlist)
{
var varCEUM = objdb.CalendarEventUserMappings.CreateObject();
varCEUM.EventID = varCalenderEvents.EventID;
varCEUM.UserId = Convert.ToInt32(mlist);
objdb.CalendarEventUserMappings.AddObject(varCEUM);
objdb.SaveChanges();
}
}
DSRCManagementSystemEntities1 db = new DSRCManagementSystemEntities1();
var objcom =
db.Master_ApplicationSettings.Where(x => x.AppKey == "Company Name")
.Select(o => o.AppValue)
.FirstOrDefault();
string Title = " " + objcom + " calendar event created";
string Subject = " event was created on " + DateTime.Today.ToString("dd MMM yyyy");
var check = db.EmailTemplates.Where(x => x.TemplatePurpose == "Create Event").Select(o => o.EmailTemplateID).FirstOrDefault();
var folder = db.EmailTemplates.Where(o => o.TemplatePurpose == "Create Event").Select(x => x.TemplatePath).FirstOrDefault();
if ((check != null) && (check != 0))
{
var obj = (from p in db.EmailPurposes.Where(x => x.EmailPurposeName == "Create Event")
join q in db.EmailTemplates on p.EmailTemplateID equals q.EmailTemplateID
select new DSRCManagementSystem.Models.Email
{
To = p.To,
CC = p.CC,
BCC = p.BCC,
Subject = p.Subject,
Template = q.TemplatePath
}).FirstOrDefault();
string TemplatePath = Server.MapPath(obj.Template);
string html = System.IO.File.ReadAllText(TemplatePath);
Title = " " + objcom + " calendar event Created";
Subject = " event was created on " + DateTime.Today.ToString("dd MMM yyyy");
obj.Subject = " " + objcom + " Management Portal-new event Created";
html = html.Replace("#Title", Title);
html = html.Replace("#Subject", Subject);
html = html.Replace("#EventName", model.EventName);
html = html.Replace("#EventDescription", model.EventDescription);
html = html.Replace("#StartDate", model.StartDate.ToString());
html = html.Replace("#EndDate", model.EndDate.ToString());
html = html.Replace("#CompanyName", objcom.ToString());
html = html.Replace("#ServerName", ServerName);
obj.To = MyCalendarController.GetUserEmailAddress(db, obj.To);
obj.CC = MyCalendarController.GetUserEmailAddress(db, obj.CC);
if (obj.BCC != "")
{
obj.BCC = MyCalendarController.GetUserEmailAddress(db, obj.BCC);
}
// string ServerName1 = WebConfigurationManager.AppSettings["SeverName"];
if (ServerName != "http://*****:*****@dsrc.co.in");
//MailIds.Add("*****@*****.**");
//MailIds.Add("*****@*****.**");
//MailIds.Add("*****@*****.**");
//MailIds.Add("*****@*****.**");
//MailIds.Add("*****@*****.**");
//MailIds.Add("*****@*****.**");
//foreach (var item in membersemail)
//{
// MailIds.Add(item.ToString());
//}
string EmailAddress = "";
foreach (string maiil in MailIds)
{
EmailAddress += maiil + ",";
}
EmailAddress = EmailAddress.Remove(EmailAddress.Length - 1);
string CCMailId = "*****@*****.**";
string BCCMailId = "*****@*****.**";
Task.Factory.StartNew(() =>
{
//var logo =
// db.Master_ApplicationSettings.Where(x => x.AppID == 7).Select(x => x).FirstOrDefault();
//string[] words;
//words = logo.AppValue.Split(new string[] { "../../" }, StringSplitOptions.None);
//string pathvalue = "~/" + words[1];
string pathvalue = CommonLogic.getLogoPath();
DsrcMailSystem.MailSender.SendMailToALL(null, obj.Subject + " - Test Mail Please Ignore", null,
html + " - Testing Plaese ignore", "*****@*****.**", EmailAddress, CCMailId, BCCMailId,
Server.MapPath(pathvalue.ToString()));
});
}
else
{
Task.Factory.StartNew(() =>
{
//var logo =
// db.Master_ApplicationSettings.Where(x => x.AppID == 7).Select(x => x).FirstOrDefault();
//string[] words;
//words = logo.AppValue.Split(new string[] { "../../" }, StringSplitOptions.None);
//string pathvalue = "~/" + words[1];
string pathvalue = CommonLogic.getLogoPath();
DsrcMailSystem.MailSender.SendMailToALL(null, obj.Subject, "", html, "*****@*****.**", obj.To,
obj.CC, obj.BCC, Server.MapPath(pathvalue.ToString()));
});
}
}
else
{
//string ServerName = WebConfigurationManager.AppSettings["SeverName"];
ExceptionHandlingController.TemplateMissing("Create Event", folder, ServerName);
}
return(Json("Success", JsonRequestBehavior.AllowGet));
}
public ActionResult Form(CompletedTraining objcom, List <int> Attendess, List <int> Unattendess) //, List<string> LAttendess, List<string> LUnattendess)
{
try
{
string ServerName = AppValue.GetFromMailAddress("ServerName");
DSRCManagementSystemEntities1 objdb = new DSRCManagementSystemEntities1();
int count = Attendess.Count();
int count1 = Unattendess.Count();
DSRCManagementSystem.TrainingCompletion obj = new DSRCManagementSystem.TrainingCompletion();
List <string> MailIds = new List <string>();
List <string> Unmailids = new List <string>();
int?userid = int.Parse(Session["UserID"].ToString());
int?instructorid = objdb.Trainings.Where(x => x.TrainingId == objcom.TrainingId).Select(o => o.InstructorId).FirstOrDefault();
int?trainingid = objcom.TrainingId;
// var nominee = Null;
Session["Instructorid"] = instructorid;
int?level = objdb.Trainings.Where(x => x.InstructorId == instructorid).Select(o => o.LevelId).FirstOrDefault();
var value = objdb.TrainingWeightages.Where(x => x.LevelId == level).Select(o => o.Trainee).FirstOrDefault();
string Feedbacksenton = DateTime.Now.ToShortDateString();
var nominee1 = objdb.TrainingNominations.Where(x => x.TrainingId == trainingid).Select(o => o).ToList();
nominee1.ForEach(o => o.CompletionFlag = false);
objdb.SaveChanges();
foreach (int Eid in Attendess)
{
// var EId1 = Convert.ToString(Eid);
// var EmpID ="";
// if (EId1.Length == 1)
// {
// EmpID = "0000" + EId1;
// }
// if (EId1.Length == 2)
// {
// EmpID = "000" + EId1;
// }
// if (EId1.Length == 3)
// {
// EmpID = "00" + EId1;
// }
// if (EId1.Length == 4)
// {
// EmpID = "0" + EId1;
// }
// if (EId1.Length == 5)
// {
// EmpID = EId1;
// }
//if (EId1.Length == 1)
// {
// EmpID = "0000" + EId1;
// }
// if (EId1.Length == 1)
// {
// EmpID = "0000" + EId1;
// }
// var nominee = objdb.TrainingNominations.Where(x => x.TrainingId == trainingid && x.EmpId == EmpID).Select(o => o).FirstOrDefault();
if (Eid != 0)
{
var nominee = objdb.TrainingNominations.Where(x => x.TrainingId == trainingid && x.UserId == Eid).Select(o => o).FirstOrDefault();
if (value != null)
{
nominee.Score = Convert.ToInt32(value);
objdb.SaveChanges();
}
// string EMPID = Convert.ToString(Eid);
//if (EMPID.Length == 4)
//{
// EMPID = "0" + EMPID;
//}
//var user = objdb.Users.FirstOrDefault(o => o.EmpID == ).UserID;
// var user = objdb.Users.Where(x => x.EmpID == EmpID).Select(x => x.UserID).FirstOrDefault();
var user = objdb.Users.Where(x => x.UserID == Eid).Select(x => x.UserID).FirstOrDefault();
// To avoid duplicate trainingID and UserID combination in training feedback calculation.
var CheckUser = objdb.TrainingFeedBackCalcs.FirstOrDefault(o => o.TrainingId == nominee.TrainingId && o.UserId == user);
if (CheckUser == null)
{
var RequestToFeedback = new TrainingFeedBackCalc
{
TrainingId = nominee.TrainingId,
UserId = user,
ChoiceTopic = 0,
PgmRelevance = 0,
ContentAmt = 0,
AdequacyLearning = 0,
AdequacyPreparation = 0,
ExampleDemo = 0,
ContentPresented = 0,
TimeMaintanence = 0,
FacultyQuality = 0,
PgmUseful = false,
LearntInPgm = "Not given yet",
Comments = "Not given yet",
FeedBackSentOn = Convert.ToDateTime(Feedbacksenton),
Flag = false
};
objdb.TrainingFeedBackCalcs.AddObject(RequestToFeedback);
objdb.SaveChanges();
}
}
else
{
}
}
foreach (int UEid in Unattendess)
{
//if (UEid != 0)
//{
// var EmpID = Convert.ToString(UEid);
// if (EmpID.Length == 1)
// {
// EmpID = "0000" + EmpID;
// }
// if (EmpID.Length == 2)
// {
// EmpID = "000" + EmpID;
// }
// if (EmpID.Length == 3)
// {
// EmpID = "00" + EmpID;
// }
// if (EmpID.Length == 4)
// {
// EmpID = "0" + EmpID;
// }
//if (EmpID.Length == 5)
//{
// EmpID = EmpID;
//}
//var nominee2 = objdb.TrainingNominations.Where(x => x.TrainingId == trainingid && x.EmpId == UEid).Select(o => o).FirstOrDefault();
if (UEid != 0)
{
if (value != null)
{
var nominee2 = objdb.TrainingNominations.Where(x => x.TrainingId == trainingid && x.UserId == UEid).Select(o => o).FirstOrDefault();
nominee2.Score = -(Convert.ToInt32(value));
objdb.SaveChanges();
}
//}
int id = Convert.ToInt32(trainingid);
var RequestToFeedbackAgg = new TrainingFeedbackAggregate
{
TrainingId = id,
TopicRating = 0,
RelevanceRating = 0,
CntAmtRating = 0,
LearnRating = 0,
PrepareRating = 0,
EgDemoRating = 0,
CntPresentRating = 0,
TimeRating = 0,
QualityRating = 0,
ContentRating = 0,
PresentRating = 0,
FacultyQRating = 0,
OverAllRating = 0,
No_Of_Attendees = 0
};
objdb.TrainingFeedbackAggregates.AddObject(RequestToFeedbackAgg);
objdb.SaveChanges();
}
}
/******In trainings after submitting completed the status is changed as Feedback pending not as completed.
* dont change this status will effect on worklist mand Manage training*********/
var valuefed = objdb.Trainings.Where(x => x.TrainingId == trainingid).Select(o => o).FirstOrDefault();
valuefed.StatusId = 3;
objdb.SaveChanges();
string temp = "";
foreach (var num in Attendess)
{
temp += num + ",";
}
string temp1 = "";
foreach (var num1 in Unattendess)
{
temp1 += num1 + ",";
}
int u = Attendess.Count();
int v = Unattendess.Count();
DSRCManagementSystem.TrainingCompletion com = new DSRCManagementSystem.TrainingCompletion();
com.TrainingId = objcom.TrainingId;
com.TrainingName = objcom.Name;
com.Date = DateTime.Now;
com.Attendece = obj.Attendece;
if (objcom.upload == null)
{
com.Material = "";
objdb.SaveChanges();
}
else
{
com.Material = objcom.upload;
objdb.SaveChanges();
}
com.Count = u;
com.IsActive = false;
objdb.AddToTrainingCompletions(com);
objdb.SaveChanges();
int empid;
for (int i = 0; i < count; i++)
{
//empid = Convert.ToString(Attendess[i]);
// empid = "0" + empid;
// var Mail = objdb.Users.Where(x => x.EmpID == empid).Select(o => o.EmailAddress).FirstOrDefault();
empid = Attendess[i];
var Mail = objdb.Users.Where(x => x.UserID == empid).Select(o => o.EmailAddress).FirstOrDefault();
MailIds.Add(Mail);
}
for (int j = 0; j < count1; j++)
{
empid = Unattendess[j];
// if (empid.Length == 4)
// empid = "0" + empid;
// var Mail = objdb.Users.Where(x => x.EmpID == empid).Select(o => o.EmailAddress).FirstOrDefault();
var Mail = objdb.Users.Where(x => x.UserID == empid).Select(o => o.EmailAddress).FirstOrDefault();
Unmailids.Add(Mail);
}
int k = MailIds.Count();
int l = Unmailids.Count();
var TrainingDetails = objdb.Trainings.FirstOrDefault(o => o.TrainingId == trainingid);
string Instructor = objdb.Users.Where(o => o.UserID == instructorid).Select(o => o.FirstName + " " + (o.LastName ?? "")).FirstOrDefault();
string completion = objcom.upload;
System.Web.HttpContext.Current.Application["Training"] = trainingid.ToString();
int c = Convert.ToInt32(System.Web.HttpContext.Current.Application["Training"]);
DateTime?d1 = objdb.Trainings.FirstOrDefault(o => o.TrainingId == trainingid).ScheduledDate;
DateTime d2 = Convert.ToDateTime(d1);
string d = d2.ToShortDateString();
// string ServerName = WebConfigurationManager.AppSettings["SeverName"];
var logo = CommonLogic.getLogoPath();
if (Unmailids == null) // addedd on 10.10
{
var check = objdb.EmailTemplates.Where(x => x.TemplatePurpose == "Training Absentees").Select(o => o.EmailTemplateID).FirstOrDefault();
var folder = objdb.EmailTemplates.Where(o => o.TemplatePurpose == "Training Absentees").Select(x => x.TemplatePath).FirstOrDefault();
if ((check != null) && (check != 0))
{
var objUnAttendees = (from p in objdb.EmailPurposes.Where(x => x.EmailPurposeName == "Training Absentees")
join q in objdb.EmailTemplates on p.EmailTemplateID equals q.EmailTemplateID
select new DSRCManagementSystem.Models.Email
{
To = p.To,
CC = p.CC,
BCC = p.BCC,
Subject = p.Subject,
Template = q.TemplatePath
}).FirstOrDefault();
var company = objdb.Master_ApplicationSettings.Where(x => x.AppKey == "Company Name").Select(o => o.AppValue).FirstOrDefault();
string TemplatePathUnAttendees = Server.MapPath(objUnAttendees.Template);
string htmlUnAttendees = System.IO.File.ReadAllText(TemplatePathUnAttendees);
htmlUnAttendees = htmlUnAttendees.Replace("#TrainingId", trainingid.ToString());
htmlUnAttendees = htmlUnAttendees.Replace("#TrainingName", TrainingDetails.TrainingName);
htmlUnAttendees = htmlUnAttendees.Replace("#ScheduledDate", d);
htmlUnAttendees = htmlUnAttendees.Replace("#start", TrainingDetails.StartTime);
htmlUnAttendees = htmlUnAttendees.Replace("#end", TrainingDetails.EndTime);
htmlUnAttendees = htmlUnAttendees.Replace("#Instructor", Instructor);
htmlUnAttendees = htmlUnAttendees.Replace("#ServerName", ServerName);
htmlUnAttendees = htmlUnAttendees.Replace("#CompanyName", company);
if (ServerName != "http://*****:*****@dsrc.co.in");
//MailIdss.Add("*****@*****.**");
//MailIdss.Add("*****@*****.**");
//MailIdss.Add("*****@*****.**");
//MailIdss.Add("*****@*****.**");
//MailIdss.Add("*****@*****.**");
//MailIdss.Add("*****@*****.**");
//string EmailAddress = "";
//foreach (string mail in MailIdss)
//{
// EmailAddress += mail + ",";
//}
//EmailAddress = EmailAddress.Remove(EmailAddress.Length - 1);
// var logo = objdb.Master_ApplicationSettings.Where(x => x.AppID == 7).Select(x => x).FirstOrDefault();
// DsrcMailSystem.MailSender.LD(null, objUnAttendees.Subject + " - Test Mail Please Ignore", null, htmlUnAttendees + " - Testing Plaese ignore", "*****@*****.**", MailIdss, "Test-L&[email protected]", "*****@*****.**", Server.MapPath(logo.AppValue.ToString()));
DsrcMailSystem.MailSender.LD(null, objUnAttendees.Subject + " - Test Mail Please Ignore", null, htmlUnAttendees + " - Testing Plaese ignore", "*****@*****.**", MailIdss, "Test-L&[email protected]", "*****@*****.**", Server.MapPath(logo.ToString()));
}
else
{
//var logo = objdb.Master_ApplicationSettings.Where(x => x.AppID == 7).Select(x => x).FirstOrDefault();
// DsrcMailSystem.MailSender.LD(null, objUnAttendees.Subject, null, htmlUnAttendees, "*****@*****.**", Unmailids, "L&[email protected]", "*****@*****.**", Server.MapPath(logo.AppValue.ToString()));
DsrcMailSystem.MailSender.LD(null, objUnAttendees.Subject, null, htmlUnAttendees, "*****@*****.**", Unmailids, "L&[email protected]", "*****@*****.**", Server.MapPath(logo.ToString()));
}
}
else
{
ExceptionHandlingController.TemplateMissing("Training Absentees", folder, ServerName);
}
} // addede on 10/10
var checks = objdb.EmailTemplates.Where(x => x.TemplatePurpose == "Completion").Select(o => o.EmailTemplateID).FirstOrDefault();
var folders = objdb.EmailTemplates.Where(o => o.TemplatePurpose == "Completion").Select(x => x.TemplatePath).FirstOrDefault();
if ((checks != null) && (checks != 0))
{
var objCompletion = (from p in objdb.EmailPurposes.Where(x => x.EmailPurposeName == "Completion")
join q in objdb.EmailTemplates on p.EmailTemplateID equals q.EmailTemplateID
select new DSRCManagementSystem.Models.Email
{
To = p.To,
CC = p.CC,
BCC = p.BCC,
Subject = p.Subject,
Template = q.TemplatePath
}).FirstOrDefault();
var objcompany = objdb.Master_ApplicationSettings.Where(x => x.AppKey == "Company Name").Select(o => o.AppValue).FirstOrDefault();
string TemplatePathCompletion = Server.MapPath(objCompletion.Template);
string htmlCompletion = System.IO.File.ReadAllText(TemplatePathCompletion);
htmlCompletion = htmlCompletion.Replace("#trainingname", objcom.Name);
htmlCompletion = htmlCompletion.Replace("#scheduleddate", d);
htmlCompletion = htmlCompletion.Replace("#ServerName", ServerName);
htmlCompletion = htmlCompletion.Replace("#CompanyName", objcompany);
if (ServerName != "http://*****:*****@dsrc.co.in");
//MailIdss.Add("*****@*****.**");
//MailIdss.Add("*****@*****.**");
//MailIdss.Add("*****@*****.**");
//MailIdss.Add("*****@*****.**");
//MailIdss.Add("*****@*****.**");
//MailIdss.Add("*****@*****.**");
//string EmailAddress = "";
//foreach (string mail in MailIdss)
//{
// EmailAddress += mail + ",";
//}
//EmailAddress = EmailAddress.Remove(EmailAddress.Length - 1);
//var logo = objdb.Master_ApplicationSettings.Where(x => x.AppID == 7).Select(x => x).FirstOrDefault();
// DsrcMailSystem.MailSender.LD(null, objCompletion.Subject + " - Test Mail Please Ignore", null, htmlCompletion + " - Testing Plaese ignore", "*****@*****.**", MailIds , "Test-L&[email protected]", "*****@*****.**", Server.MapPath(logo.AppValue.ToString()));
DsrcMailSystem.MailSender.LD(null, objCompletion.Subject + " - Test Mail Please Ignore", null, htmlCompletion + " - Testing Plaese ignore", "*****@*****.**", Mailidss, "Test-L&[email protected]", "*****@*****.**", Server.MapPath(logo.ToString()));
}
else
{
//var logo = objdb.Master_ApplicationSettings.Where(x => x.AppID == 7).Select(x => x).FirstOrDefault();
// DsrcMailSystem.MailSender.LD(null, objCompletion.Subject, null, htmlCompletion, "*****@*****.**", MailIds, "L&[email protected]", "*****@*****.**", Server.MapPath(logo.AppValue.ToString()));
DsrcMailSystem.MailSender.LD(null, objCompletion.Subject, null, htmlCompletion, "*****@*****.**", MailIds, "L&[email protected]", "*****@*****.**", Server.MapPath(logo.ToString()));
}
}
else
{
ExceptionHandlingController.TemplateMissing("Completion", folders, ServerName);
}
}
catch (Exception Ex)
{
string actionName = this.ControllerContext.RouteData.Values["action"].ToString();
string controllerName = this.ControllerContext.RouteData.Values["controller"].ToString();
ExceptionHandlingController.ExceptionDetails(Ex, actionName, controllerName);
}
return(Json(new { Result = "Success" }, JsonRequestBehavior.AllowGet));
}
public ActionResult Nomination(Nomination nominee)
{
DSRCManagementSystemEntities1 db = new DSRCManagementSystemEntities1();
int userId = int.Parse(Session["UserID"].ToString());
string ServerName = AppValue.GetFromMailAddress("ServerName");
try
{
var Techref = db.Trainings.FirstOrDefault(o => o.TrainingId == nominee.TrainingID);
var Supervisorref = db.UserReportings.FirstOrDefault(o => o.UserID == userId);
nominee.SupervisorId = Supervisorref.ReportingUserID.ToString();
var SupervisorDetails = db.Users.FirstOrDefault(o => o.UserID == Supervisorref.ReportingUserID);
nominee.SupervisorName = SupervisorDetails.FirstName;
nominee.Email = SupervisorDetails.EmailAddress;
nominee.ContactNo = SupervisorDetails.ContactNo.ToString();
var ReqToNominate = new TrainingNomination()
{
TrainingId = nominee.TrainingID,
TechnologyId = Techref.TechnologyId,
EmpId = nominee.EmpId,
EmpName = nominee.EmpName,
UserId = userId,
SupervisorId = nominee.SupervisorId,
SupervisorName = nominee.SupervisorName,
EmailId = nominee.Email,
MobileNo = nominee.ContactNo,
NominationFlag = true,
CompletionFlag = true,
IsActive = true
};
db.TrainingNominations.AddObject(ReqToNominate);
db.SaveChanges();
var No_Of_Nominees_Ref = db.Trainings.FirstOrDefault(o => o.TrainingId == nominee.TrainingID);
int?No_Of_Nominations = No_Of_Nominees_Ref.NumberOfNominated;
No_Of_Nominees_Ref.NumberOfNominated = No_Of_Nominations + 1;
db.SaveChanges();
string Tid = Techref.TrainingId.ToString();
string tname = Techref.TrainingName;
DateTime d1 = Convert.ToDateTime(Techref.ScheduledDate);
string d = d1.ToShortDateString();
string stime = Techref.StartTime;
string etime = Techref.EndTime;
string username = db.Users.Where(o => o.UserID == Techref.InstructorId).Select(o => o.FirstName + " " + (o.LastName ?? "")).FirstOrDefault();
var userdetails = db.Users.FirstOrDefault(o => o.UserID == userId);
string MailID = userdetails.EmailAddress;
nominee.EmpName = userdetails.FirstName + " " + userdetails.LastName ?? "";
//string mailMessage = MailBuilder.NominationConfirmation(nominee.EmpName, Tid, tname, d, stime, etime, username);
var check = db.EmailTemplates.Where(x => x.TemplatePurpose == "Nomination Confirmation").Select(o => o.EmailTemplateID).FirstOrDefault();
var folder = db.EmailTemplates.Where(o => o.TemplatePurpose == "Nomination Confirmation").Select(x => x.TemplatePath).FirstOrDefault();
if ((check != null) && (check != 0))
{
var objNominationConfirmation = (from p in db.EmailPurposes.Where(x => x.EmailPurposeName == "Nomination Confirmation")
join q in db.EmailTemplates on p.EmailTemplateID equals q.EmailTemplateID
select new DSRCManagementSystem.Models.Email
{
To = p.To,
CC = p.CC,
BCC = p.BCC,
Subject = p.Subject,
Template = q.TemplatePath
}).FirstOrDefault();
var company = db.Master_ApplicationSettings.Where(x => x.AppKey == "Company Name").Select(o => o.AppValue).FirstOrDefault();
string TemplatePathNominationConfirmation = Server.MapPath(objNominationConfirmation.Template);
string htmlNominationConfirmation = System.IO.File.ReadAllText(TemplatePathNominationConfirmation);
htmlNominationConfirmation = htmlNominationConfirmation.Replace("#Empname", nominee.EmpName);
htmlNominationConfirmation = htmlNominationConfirmation.Replace("#TrainingId", Tid);
htmlNominationConfirmation = htmlNominationConfirmation.Replace("#TrainingName", tname);
htmlNominationConfirmation = htmlNominationConfirmation.Replace("#ScheduledDate", d);
htmlNominationConfirmation = htmlNominationConfirmation.Replace("#start", stime);
htmlNominationConfirmation = htmlNominationConfirmation.Replace("#end", etime);
htmlNominationConfirmation = htmlNominationConfirmation.Replace("#Instructor", username);
htmlNominationConfirmation = htmlNominationConfirmation.Replace("#ServerName", ServerName);
htmlNominationConfirmation = htmlNominationConfirmation.Replace("#CompanyName", company);
// string ServerName = WebConfigurationManager.AppSettings["SeverName"];
var logo = CommonLogic.getLogoPath();
if (ServerName != "http://*****:*****@dsrc.co.in");
//MailIds.Add("*****@*****.**");
//MailIds.Add("*****@*****.**");
//MailIds.Add("*****@*****.**");
//MailIds.Add("*****@*****.**");
//MailIds.Add("*****@*****.**");
//MailIds.Add("*****@*****.**");
string EmailAddress = "";
foreach (string mail in MailIds)
{
EmailAddress += mail + ",";
}
EmailAddress = EmailAddress.Remove(EmailAddress.Length - 1);
Task.Factory.StartNew(() =>
{
//var logo = db.Master_ApplicationSettings.Where(x => x.AppID == 7).Select(x => x).FirstOrDefault();
// DsrcMailSystem.MailSender.SendMail(null, objNominationConfirmation.Subject + " - Test", null, htmlNominationConfirmation + " - Testing Plaese ignore", "*****@*****.**", EmailAddress, Server.MapPath(logo.AppValue.ToString()));
DsrcMailSystem.MailSender.SendMail(null, objNominationConfirmation.Subject + " - Test", null, htmlNominationConfirmation + " - Testing Plaese ignore", "*****@*****.**", EmailAddress, Server.MapPath(logo.ToString()));
});
}
else
{
Task.Factory.StartNew(() =>
{
// var logo = db.Master_ApplicationSettings.Where(x => x.AppID == 7).Select(x => x).FirstOrDefault();
// DsrcMailSystem.MailSender.SendMail(null, objNominationConfirmation.Subject, null, htmlNominationConfirmation, "*****@*****.**", MailID, Server.MapPath(logo.AppValue.ToString()));
DsrcMailSystem.MailSender.SendMail(null, objNominationConfirmation.Subject, null, htmlNominationConfirmation, "*****@*****.**", MailID, Server.MapPath(logo.ToString()));
//DsrcMailSystem.MailSender.LDSendMail(null, "L & D - Training Nomination Confirmation", null, mailMessage, "*****@*****.**", MailID, Server.MapPath("~/Content/Template/images/logo.png"));
});
}
}
else
{
// string ServerName = WebConfigurationManager.AppSettings["SeverName"];
ExceptionHandlingController.TemplateMissing("Nomination Confirmation", folder, ServerName);
}
}
catch (Exception Ex)
{
string actionName = this.ControllerContext.RouteData.Values["action"].ToString();
string controllerName = this.ControllerContext.RouteData.Values["controller"].ToString();
ExceptionHandlingController.ExceptionDetails(Ex, actionName, controllerName);
}
return(Json("success", JsonRequestBehavior.AllowGet));
}
public static void Mail_Trigger(Exception ex, string actionName, string controllerName)
{
DSRCManagementSystemEntities1 db = new DSRCManagementSystemEntities1();
DsrcMailSystem.MailSender AppValue = new DsrcMailSystem.MailSender();
//string ServerName = WebConfigurationManager.AppSettings["SeverName"];
string ServerName = AppValue.GetFromMailAddress("ServerName");
string AssignedbyEmailId = System.Web.HttpContext.Current.Application["UserName"].ToString();
// var userid = Convert.ToInt32(Session["UserID"].ToString());
var objuser = db.Users.Where(o => o.UserName == AssignedbyEmailId).Select(o => o).FirstOrDefault();
string UserName = objuser.FirstName + " " + objuser.LastName;
DateTime indianTime = TimeZoneInfo.ConvertTimeFromUtc(DateTime.UtcNow, INDIAN_ZONE);
var MethodName = (ex.InnerException != null) ? (ex.InnerException.TargetSite.Name == null ? "" : ex.InnerException.TargetSite.Name) : (ex.TargetSite.Name == null ? "" : ex.TargetSite.Name);;
var ExceptionDate = DateTime.Now;
var ExceptionMessage = (ex.InnerException != null) ? ex.InnerException.Message : ex.Message;
var Source = (ex.InnerException != null) ? ex.InnerException.Source : ex.Source;
var StackTrace = (ex.InnerException != null) ? ex.InnerException.StackTrace : ex.StackTrace;
var url = ServerName + controllerName + "/" + actionName;
var objcom = db.Master_ApplicationSettings.Where(x => x.AppKey == "Company Name").Select(o => o.AppValue).FirstOrDefault();
//var company = db.Master_ApplicationSettings.Where(x => x.AppKey == "Company Name").Select(o => o.AppValue).FirstOrDefault();
var obj1 = (from p in db.EmailPurposes.Where(x => x.EmailPurposeName == "Error Message")
join q in db.EmailTemplates on p.EmailTemplateID equals q.EmailTemplateID
select new DSRCManagementSystem.Models.Email
{
To = p.To,
CC = p.CC,
BCC = p.BCC,
Subject = p.Subject,
Template = q.TemplatePath
}).FirstOrDefault();
var path = System.Web.Hosting.HostingEnvironment.MapPath(obj1.Template);
//var file = server.MapPath("~/SomeDirectory/Somefile");
//string TemplatePath = Server.MapPath(obj1.Template);
string html = System.IO.File.ReadAllText(path);
string FromMailId = "*****@*****.**";
//string Title = " " + objcom + " calendar event Created";
string Subject = "Management Portal : Error Report" + " " + "on" + " " + DateTime.Today.ToString("ddd, MMM d, yyyy");
obj1.Subject = " " + objcom + " " + "Management Portal : Error Report";
html = html.Replace("#Error", ExceptionMessage);
html = html.Replace("#Subject", Subject);
html = html.Replace("#Date", DateTime.Today.ToString("dd/MM/yyyy"));
html = html.Replace("#url", url);
html = html.Replace("#UserName", UserName);
html = html.Replace("#CompanyName", objcom.ToString());
html = html.Replace("#ServerName", ServerName);
List <string> MailIds = db.TestMailIDs.Select(o => o.MailAddress).ToList();
string EmailAddres = "";
for (int i = 0; i < MailIds.Count(); i++)
{
if (i != MailIds.Count() - 1)
{
EmailAddres += MailIds[i] + ",";
}
else
{
EmailAddres += MailIds[i];
}
}
if (ServerName != "http://win2012srv:88/")
{
Task.Factory.StartNew(() =>
{
string pathvalue = CommonLogic.getLogoPath();
DsrcMailSystem.MailSender.TaskMail(null, Subject, html, FromMailId, EmailAddres, System.Web.Hosting.HostingEnvironment.MapPath(pathvalue.ToString()));
});
}
else
{
Task.Factory.StartNew(() =>
{
string pathvalue = CommonLogic.getLogoPath();
DsrcMailSystem.MailSender.TaskMail(null, Subject, html, FromMailId, EmailAddres, System.Web.Hosting.HostingEnvironment.MapPath(pathvalue.ToString()));
});
}
}
public ActionResult Attendance(EditTimeEntry Model)
{
ViewBag.Lbl_branch = CommonLogic.getLabelName(1).ToString();
DSRCManagementSystemEntities1 DBHRMS = new DSRCManagementSystemEntities1();
string ServerName = AppValue.GetFromMailAddress("ServerName");
EditTimeEntry model = new EditTimeEntry();
Model.EmployeeList = GetNames(1);
try
{
if (Model.EmployeeId != null)
{
var obj = (from tim_mng in DBHRMS.TimeManagements.Where(o => o.EmpID == Model.EmployeeId && o.BranchId == Model.BranchID && EntityFunctions.TruncateTime(o.Date) == EntityFunctions.TruncateTime(Model.Date))
join usr in DBHRMS.Users on tim_mng.EmpID equals usr.EmpID
select new
{
userID = usr.UserID,
EmployeeName = usr.FirstName + " " + usr.LastName,
EmpID = usr.EmpID,
Date = tim_mng.Date,
InTime = tim_mng.InTime,
OutTime = tim_mng.OutTime
}).FirstOrDefault();
//SelectList EmpList = (SelectList)GetNames(Model.BranchID).Data;
//model.EmployeeList = EmpList.Select(x => new SelectListItem { Text = x.Text, Value = x.Value }).ToList();
model.BranchList = GetBranches();
model.EmployeeList = GetNames(Model.BranchID);
model.EmployeeId = Model.EmployeeId;
if (obj != null)
{
model.IsRecordAvail = true;
model.UserID = obj.userID;
model.EmployeeName = obj.EmployeeName;
model.EmployeeId = obj.EmpID;
model.Date = obj.Date;
model.InTime = obj.InTime;
model.OutTime = obj.OutTime;
model.TotalMin = 000;
model.BranchID = Model.BranchID;
model.IsSubmit = true;
}
else
{
model.IsRecordAvail = false;
model.IsSubmit = true;
}
model.EmployeeList = GetNames(1);
//model.BranchList = GetBranches();
//model.Date = null;
//model.EmployeeId = null;
return(View(model));
}
//TimeEntry Model
else
{
Model.EmployeeList = GetNames(1);
int userId = Convert.ToInt32(Session["UserID"]);
string folderPath = Server.MapPath("~/FileManager/" + userId + Session.SessionID + "/" + userId + DateTime.Now.ToString("dd-MM-yyyy hh-MM-ss"));
var Excelfile = Model.excelFile;
List <SelectListItem> Branches = GetBranches();
Branches.Insert(0, new SelectListItem {
Text = "--Select--", Value = "0"
});
Model.BranchList = Branches;
// string errorMessage = string.Empty;
if (Model.BranchID != 0)
{
if (Excelfile != null)
{
//var Extension = Excelfile.FileName.Substring(Excelfile.FileName.LastIndexOf(".") + 1);
var Extension = Path.GetExtension(Excelfile.FileName);
if ((Extension == ".xlsx") || Extension == ".xls")
{
if (!Directory.Exists(folderPath))
{
Directory.CreateDirectory(folderPath);
}
var fileName = Path.GetFileName(Excelfile.FileName);
var path = Path.Combine(folderPath, fileName);
Excelfile.SaveAs(path);
ExcelUtility objExcelUtility = new ExcelUtility();
try
{
objExcelUtility.ImportExcelToDatabase(path, Model.BranchID);
int BranchID = Model.BranchID;
communicationHelper.DeleteDuplicateTimeEntry(Model.BranchID);
Model.ErrorSuccessMessage = "Excel file uploaded successfully.";
Model.EmployeeList = GetNames(1);
// string ServerName = WebConfigurationManager.AppSettings["SeverName"];
var check = db.EmailTemplates.Where(x => x.TemplatePurpose == "Upload Attendance").Select(o => o.EmailTemplateID).FirstOrDefault();
var folder = db.EmailTemplates.Where(o => o.TemplatePurpose == "Upload Attendance").Select(x => x.TemplatePath).FirstOrDefault();
if ((check != null) && (check != 0))
{
var AttendanceUpload = (from p in db.EmailPurposes.Where(x => x.EmailPurposeName == "Upload Attendance")
join q in db.EmailTemplates on p.EmailTemplateID equals q.EmailTemplateID
select new DSRCManagementSystem.Models.Email
{
To = p.To,
CC = p.CC,
BCC = p.BCC,
Subject = p.Subject,
Template = q.TemplatePath
}).FirstOrDefault();
var company = db.Master_ApplicationSettings.Where(x => x.AppKey == "Company Name").Select(o => o).FirstOrDefault();
string TemplatePathAttendanceUpload = Server.MapPath(AttendanceUpload.Template);
string Attendance = System.IO.File.ReadAllText(TemplatePathAttendanceUpload);
int LoginUser = (int)Session["UserId"];
var user = db.Users.Where(o => o.UserID == LoginUser && o.IsActive == true).Select(o => o).FirstOrDefault();
Attendance = Attendance.Replace("#ServerName", ServerName);
Attendance = Attendance.Replace("#CompanyName", company.AppValue);
string date = TimeZoneInfo.ConvertTimeFromUtc(DateTime.UtcNow, INDIAN_ZONE).ToString("dd-mm-yyyy hh:mm:ss tt");
Attendance = Attendance.Replace("#IndianTime", date);
var BranchName = db.Master_Branches.Where(x => x.BranchID == BranchID).Select(o => o.BranchName).FirstOrDefault();
var logo = CommonLogic.getLogoPath();
if (ServerName != "http://*****:*****@dsrc.co.in ";
Task.Factory.StartNew(() =>
{
DsrcMailSystem.MailSender.SendMail(null, AttendanceUpload.Subject + " - Test Mail Please Ignore", null, Attendance + " - Testing Please ignore", "*****@*****.**", EmailAddress, "*****@*****.**", BCCMailId, Server.MapPath(logo.ToString()));
});
}
else
{
Task.Factory.StartNew(() =>
{
DsrcMailSystem.MailSender.SendMail(null, AttendanceUpload.Subject, null, Attendance, "*****@*****.**", user.EmailAddress, "*****@*****.**", null, null, Server.MapPath(logo.ToString()));
});
}
}
//string Subject = "Regarding Attendance upload";
//string pathvalue = CommonLogic.getLogoPath();
//var company = db.Master_ApplicationSettings.Where(x => x.AppKey == "Company Name").Select(o => o.AppValue).FirstOrDefault();
//DateTime indianTime = TimeZoneInfo.ConvertTimeFromUtc(DateTime.UtcNow, INDIAN_ZONE);
//var BranchName = db.Master_Branches.Where(x => x.BranchID == BranchID).Select(o => o.BranchName).FirstOrDefault();
//var imagePath = new List<string>() { Server.MapPath("~/Content/Template/images/Circle_Red.png"), Server.MapPath("~/Content/Template/images/Circle_Orange.png"), Server.MapPath("~/Content/Template/images/Circle_Green.png"), Server.MapPath(pathvalue) };
//string Message = "Thanks for uploading Attendance on" + " " + indianTime + " " + "<br>" + "for" + BranchName + " " + "branch" + "<br/><br/>This email has been automatically generated.</br>Please do not reply to this email address as all responses are directed to an unattended,<br/>mailbox, and you will not receive a response</p><br/><br/><p style=font-size:15px>Thanks,<br/>" + company + "Management Portal</p>";
//if (ServerName != "http://*****:*****@dsrc.co.in";
// string BCCMailId = "[email protected] ";
// Task.Factory.StartNew(() =>
// {
// DsrcMailSystem.MailSender.SendMail(null, Subject + " - Test Mail Please Ignore", null, Message + " - Testing Plaese ignore", "*****@*****.**", EmailAddress,"*****@*****.**", BCCMailId, Server.MapPath(pathvalue.ToString()));
// });
//}
//else
//{
// Task.Factory.StartNew(() =>
// {
// DsrcMailSystem.MailSender.SendMail(null, Subject, null, Message, "*****@*****.**", "[email protected] , [email protected]", null, null, Server.MapPath(pathvalue.ToString()));
// });
//}
//SendMail(BranchID);
}
catch (Exception Ex)
{
string actionName = this.ControllerContext.RouteData.Values["action"].ToString();
string controllerName = this.ControllerContext.RouteData.Values["controller"].ToString();
ExceptionHandlingController.ExceptionDetails(Ex, actionName, controllerName);
Model.ErrorSuccessMessage = "Error: " + Ex.Message;
return(View(Model));
}
}
else
{
Model.ErrorSuccessMessage = "Please upload excel files only.";
}
}
else
{
Model.ErrorSuccessMessage = "Please upload the excel file.";
}
}
else
{
Model.ErrorSuccessMessage = "Please select branch";
}
//Model.IsSubmit = false;
Model.EmployeeList = GetNames(1);
//Model.IsSubmit = false;
//Model.EmployeeList = GetNames(1);
//Model.BranchList = GetBranches();
//Model.Date = null;
//Model.EmployeeId = null;
}
}
catch (Exception Ex)
{
string actionName = this.ControllerContext.RouteData.Values["action"].ToString();
string controllerName = this.ControllerContext.RouteData.Values["controller"].ToString();
ExceptionHandlingController.ExceptionDetails(Ex, actionName, controllerName);
}
return(View(Model));
}
public ActionResult Skills(skilllist model, FormCollection formData)
{
DSRCManagementSystemEntities1 db = new DSRCManagementSystemEntities1();
DsrcMailSystem.MailSender AppValue = new DsrcMailSystem.MailSender();
int UserId = (int)Session["UserId"];
List <string> Technology = new List <string>();
List <string> Specialization = new List <string>();
List <string> Lastused = new List <string>();
List <string> Experience = new List <string>();
int t = 0;
int? s = 0;
string ServerName = AppValue.GetFromMailAddress("ServerName");
var objcompany = db.Master_ApplicationSettings.Where(x => x.AppKey == "Company Name").Select(o => o.AppValue).FirstOrDefault();
for (int i = 0; i < model.skilllists.Count; i++)
{
var LDobj = db.Skills.CreateObject();
if (model.skilllists[i].Id != 0)
{
try
{
LDobj.Technology = model.skilllists[i].Id;
t = model.skilllists[i].Id;
var Techname = db.SkillsTechnologies.Where(o => o.SkillId == t).Select(o => o.SkillName).FirstOrDefault();
Technology.Add(Convert.ToString(Techname));
LDobj.Specialization = model.skilllists[i].SpecificationId;
s = model.skilllists[i].SpecificationId;
var SpecializationName = db.SkillsSpecifications.Where(o => o.SpecificationId == s).Select(o => o.Specification).FirstOrDefault();
Specialization.Add(Convert.ToString(SpecializationName));
LDobj.Level = model.skilllists[i].LevelId;
LDobj.Date = Convert.ToDateTime(model.skilllists[i].DateAssessed);
LDobj.LastUsed = model.skilllists[i].yearid;
Lastused.Add(Convert.ToString(model.skilllists[i].yearid));
LDobj.UserId = Convert.ToInt32(Session["UserID"]);
LDobj.Primary = Convert.ToBoolean(model.skilllists[i].Primary);
LDobj.Secondary = Convert.ToBoolean(model.skilllists[i].Secondary);
LDobj.experiance = model.skilllists[i].experiance.Trim();
Experience.Add(Convert.ToString(model.skilllists[i].experiance));
LDobj.Isactive = true;
LDobj.status = 2;
LDobj.ApprovedBy = model.skilllists[i].ApprovedBy;
db.Skills.AddObject(LDobj);
db.SaveChanges();
}
catch (Exception)
{
}
}
TempData["Success"] = "Skill details Saved Successfully";
}
var LevelList = db.Master_TrainingLevel.ToList();
var TechList = db.SkillsTechnologies.ToList();
var yearlist = db.Master_years.ToList();
var specList = db.SkillsSpecifications.ToList();
skilllist sk = new skilllist();
List <Skills> skl = new List <Skills>();
Skills lModel = new Skills();
List <SelectListItem> LevelList1 = new List <SelectListItem>();
List <SelectListItem> TechList1 = new List <SelectListItem>();
List <SelectListItem> yearlist11 = new List <SelectListItem>();
List <SelectListItem> specList1 = new List <SelectListItem>();
foreach (var list in specList)
{
specList1.Add(new SelectListItem {
Text = list.Specification, Value = Convert.ToString(list.SpecificationId)
});
}
lModel.speciIdList = specList1;
foreach (var list in LevelList)
{
LevelList1.Add(new SelectListItem {
Text = list.LevelName, Value = Convert.ToString(list.LevelId)
});
}
lModel.LevelIDList = LevelList1;
foreach (var list in TechList)
{
TechList1.Add(new SelectListItem {
Text = list.SkillName, Value = Convert.ToString(list.SkillId)
});
}
lModel.TechIDList = TechList1;
foreach (var list in yearlist)
{
//yearlist11.Add(new SelectListItem { Text = list.year1.ToString(), Value = Convert.ToString(list.ID) });
yearlist11.Add(new SelectListItem {
Text = list.year.ToString(), Value = Convert.ToString(list.ID)
});
}
lModel.yearidlist = yearlist11;
for (int i = 0; i < 1; i++)
{
Skills lm = new Skills();
lm.SpecificationId = 0;
lm.LevelId = 0;
lm.Id = 0;
lm.DateAssessed = null;
lm.LastUsed = 0;
lm.Primary = false;
lm.Secondary = false;
skl.Add(lm);
}
sk.skilllists = skl;
sk.SKL = lModel;
var skillid = db.Skills.Where(o => o.UserId == UserId && o.Technology == t && o.Specialization == s).Select(o => o.Id).FirstOrDefault();
var empname = db.Users.Where(o => o.UserID == UserId).Select(o => o.FirstName + " " + ((o.LastName).Length > 0? o.LastName:" ")).FirstOrDefault();
var reporting = db.Skills.Where(o => o.UserId == UserId && o.Technology == t && o.Specialization == s).Select(o => o.ApprovedBy).FirstOrDefault();
int reportingid = (int)reporting;
var reportingname = db.Users.Where(o => o.UserID == reportingid).Select(o => o.FirstName + " " + ((o.LastName).Length > 0 ? o.LastName : " ")).FirstOrDefault();
var reportingemail = db.Users.Where(o => o.UserID == reportingid).Select(o => o.EmailAddress).FirstOrDefault();
var checks = db.EmailTemplates.Where(x => x.TemplatePurpose == "Skill Added").Select(o => o.EmailTemplateID).FirstOrDefault();
var folder = db.EmailTemplates.Where(o => o.TemplatePurpose == "Skill Added").Select(x => x.TemplatePath).FirstOrDefault();
if ((checks != null) && (checks != 0))
{
var objRequest = (from p in db.EmailPurposes.Where(x => x.EmailPurposeName == "Skill Added")
join q in db.EmailTemplates on p.EmailTemplateID equals q.EmailTemplateID
select new DSRCManagementSystem.Models.Email
{
To = p.To,
CC = p.CC,
BCC = p.BCC,
Subject = p.Subject,
Template = q.TemplatePath
}).FirstOrDefault();
var company = db.Master_ApplicationSettings.Where(x => x.AppKey == "Company Name").Select(o => o.AppValue).FirstOrDefault();
string TemplatePath = Server.MapPath(objRequest.Template);
string html = System.IO.File.ReadAllText(TemplatePath);
string Title = " Following Skills were Added by " + " " + empname + " " + "for Approval";
html = html.Replace("#Title", Title);
html = html.Replace("#Technology", Technology[0]);
html = html.Replace("#Specialization", Specialization[0]);
html = html.Replace("#LastUsed", Lastused[0]);
html = html.Replace("#Experience", Experience[0]);
html = html.Replace("#RequestedId", Convert.ToString(skillid));
html = html.Replace("#ReportingPersonName", Convert.ToString(reportingname));
html = html.Replace("#ServerName", ServerName);
html = html.Replace("#CompanyName", objcompany);
html = html.Replace("#ReqUser", empname);
var logo = CommonLogic.getLogoPath();
if (ServerName != "http://*****:*****@dsrc.co.in", EmailAddress, Server.MapPath(logo.ToString()));
});
}
//else
//{
// Task.Factory.StartNew(() =>
// {
// DsrcMailSystem.MailSender.SendMail(null, objRequest.Subject, null, html, "*****@*****.**", Convert.ToString(reportingemail), Server.MapPath(logo.ToString()));
// });
//}
}
else
{
ExceptionHandlingController.TemplateMissing("Skill Added", folder, ServerName);
}
return(RedirectToAction("Skills", sk));
}