Exemple #1
0
        public ActionResult AllEmployees()
        {
            var db            = new TSS_Sql_Entities();
            var employeesList = db.Employees.ToList();

            return(View(employeesList));
        }
Exemple #2
0
        public ActionResult ClientDetails(int Id)
        {
            var db = new TSS_Sql_Entities();

            try
            {
                var a          = db.Customers.FirstOrDefault(x => x.Id == Id);
                var userObject = db.AspNetUsers.FirstOrDefault(s => s.Customer_id == a.Customer_id);
                ViewBag.ClientContacts = db.CustomerContacts.Where(s => s.Customer_id == a.Customer_id).ToList();
                ViewBag.DisplayPicture = userObject.DisplayPicture;
                var timeSheets = db.Timesheets.Where(s => s.Customer_id == Id).ToList();
                if (timeSheets.Count == 0)
                {
                    var tempTimeSheet = new Timesheet();
                    tempTimeSheet.Customer = db.Customers.FirstOrDefault(s => s.Id == Id);
                    timeSheets.Add(tempTimeSheet);
                }
                return(View(timeSheets));
            }
            catch
            {
                var timeSheets    = new List <Timesheet>();
                var tempTimeSheet = new Timesheet();
                tempTimeSheet.Customer = db.Customers.FirstOrDefault(s => s.Id == Id);
                timeSheets.Add(tempTimeSheet);
                return(View(timeSheets));
            }
        }
Exemple #3
0
        public ActionResult UpdateCustomerInfo(int id)
        {
            var db = new TSS_Sql_Entities();

            ViewBag.Branch_id = new SelectList(db.Branches, "Id", "Name");
            return(View(db.Customers.Find(id)));
        }
 public ActionResult ConfirmAccount(string token)
 {
     try
     {
         var db = new TSS_Sql_Entities();
         if (token != null && token != "")
         {
             var checkToken = db.ContactConfirmations.FirstOrDefault(s => s.ConfirmationToken == token);
             if (checkToken != null)
             {
                 var datetimeCheck = DateTime.Compare(Convert.ToDateTime(checkToken.TokenExpiryTime), DateTime.Now);
                 if (datetimeCheck > 0)
                 {
                     checkToken.ConfirmationStatusId = 1;
                     db.SaveChanges();
                     ViewBag.Token = token;
                     return(View());
                 }
                 else
                 {
                     checkToken.ConfirmationStatusId = 4;
                     db.SaveChanges();
                     return(RedirectToAction("TokenExpired"));
                 }
             }
         }
         return(RedirectToAction("TokenNotFound"));
     }
     catch (Exception ex)
     {
         ExceptionHandlerController.infoMessage(ex.Message);
         ExceptionHandlerController.writeErrorLog(ex);
         return(RedirectToAction("TokenNotFound"));
     }
 }
Exemple #5
0
        public ActionResult GetRejectionReason(int timesheetId)
        {
            var db     = new TSS_Sql_Entities();
            var reason = db.RejectedTimesheets.FirstOrDefault(s => s.TimeSheetId == timesheetId);

            return(Json(reason, JsonRequestBehavior.AllowGet));
        }
        public ActionResult EditProfile(AspNetUser user, HttpPostedFileBase DisplayPicture)
        {
            var db      = new TSS_Sql_Entities();
            var userObj = db.AspNetUsers.Find(user.Id);

            if (DisplayPicture != null)
            {
                string pic  = System.IO.Path.GetFileName(DisplayPicture.FileName);
                string path = System.IO.Path.Combine(
                    Server.MapPath("~/ProfileImages"), pic);

                DisplayPicture.SaveAs(path);


                using (MemoryStream ms = new MemoryStream())
                {
                    DisplayPicture.InputStream.CopyTo(ms);
                    byte[] array = ms.GetBuffer();
                }
                userObj.DisplayPicture = DisplayPicture.FileName;
                db.SaveChanges();
            }

            return(RedirectToAction("UserProfile", "ClientDashboard"));
        }
