public ActionResult Income() { List <DSRCManagementSystem.Models.Income> UserList = new List <DSRCManagementSystem.Models.Income>(); try { int IncomeID = Convert.ToInt32(Session["IncomeID"]); ModelState.Clear(); DSRCManagementSystemEntities1 db = new DSRCManagementSystemEntities1(); DSRCManagementSystem.Models.Income objUser = new DSRCManagementSystem.Models.Income(); UserList = (from u in db.Incomes.Where(o => o.IsActive != false) select new DSRCManagementSystem.Models.Income() { IncomeID = u.IncomeID, IncomeDescription = u.IncomeDescription, IncomeDate = u.IncomeDate, IncomeAmount = u.IncomeAmount, IsActive = u.IsActive, CreatedAt = u.CreatedAt, }).OrderByDescending(o => o.IncomeDate.Value.Year).ThenByDescending(o => o.IncomeDate.Value.Month).ThenByDescending(o => o.IncomeDate.Value.Day).ToList(); return(View(UserList)); } 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(UserList)); }
public ActionResult AddIncome() { DSRCManagementSystem.Models.Income obj = new DSRCManagementSystem.Models.Income(); try { obj.CreatedAt = System.DateTime.Now; DateTime d1 = Convert.ToDateTime(obj.CreatedAt); string d = d1.ToShortDateString(); obj.ScheduleDate = d; //return View(obj); } 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(obj)); }
public ActionResult EditIncome(int Id) { DSRCManagementSystem.Models.Income obj = new DSRCManagementSystem.Models.Income(); try { DSRCManagementSystemEntities1 objdb = new DSRCManagementSystemEntities1(); var value = objdb.Incomes.Where(x => x.IncomeID == Id).Select(o => o).FirstOrDefault(); obj.IncomeDescription = value.IncomeDescription; obj.IncomeAmount = value.IncomeAmount; obj.IncomeDate = value.IncomeDate; obj.ScheduleDate = Convert.ToString(value.CreatedAt); TempData["IncomeId"] = Id; } 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(obj)); }
public ActionResult AddIncome(DSRCManagementSystem.Models.Income objmodel) { DSRCManagementSystemEntities1 objdb = new DSRCManagementSystemEntities1(); string ServerName = AppValue.GetFromMailAddress("ServerName"); DSRCManagementSystem.Income obj = new DSRCManagementSystem.Income(); try { obj.IncomeDescription = objmodel.IncomeDescription.Trim(); obj.IncomeDate = objmodel.IncomeDate; obj.IncomeAmount = objmodel.IncomeAmount; obj.CreatedAt = Convert.ToDateTime(objmodel.ScheduleDate); obj.IsActive = true; objdb.AddToIncomes(obj); objdb.SaveChanges(); var IncomeDes = objmodel.IncomeDescription.Trim(); DateTime?Incomedate = objmodel.IncomeDate; var Income = objmodel.IncomeAmount; 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(); //foreach (var eids in GetUsersFromDept) //{ 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(); // string ServerName = WebConfigurationManager.AppSettings["SeverName"]; var check = objdb.EmailTemplates.Where(x => x.TemplatePurpose == "Add Income").Select(o => o.EmailTemplateID).FirstOrDefault(); var folder = objdb.EmailTemplates.Where(x => x.TemplatePurpose == "Add Income").Select(o => o.TemplatePath).FirstOrDefault(); if ((check != null) && (check != 0)) { var obj1 = (from p in objdb.EmailPurposes.Where(x => x.EmailPurposeName == "Add Income") 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 Title = " " + objcom + " calendar event Created"; string Subject = "Income Added on " + DateTime.Today.ToString("dd MMM yyyy"); obj1.Subject = " " + objcom + " Management Portal-New Income Added"; html = html.Replace("#IncomeDescription", IncomeDes); html = html.Replace("#Date", DateTime.Today.ToString("dd MMM yyyy")); html = html.Replace("#IncomeDate", Incomedate.ToString().Substring(0, 10)); html = html.Replace("#IncomeAmount", Income.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 Income", 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)); }