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)); }