Exemple #7
0
        public ActionResult UpdateEmployeeEntry(Employee employee)
        {
            var db          = new TSS_Sql_Entities();
            var employeeObj = db.Employees.Find(employee.Id);

            employeeObj.Address1         = employee.Address1;
            employeeObj.Address2         = employee.Address2;
            employeeObj.Anniversary_date = employee.Anniversary_date;
            employeeObj.Branch_id        = employee.Branch_id;
            employeeObj.City             = employee.City;
            employeeObj.Country          = employee.Country;
            employeeObj.DateOfBirth      = employee.DateOfBirth;
            employeeObj.EmployeeType     = employee.EmployeeType;
            employeeObj.First_name       = employee.First_name;
            employeeObj.Gender           = employee.Gender;
            employeeObj.Hire             = employee.Hire;
            employeeObj.Last_name        = employee.Last_name;
            employeeObj.Marital_status   = employee.Marital_status;
            employeeObj.Middle_name      = employee.Middle_name;
            employeeObj.ReHire           = employee.ReHire;
            employeeObj.State            = employee.State;
            employeeObj.Status           = employee.Status;
            employeeObj.Updated_at       = DateTime.Now;
            employeeObj.ZipCode          = employee.ZipCode;
            db.SaveChanges();
            return(RedirectToAction("AllEmployees", "TSSManage"));
        }
        public ActionResult EditProfile()
        {
            var userId = User.Identity.GetUserId();
            var db     = new TSS_Sql_Entities();
            var user   = db.AspNetUsers.Find(userId);

            return(View(user));
        }
Exemple #9
0
        public ActionResult SendConfirmationStatus(string email, int Id)
        {
            var db       = new TSS_Sql_Entities();
            var emailId  = db.CustomerContacts.FirstOrDefault(s => s.Email_id == email);
            var response = SendTimeSheetLink(Id, email, 1);

            return(RedirectToAction("SendAccountEmail", "TSSManage", new { id = emailId.Id }));
        }
Exemple #10
0
        public ActionResult UpdateEmployee(int id)
        {
            var db = new TSS_Sql_Entities();

            ViewBag.Branch_id = new SelectList(db.Branches, "Id", "Name");
            var employee = db.Employees.Find(id);

            return(View(employee));
        }
        public ActionResult AllTimeSheets()
        {
            var db         = new TSS_Sql_Entities();
            var userId     = User.Identity.GetUserId();
            var userObj    = db.AspNetUsers.Find(userId);
            var TimeSheets = db.Timesheets.Where(s => s.Customer_Id_Generic == userObj.Customer_id && s.Status_id != 1).ToList();

            return(View(TimeSheets));
        }
Exemple #12
0
        public JsonResult SendTimeSheetLink(int id, string email, int checkUser = 0)
        {
            var db        = new TSS_Sql_Entities();
            var timesheet = db.Timesheets.Find(id);

            //var customerId = timesheet.Customer_Id_Generic;
            timesheet.Status_id = 2;
            db.SaveChanges();
            var user = db.AspNetUsers.FirstOrDefault(s => s.Email == email);

            if (user == null && checkUser == 0)
            {
                return(Json("Customer Doesn't Exists", JsonRequestBehavior.AllowGet));
            }

            try
            {
                var      fromAddress  = new MailAddress(SenderEmailId, "Total Staffing Solution");
                var      toAddress    = new MailAddress(email, email);
                string   fromPassword = SenderEmailPassword;
                string   subject      = "Total Staffing Solution: New Timesheet";
                DateTime saturday     = DateTime.Now.AddDays(6 - Convert.ToDouble(DateTime.Now.DayOfWeek));
                string   dateString   = String.Format("{0:MM/dd/yyyy}", saturday);
                string   body         = "<b>Hello " + email + "!</b><br />Below you'll find the link to your timesheets for the upcoming week. Please enter the hours worked for the employees listed and return to us by " + dateString + ".<br /><br /><a href='"
                                        + TSSLiveSiteURL + "/Timesheets/TimeSheetDetails/" + id + "'>Timesheet Link</a> <br />Thanks for joining and have a great day! <br />Total Staffing Solutions";

                var smtp = new SmtpClient
                {
                    Host           = SenderEmailHost,
                    Port           = SenderEmailPort,
                    EnableSsl      = false,
                    DeliveryMethod = SmtpDeliveryMethod.Network,
                    Credentials    = new NetworkCredential(fromAddress.Address, fromPassword),
                    Timeout        = 20000
                };
                using (var message = new MailMessage(fromAddress, toAddress)
                {
                    IsBodyHtml = true,
                    Subject = subject,
                    Body = body,
                })
                {
                    //message.CC.Add("*****@*****.**");
                    ////message.CC.Add("*****@*****.**");
                    smtp.Send(message);
                }

                return(Json("Link Sent successfully", JsonRequestBehavior.AllowGet));
            }
            catch (Exception ex)
            {
                ExceptionHandlerController.infoMessage(ex.Message);
                ExceptionHandlerController.writeErrorLog(ex);
                return(Json("Something Went wrong..!", JsonRequestBehavior.AllowGet));
            }
        }
        public async Task <ActionResult> RegisterUser(UserRegisterViewModel model)
        {
            var db = new TSS_Sql_Entities();

            try
            {
                var userObj = db.AspNetUsers.FirstOrDefault(s => s.Email == model.Email);
                if (userObj != null)
                {
                    var error = "Your Email Id Already Exists, Please contact at [email protected]";
                    ModelState.AddModelError("", error);
                    return(View(model));
                }
            }
            catch { }

            if (ModelState.IsValid)
            {
                var user = new ApplicationUser {
                    UserName = model.Email, Email = model.Email
                };

                var result = await UserManager.CreateAsync(user, model.Password);

                if (result.Succeeded)
                {
                    await SignInManager.SignInAsync(user, isPersistent : false, rememberBrowser : false);

                    await UserManager.AddToRoleAsync(user.Id, "User");

                    var userSaved = db.AspNetUsers.FirstOrDefault(s => s.Id == user.Id);
                    userSaved.Customer_id = model.Customer_id;

                    var customerContact = db.ContactConfirmations.FirstOrDefault(s => s.CustomerContact.Email_id == model.Email && s.ConfirmationStatusId == 2);
                    customerContact.ConfirmationStatusId = 3;

                    userSaved.PhoneNumber = (customerContact.CustomerContact.Phone_1 != "" && customerContact.CustomerContact.Phone_1 != null) ? customerContact.CustomerContact.Phone_1 : (customerContact.CustomerContact.Phone_2 != "" && customerContact.CustomerContact.Phone_2 != null) ? customerContact.CustomerContact.Phone_2 : (customerContact.CustomerContact.Phone_3 != "" && customerContact.CustomerContact.Phone_3 != null) ? customerContact.CustomerContact.Phone_3 : null;

                    var customerObject = db.Customers.FirstOrDefault(s => s.Customer_id == model.Customer_id);
                    customerObject.Email       = model.Email;
                    customerObject.PhoneNumber = userSaved.PhoneNumber;
                    db.SaveChanges();

                    // For more information on how to enable account confirmation and password reset please visit http://go.microsoft.com/fwlink/?LinkID=320771
                    // Send an email with this link
                    // string code = await UserManager.GenerateEmailConfirmationTokenAsync(user.Id);
                    // var callbackUrl = Url.Action("ConfirmEmail", "Account", new { userId = user.Id, code = code }, protocol: Request.Url.Scheme);
                    // await UserManager.SendEmailAsync(user.Id, "Confirm your account", "Please confirm your account by clicking <a href=\"" + callbackUrl + "\">here</a>");
                    return(RedirectToAction("AllTimeSheets", "ClientDashboard"));
                }
                AddErrors(result);
            }

            // If we got this far, something failed, redisplay form
            return(View(model));
        }
Exemple #14
0
 public ActionResult EditBranch(int Id)
 {
     try
     {
         var db = new TSS_Sql_Entities();
         return(View(db.Branches.Find(Id)));
     }
     catch (Exception)
     {
         return(RedirectToAction("Branches", "TSSManage"));
     }
 }
Exemple #15
0
        public ActionResult UpdateCustomerInfoFunc(Customer customer)
        {
            var db = new TSS_Sql_Entities();

            var customerExistingObj = db.Customers.Find(customer.Id);

            customerExistingObj.Email       = customer.Email;
            customerExistingObj.PhoneNumber = customer.PhoneNumber;
            customerExistingObj.Branch_id   = customer.Branch_id;
            db.SaveChanges();
            return(RedirectToAction("AllClients"));
        }
        public ActionResult RegisterUser(string emailId, string token)
        {
            var db         = new TSS_Sql_Entities();
            var checkEmail = db.ContactConfirmations.FirstOrDefault(s => s.CustomerContact.Email_id == emailId && s.ConfirmationToken == token);

            if (checkEmail != null)
            {
                UserRegisterViewModel model = new UserRegisterViewModel();
                model.Email       = emailId;
                model.Customer_id = checkEmail.CustomerContact.Customer_id;
                return(View(model));
            }
            return(RedirectToAction("EmailConfirmationFailed", "ClientDashboard"));
        }
        public ActionResult ConfirmEmail(FormCollection fc)
        {
            var emailId = fc["Email"];
            var token   = fc["Token"];

            var db         = new TSS_Sql_Entities();
            var checkEmail = db.ContactConfirmations.FirstOrDefault(s => s.ConfirmationToken == token && s.CustomerContact.Email_id == emailId);

            if (checkEmail != null)
            {
                return(RedirectToAction("RegisterUser", "Account", new { emailId, token }));
            }
            return(RedirectToAction("EmailConfirmationFailed"));
        }
        public ActionResult UserProfile()
        {
            var db     = new TSS_Sql_Entities();
            var userId = User.Identity.GetUserId();
            var user   = db.AspNetUsers.FirstOrDefault(s => s.Id == userId);
            var customercontactDetail = db.CustomerContacts.Where(s => s.Customer_id == user.Customer_id).ToList();

            ViewBag.ContactList = customercontactDetail;
            int?TotalTimeSheets = db.Timesheets.Where(s => s.Customer_Id_Generic == user.Customer_id).Count();

            ViewBag.TotalTimeSheets = (TotalTimeSheets == null) ? 0 : TotalTimeSheets;
            ViewBag.Customer        = db.Customers.FirstOrDefault(s => s.Customer_id == user.Customer_id);
            return(View(user));
        }
Exemple #19
0
 public ActionResult AddNewBranch(Branch branch)
 {
     try
     {
         var db = new TSS_Sql_Entities();
         branch.Created_at = DateTime.Now;
         branch.Updated_at = DateTime.Now;
         db.Branches.Add(branch);
         db.SaveChanges();
     }
     catch (Exception)
     {
     }
     return(RedirectToAction("Branches", "TSSManage"));
 }
Exemple #20
0
 public ActionResult AddNewCompany(Company company)
 {
     try
     {
         var db = new TSS_Sql_Entities();
         company.Created_at = DateTime.Now;
         db.Companies.Add(company);
         db.SaveChanges();
     }
     catch (Exception)
     {
         throw;
     }
     return(RedirectToAction("Dashboard", "TSSManage"));
 }
Exemple #21
0
        public bool UpdateEmployees()
        {
            try
            {
                TSSWebServiceReference.VFPWebServiceSoapClient srvDBObj = new TSSWebServiceReference.VFPWebServiceSoapClient();
                var employeesList = srvDBObj.UpdateUsersData();
                var db            = new TSS_Sql_Entities();

                foreach (var item in employeesList)
                {
                    var empCheck = db.Employees.FirstOrDefault(s => s.First_name == item.Emcfname && s.Last_name == item.Emclname);
                    if (empCheck == null && Convert.ToInt32(empCheck.User_id) != Convert.ToInt32(item.Emcempid))
                    {
                        var employeeObj = new TotalStaffingSolutions.Models.Employee();
                        employeeObj.User_id        = Convert.ToInt32(item.Emcempid);
                        employeeObj.First_name     = item.Emcfname;
                        employeeObj.Last_name      = item.Emclname;
                        employeeObj.Middle_name    = item.Emcmname;
                        employeeObj.Created_at     = DateTime.Now;
                        employeeObj.Address1       = item.Emcaddr1;
                        employeeObj.Address2       = item.Emcaddr2;
                        employeeObj.City           = item.Emccity;
                        employeeObj.State          = item.Emcstate;
                        employeeObj.ZipCode        = item.Emczipcode;
                        employeeObj.Country        = item.Emccountry;
                        employeeObj.Marital_status = item.Emcmarital;
                        employeeObj.Gender         = item.Emcsex;
                        //employeeObj.DateOfBirth = Convert.ToDateTime(item.Emtbirth);
                        //employeeObj.Hire = Convert.ToDateTime(item.Emthire);
                        //employeeObj.ReHire = Convert.ToDateTime(item.Emtrehire);
                        employeeObj.EmployeeType    = item.Emcemptype;
                        employeeObj.ENTITY_ADDED_AT = DateTime.Now;
                        employeeObj.Updated_at      = DateTime.Now;

                        db.Employees.Add(employeeObj);
                        db.SaveChanges();
                    }
                }
                return(true);
            }
            catch (Exception ex)
            {
                ExceptionHandlerController.infoMessage(ex.Message);
                ExceptionHandlerController.writeErrorLog(ex);

                return(false);
            }
        }
Exemple #22
0
        public JsonResult GetClientEmails(int timesheetId)
        {
            var db        = new TSS_Sql_Entities();
            var timesheet = db.Timesheets.FirstOrDefault(s => s.Id == timesheetId);
            //var availableUsers = db.AspNetUsers.Where(s => s.Customer_id == timesheet.Customer_Id_Generic).ToList();
            // var availableEmails = availableUsers.Select(s => s.Email).ToList();

            var availableAddresses = db.CustomerContacts.Where(s => s.Customer_id == timesheet.Customer_Id_Generic).ToList();
            var availableEmails    = availableAddresses.Select(s => s.Email_id).ToList();

            if (availableEmails.Count < 1)
            {
                availableEmails.Add("No Email Available");
            }
            return(Json(availableEmails, JsonRequestBehavior.AllowGet));
        }
Exemple #23
0
        public bool UpdateCustomers()
        {
            try
            {
                TSSWebServiceReference.VFPWebServiceSoapClient srvDBObj = new TSSWebServiceReference.VFPWebServiceSoapClient();
                var usersList = srvDBObj.UpdateCustomersData();
                var db        = new TSS_Sql_Entities();

                foreach (var item in usersList)
                {
                    var custCheck = db.Customers.FirstOrDefault(s => s.Customer_id == item.Cuccustid && s.Name == item.Cucname);
                    if (custCheck == null)
                    {
                        var userobj = new TotalStaffingSolutions.Models.Customer();
                        userobj.Name          = item.Cucname;
                        userobj.Customer_id   = item.Cuccustid;
                        userobj.Address1      = item.Cucaddr1;
                        userobj.Address2      = item.Cucaddr2;
                        userobj.City          = item.Cuccity;
                        userobj.State         = item.Cucstate;
                        userobj.CustomerAdded = DateTime.Now;
                        userobj.ZipCode       = item.Cuczipcode;
                        userobj.Country       = item.Cuccountry;
                        userobj.Created_at    = DateTime.Now;
                        //userobj.PhoneNumber = item.Cucpono;
                        userobj.Status          = item.Cucstatus;
                        userobj.ENTITY_ADDED_AT = DateTime.Now;
                        db.Customers.Add(userobj);
                        db.SaveChanges();
                        var ponoObj = new Po_Numbers();
                        ponoObj.ClientId          = userobj.Id;
                        ponoObj.Client_Generic_Id = userobj.Customer_id;
                        ponoObj.PoNumber          = item.Cucpono;
                        db.Po_Numbers.Add(ponoObj);
                        db.SaveChanges();
                    }
                }
                return(true);
            }
            catch (Exception ex)
            {
                ExceptionHandlerController.infoMessage(ex.Message);
                ExceptionHandlerController.writeErrorLog(ex);

                return(false);
            }
        }
Exemple #24
0
        public ActionResult TimeSheetsByBranch(int?id = 0)  //IMPORTANT UPDATE ALL FOLLOWING METHODS (Dashboard, TimeSheetsByBranch, TimeSheetsByClient, Timesheetsbyperiod)
        {
            try
            {
                if (id > 0)
                {
                    var db = new TSS_Sql_Entities();

                    List <Branch> bl = db.Branches.ToList();
                    Branch        b  = new Branch();
                    b.Id   = 0;
                    b.Name = "Select Branch";
                    bl.Add(b);
                    var a          = bl.OrderBy(s => s.Id);
                    var branchlist = new SelectList(a, "Id", "Name");
                    ViewBag.BranchsList = branchlist;
                    var timesheets = db.Timesheets.Where(s => s.Customer.Branch_id == id).ToList();
                    ViewBag.SelectedBranchId = id;
                    List <Customer> cl = db.Customers.ToList();
                    Customer        c  = new Customer();
                    c.Id   = 0;
                    c.Name = "Select Client";
                    cl.Add(c);
                    var orderedClients = cl.OrderBy(s => s.Id);
                    var clientlist     = new SelectList(orderedClients, "Id", "Name");
                    ViewBag.ClientsList = clientlist;

                    ViewBag.SelectedClientId = null;
                    return(View(timesheets));
                }
                else
                {
                    return(RedirectToAction("Dashboard"));
                }
            }
            catch (Exception ex)
            {
                ExceptionHandlerController.infoMessage(ex.Message);
                ExceptionHandlerController.writeErrorLog(ex);
            }
            var list = new List <Timesheet>();

            return(View(list));
        }
Exemple #25
0
        public JsonResult SearchEmployees(String query)
        {
            var db = new TSS_Sql_Entities();

            int  n;
            bool isNumeric = int.TryParse(query, out n);

            if (EmployeesStaticList == null)
            {
                EmployeesStaticList = db.Employees.ToList();
            }

            if (isNumeric == true)
            {
                var integerValue = Convert.ToInt32(query);
                var results      = (from obj in EmployeesStaticList where obj.User_id == integerValue select new { Id = obj.Id, Name = obj.User_id + "-" + obj.First_name + " " + obj.Last_name }).Take(25).ToList();
                return(Json(results, JsonRequestBehavior.AllowGet));
            }
            else
            {
                var splitStr = Regex.Split(query, " ");
                if (splitStr.Count() == 2)
                {
                    splitStr[0] = splitStr[0].First().ToString().ToUpper() + splitStr[0].Substring(1);
                    splitStr[1] = splitStr[1].First().ToString().ToUpper() + splitStr[1].Substring(1);
                    var results = (from obj in EmployeesStaticList where obj.First_name.Contains(splitStr[0]) || obj.Last_name.Contains(splitStr[1]) select new { Id = obj.Id, Name = obj.User_id + "-" + obj.First_name + " " + obj.Last_name }).Take(25).ToList();
                    return(Json(results, JsonRequestBehavior.AllowGet));
                }
                else if (splitStr.Count() == 3)
                {
                    splitStr[0] = splitStr[0].First().ToString().ToUpper() + splitStr[0].Substring(1);
                    splitStr[2] = splitStr[2].First().ToString().ToUpper() + splitStr[1].Substring(1);
                    var results = (from obj in EmployeesStaticList where obj.First_name.Contains(splitStr[0]) || obj.Last_name.Contains(splitStr[2]) select new { Id = obj.Id, Name = obj.User_id + "-" + obj.First_name + " " + obj.Last_name }).Take(25).ToList();
                    return(Json(results, JsonRequestBehavior.AllowGet));
                }
                else
                {
                    query = query.First().ToString().ToUpper() + query.Substring(1);
                    var results = (from obj in EmployeesStaticList where obj.First_name.Contains(query) select new { Id = obj.Id, Name = obj.User_id + "-" + obj.First_name + " " + obj.Last_name }).Take(25).ToList();
                    return(Json(results, JsonRequestBehavior.AllowGet));
                }
            }
        }
Exemple #26
0
 public ActionResult EditExistingBranch(Branch branch)
 {
     try
     {
         var db         = new TSS_Sql_Entities();
         var findBranch = db.Branches.FirstOrDefault(s => s.Id == branch.Id);
         findBranch.Name            = branch.Name;
         findBranch.Organization_id = branch.Organization_id;
         findBranch.Updated_at      = DateTime.Now;
         findBranch.Email           = branch.Email;
         findBranch.Created_at      = DateTime.Now;
         findBranch.Branch_Manager  = branch.Branch_Manager;
         findBranch.Phone           = branch.Phone;
         findBranch.Address         = branch.Address;
         db.SaveChanges();
     }
     catch (Exception)
     {
     }
     return(RedirectToAction("Branches", "TSSManage"));
 }
Exemple #27
0
        public bool updateentriesoftimesheets()
        {
            try
            {
                var db = new TSS_Sql_Entities();

                var tss = db.Timesheets.ToList();
                foreach (var item in tss)
                {
                    var ts      = db.Timesheets.Find(item.Id);
                    var sumlist = db.Timesheet_summaries.Where(s => s.Timesheet_id == ts.Id);
                    ts.Total_employees = sumlist.Count();
                    db.SaveChanges();
                }

                return(true);
            }
            catch (Exception)
            {
                return(false);
            }
        }
Exemple #28
0
        public ActionResult Dashboard1() //IMPORTANT UPDATE ALL FOLLOWING METHODS (Dashboard, TimeSheetsByBranch, TimeSheetsByClient, Timesheetsbyperiod)
        {
            try
            {
                var           db = new TSS_Sql_Entities();
                List <Branch> bl = db.Branches.ToList();
                Branch        b  = new Branch();
                b.Id   = 0;
                b.Name = "Select Branch";
                bl.Add(b);
                var orderedbranches = bl.OrderBy(s => s.Id);
                var branchlist      = new SelectList(orderedbranches, "Id", "Name");
                ViewBag.BranchsList = branchlist;

                List <Customer> cl = db.Customers.ToList();
                Customer        c  = new Customer();
                c.Id   = 0;
                c.Name = "Select Client";
                cl.Add(c);
                var orderedClients = cl.OrderBy(s => s.Id);
                var clientlist     = new SelectList(orderedClients, "Id", "Name");
                ViewBag.ClientsList = clientlist;

                ViewBag.SelectedBranchId = "";
                ViewBag.SelectedClientId = "";

                //ViewBag.RejectedTimeSheets = db.RejectedTimesheets.ToList();

                return(View(db.Timesheets.ToList()));
            }
            catch (Exception ex)
            {
                ExceptionHandlerController.infoMessage(ex.Message);
                ExceptionHandlerController.writeErrorLog(ex);
            }
            var list = new List <Timesheet>();

            return(View(list));
        }
        public JsonResult RejectTimeSheet(int timesheetId, string reason)
        {
            try
            {
                var db           = new TSS_Sql_Entities();
                var userid       = User.Identity.GetUserId();
                var user         = db.AspNetUsers.FirstOrDefault(s => s.Id == userid);
                var rejectionObj = new RejectedTimesheet();
                rejectionObj.TimeSheetId           = timesheetId;
                rejectionObj.RejectionReason       = reason;
                rejectionObj.RejectedAt            = DateTime.Now;
                rejectionObj.IsUpdatedOrDeleted    = false;
                rejectionObj.RejecetedByCustomerId = Convert.ToInt32(user.Customer_id);
                db.RejectedTimesheets.Add(rejectionObj);
                var timesheet = db.Timesheets.FirstOrDefault(s => s.Id == timesheetId);
                timesheet.Status_id = 4;
                db.SaveChanges();

                ///////////////////////////////////ADMIN EMAIL UPDATE/////////////////////////////////////
                #region ADMIN EMAIL UPDATE
                if (User.IsInRole("User"))
                {
                    try
                    {
                        var    AdminId      = timesheet.Created_By;
                        var    admin        = db.AspNetUsers.FirstOrDefault(s => s.Id == AdminId);
                        var    fromAddress  = new MailAddress(SenderEmailId, "Total Staffing Solution");
                        var    toAddress    = new MailAddress(admin.Email, admin.Email);
                        string fromPassword = SenderEmailPassword;
                        string subject      = "Total Staffing Solution: Timesheet Update";
                        string body         = "<b>Hello " + admin.UserName + "!</b><br />Client has Rejected the timesheet<br /> <a href='" + TSSLiveSiteURL + "/Timesheets/TimeSheetDetails/" + timesheet.Id + "'>Timesheet Link</a><br />";

                        var smtp = new SmtpClient
                        {
                            Host           = SenderEmailHost,
                            Port           = SenderEmailPort,
                            EnableSsl      = false,
                            DeliveryMethod = SmtpDeliveryMethod.Network,
                            Credentials    = new NetworkCredential(fromAddress.Address, fromPassword),
                            Timeout        = 20000
                        };
                        using (var message = new MailMessage(fromAddress, toAddress)
                        {
                            IsBodyHtml = true,
                            Subject = subject,
                            Body = body,
                        })
                        {
                            message.CC.Add("*****@*****.**");
                            //message.CC.Add("*****@*****.**");
                            smtp.Send(message);
                        }
                        ///
                    }
                    catch (Exception ex)
                    {
                        ExceptionHandlerController.infoMessage(ex.Message);
                        ExceptionHandlerController.writeErrorLog(ex);
                    }
                }
                #endregion
                //////////////////////////////////////////////////////////////////////////////////////////
                return(Json("Rejected Successfully!", JsonRequestBehavior.AllowGet));
            }
            catch (Exception ex)
            {
                ExceptionHandlerController.infoMessage(ex.Message);
                ExceptionHandlerController.writeErrorLog(ex);
                return(Json("Something went wrong", JsonRequestBehavior.AllowGet));
            }
        }
Exemple #30
0
        public ActionResult Branches()
        {
            var db = new TSS_Sql_Entities();

            return(View(db.Branches.ToList()));
        }