public static List <ListBoxHelper> GetCrewUsers() { JneCommSitesDataLayer.JneCommSitesDataBaseEntities _dbContext = new JneCommSitesDataLayer.JneCommSitesDataBaseEntities(); List <JneCommSitesDataLayer.AspNetUsers> itemList = (from p in _dbContext.AspNetUsers from d in p.AspNetRoles where d.Name == "CrewRole" select p).ToList(); List <ListBoxHelper> listUsers = new List <ListBoxHelper>(); listUsers.Add(new ListBoxHelper { Selected = true, isChildren = false, Text = "All Users", Value = "AllUsers", }); foreach (JneCommSitesDataLayer.AspNetUsers item in itemList) { listUsers.Add(new ListBoxHelper { Selected = false, isChildren = false, Text = item.T_UsersData.UserFirstName + " " + item.T_UsersData.UserLastName, Value = item.UserName, }); } return(listUsers); }
public ActionResult EditUser(string userName) { if (string.IsNullOrEmpty(userName)) { return(RedirectToAction("UsersIndex", "Maintenance")); } JneCommSitesDataLayer.JneCommSitesDataBaseEntities _dbContext = new JneCommSitesDataLayer.JneCommSitesDataBaseEntities(); var aspNetUserQuery = (from p in _dbContext.AspNetUsers where p.UserName == userName select p).FirstOrDefault(); var rolQUery = (from p in _dbContext.AspNetRoles from d in p.AspNetUsers where d.Id == aspNetUserQuery.Id select p).FirstOrDefault(); var userInf = (from p in _dbContext.T_UsersData where p.Id == aspNetUserQuery.Id select p).First(); Models.CreateUserModel model = new Models.CreateUserModel(); model._UserGroup = Helper.Helper.GetRoles(); model.UserGroup = rolQUery.Name; model.UserName = aspNetUserQuery.UserName; model.firstName = userInf.UserFirstName; model.LastName = userInf.UserLastName; model.daysChangePass = Convert.ToInt16(userInf.NumDaysForPassChange); model.Email = aspNetUserQuery.Email; model.lockedOutUser = aspNetUserQuery.LockoutEnabled; model.forcePassChange = Convert.ToBoolean(userInf.ForcePassChange); return(View(model)); }
public ActionResult CreateCertification(Models.CertificationModel model) { if (ModelState.IsValid) { try { JneCommSitesDataLayer.JneCommSitesDataBaseEntities _dbContext = new JneCommSitesDataLayer.JneCommSitesDataBaseEntities(); var existCertification = (from p in _dbContext.T_Certifications where p.vCertificationName == model.certificationName select p).FirstOrDefault(); if (existCertification != null) { ModelState.AddModelError(string.Empty, "The certification already exist"); return(View()); } JneCommSitesDataLayer.T_Certifications newCertification = new JneCommSitesDataLayer.T_Certifications(); newCertification.vCertificationName = model.certificationName; newCertification.vCertificationDescription = model.certificationpDescription; _dbContext.T_Certifications.Add(newCertification); _dbContext.SaveChanges(); return(RedirectToAction("CertificationsList", "Maintenance")); } catch (Exception error) { ModelState.AddModelError(string.Empty, error.Message); return(View()); } } return(View()); }
public JsonResult GetPurchaseByUser(string purchaseType) { JneCommSitesDataLayer.JneCommSitesDataBaseEntities _dbContext = new JneCommSitesDataLayer.JneCommSitesDataBaseEntities(); string userName = HttpContext.User.Identity.Name; var queryCurrentActivityLog = (from p in _dbContext.T_ActivityLog where p.AspNetUsers.UserName == userName && (p.dtEndWorkingDay == null) select p).FirstOrDefault(); var queryPurchaseID = (from p in _dbContext.T_PurchaseType where p.vPurchaseTypeName == purchaseType select p.iPuchaseTypeID).FirstOrDefault(); List <PurchaseInformation> purchaseInformation = new List <PurchaseInformation>(); var purchaseQuery = (from p in _dbContext.T_ActivityLog from d in p.T_Purchase where p.AspNetUsers.UserName == userName && (p.dtEndWorkingDay == null) && d.iPuchaseTypeID == queryPurchaseID select d); foreach (var item in purchaseQuery) { purchaseInformation.Add(new PurchaseInformation { description = item.Description, purchaseDate = item.dtPurchaseStartDate.ToString(), invoiceName = item.InvoiceName }); } return(Json(purchaseInformation, JsonRequestBehavior.AllowGet)); }
public ActionResult CreateActivityLogOptions() { Models.ActivityLogsOptions model = GetActivityLogsOptionsModel(new Models.ActivityLogsOptions()); JneCommSitesDataLayer.JneCommSitesDataBaseEntities _dbContext = new JneCommSitesDataLayer.JneCommSitesDataBaseEntities(); string userName = HttpContext.User.Identity.Name; var queryUser = (from p in _dbContext.AspNetUsers where p.UserName == userName select p).FirstOrDefault(); var queryExistLogActivity = (from p in _dbContext.T_ActivityLog where p.AspNetUsers.UserName == userName && p.dtEndWorkingDay == null select p).FirstOrDefault(); if (queryExistLogActivity != null) { if (!string.IsNullOrEmpty(queryExistLogActivity.vSiteName)) { model.site = queryExistLogActivity.vSiteName; } } return(View(model)); }
public ActionResult EditCrewRol(Models.CrewRolModel model) { if (ModelState.IsValid) { try { JneCommSitesDataLayer.JneCommSitesDataBaseEntities _dbContext = new JneCommSitesDataLayer.JneCommSitesDataBaseEntities(); var queryCetification = (from p in _dbContext.T_CrewRoles where p.vCrewRoleName == model.crewRoleName select p).FirstOrDefault(); queryCetification.vCrewRoleDescription = model.crewRoleDescription; _dbContext.SaveChanges(); return(RedirectToAction("CrewRolesList", "Maintenance")); } catch (Exception error) { ModelState.AddModelError(string.Empty, error.Message); return(View()); } } return(View()); }
public JsonResult GetCrewUsersBySite(string siteName) { JneCommSitesDataLayer.JneCommSitesDataBaseEntities _dbContext = new JneCommSitesDataLayer.JneCommSitesDataBaseEntities(); var queryCrewUsersBySite = (from p in _dbContext.AspNetUsers from d in p.T_Sites where d.vSiteName == siteName select p); List <CrewUserData> crewUsers = new List <CrewUserData>(); foreach (var item in queryCrewUsersBySite) { string roleQuery = (from p in _dbContext.T_CrewRoles from d in p.AspNetUsers where d.Id == item.Id select p.vCrewRoleName).FirstOrDefault(); crewUsers.Add(new CrewUserData { crewName = item.UserName, crewRole = item.T_UsersData.UserFirstName + " " + item.T_UsersData.UserLastName + "-" + roleQuery }); } return(Json(crewUsers, JsonRequestBehavior.AllowGet)); }
public JsonResult GetExpensesBySite(string siteName) { JneCommSitesDataLayer.JneCommSitesDataBaseEntities _dbContext = new JneCommSitesDataLayer.JneCommSitesDataBaseEntities(); decimal totalExpenses = 0; List <ExpensesnBySite> expensesBySite = new List <ExpensesnBySite>(); var queryActivityLogBySite = (from p in _dbContext.T_ActivityLog where p.vSiteName == siteName select p); foreach (var item in queryActivityLogBySite) { var queryExpensesByLogActivity = (from p in _dbContext.T_Purchase where p.iActivityLogID == item.iActivityLogID select p); foreach (var itemExpense in queryExpensesByLogActivity) { totalExpenses = (totalExpenses + Convert.ToDecimal(itemExpense.dPrice)); expensesBySite.Add(new ExpensesnBySite { datePurchase = itemExpense.dtPurchaseStartDate.ToString(), purchaseDescription = itemExpense.Description, purchaseType = itemExpense.T_PurchaseType.vPurchaseTypeName, valuePurchase = itemExpense.dPrice.ToString(), totalExpenses = totalExpenses }); } } return(Json(expensesBySite, JsonRequestBehavior.AllowGet)); }
public ActionResult CreateEmployee() { JneCommSitesDataLayer.JneCommSitesDataBaseEntities _dbConetxt = new JneCommSitesDataLayer.JneCommSitesDataBaseEntities(); Models.EmployeeModel model = new Models.EmployeeModel(); string actualDate = "";// DateTime.Now.ToString("yyyy-MM-dd"); model._UserCrewGroup = Helper.Helper.GetSubRoles("CrewRole"); model._StatesList = Helper.Helper.GetUSAStates(); var queryCertifications = (from p in _dbConetxt.T_Certifications select p); model._ListCertifications = new List <Models.CertificationsByEmployee>(); foreach (var item in queryCertifications) { model._ListCertifications.Add(new Models.CertificationsByEmployee { certificationName = item.vCertificationName, expirationTime = actualDate }); } return(View(model)); }
public ActionResult EditTechEvolutionCode(Models.TechEvolutionCodesModel model) { if (ModelState.IsValid) { try { JneCommSitesDataLayer.JneCommSitesDataBaseEntities _dbContext = new JneCommSitesDataLayer.JneCommSitesDataBaseEntities(); var queryTechEvolutionCode = (from p in _dbContext.T_TechEvolutionCodes where p.vTechEvolutionCodeName == model.techEvolutionCodeName select p).FirstOrDefault(); queryTechEvolutionCode.vTechEvolutionCodeDescription = model.techEvolutionCodeDescription; _dbContext.SaveChanges(); return(RedirectToAction("TechEvolutionCodesList", "Maintenance")); } catch (Exception error) { ModelState.AddModelError(string.Empty, error.Message); return(View()); } } return(View()); }
public static List <ListBoxHelper> GetOperations(string rolName) { JneCommSitesDataLayer.JneCommSitesDataBaseEntities _dbContext = new JneCommSitesDataLayer.JneCommSitesDataBaseEntities(); List <JneCommSitesDataLayer.T_Operations> itemList = (from p in _dbContext.T_Operations where p.vControllerName != "Mobile" select p).ToList(); List <ListBoxHelper> listPermission = new List <ListBoxHelper>(); foreach (JneCommSitesDataLayer.T_Operations item in itemList) { bool selected = false; var operationByRol = (from p in _dbContext.T_Operations from d in p.AspNetRoles where d.Name == rolName select p); foreach (var itemOperation in operationByRol) { if (itemOperation.biOperationsId == item.biOperationsId) { selected = true; } } listPermission.Add(new ListBoxHelper { Selected = selected, isChildren = false, Text = item.vDisplayTittle, Value = item.biOperationsId.ToString(), }); } return(listPermission); }
public ActionResult TaskProgressList() { JneCommSitesDataLayer.JneCommSitesDataBaseEntities _dbContext = new JneCommSitesDataLayer.JneCommSitesDataBaseEntities(); var queryTaskActivity = from p in _dbContext.T_TaskProgress select p; return(View(queryTaskActivity)); }
public ActionResult TechEvolutionCodesList() { JneCommSitesDataLayer.JneCommSitesDataBaseEntities _dbContext = new JneCommSitesDataLayer.JneCommSitesDataBaseEntities(); var techEvolutionCodesQuery = (from p in _dbContext.T_TechEvolutionCodes orderby p.vTechEvolutionCodeName descending select p); return(View(techEvolutionCodesQuery)); }
public ActionResult CrewRolesList() { JneCommSitesDataLayer.JneCommSitesDataBaseEntities _dbContext = new JneCommSitesDataLayer.JneCommSitesDataBaseEntities(); var certificationsQuery = (from p in _dbContext.T_CrewRoles orderby p.vCrewRoleName descending select p); return(View(certificationsQuery)); }
public JsonResult GetCertifications() { JneCommSitesDataLayer.JneCommSitesDataBaseEntities _dbContext = new JneCommSitesDataLayer.JneCommSitesDataBaseEntities(); var queryCertifications = (from p in _dbContext.T_Certifications select p.vCertificationName); return(Json(queryCertifications, JsonRequestBehavior.AllowGet)); }
public ActionResult EditCustomer(Models.CustomerModels model) { if (ModelState.IsValid) { try { JneCommSitesDataLayer.JneCommSitesDataBaseEntities _dbContext = new JneCommSitesDataLayer.JneCommSitesDataBaseEntities(); var queryCustomer = (from p in _dbContext.T_Customer where p.vCustomerName == model.custumerName select p).FirstOrDefault(); model._StatesList = Helper.Helper.GetUSAStates(); //queryCustomer.custumerName = model.custumerName; queryCustomer.vCustomerAddress = model.customerAddress; queryCustomer.vStateCode = model.states; queryCustomer.vCustomerCity = model.customerCity; _dbContext.SaveChanges(); JneCommSitesDataLayer.JneCommSitesDataBaseEntities _dbContextContacts = new JneCommSitesDataLayer.JneCommSitesDataBaseEntities(); var queryContactsByCustomer = (from p in _dbContextContacts.T_ContactsByCustomer where p.vCustomerName == model.custumerName select p); foreach (var item in queryContactsByCustomer) { _dbContextContacts.T_ContactsByCustomer.Remove(item); } _dbContextContacts.SaveChanges(); foreach (var item in model._ListContacts) { JneCommSitesDataLayer.T_ContactsByCustomer newContactByCustomer = new JneCommSitesDataLayer.T_ContactsByCustomer(); newContactByCustomer.vContactName = item.contactName; newContactByCustomer.vEmailContact = item.contactEmail; newContactByCustomer.vPhoneContact = item.contactPhone; newContactByCustomer.vAreaContact = item.contactArea; newContactByCustomer.vCustomerName = model.custumerName; _dbContext.T_ContactsByCustomer.Add(newContactByCustomer); _dbContext.SaveChanges(); } return(Json(true)); } catch (Exception error) { return(Json(error.Message)); } } return(Json("There is a error, Please try again.")); }
public static string GetCrewRoleByUser(string userName) { JneCommSitesDataLayer.JneCommSitesDataBaseEntities _dbContext = new JneCommSitesDataLayer.JneCommSitesDataBaseEntities(); string queryRol = (from p in _dbContext.T_CrewRoles from d in p.AspNetUsers where d.UserName == userName select p.vCrewRoleName).FirstOrDefault(); return(queryRol); }
public ActionResult Index() { JneCommSitesDataLayer.JneCommSitesDataBaseEntities _dbContext = new JneCommSitesDataLayer.JneCommSitesDataBaseEntities(); DateTime timeExpirationAlert = DateTime.Now.AddDays(15); var queryCertification = (from p in _dbContext.T_CertificationsByUserCrew where timeExpirationAlert > p.dExpirationTime select p); return(View(queryCertification)); }
public ActionResult CreateCustomer(Models.CustomerModels model) { if (ModelState.IsValid) { JneCommSitesDataLayer.JneCommSitesDataBaseEntities _dbContext = new JneCommSitesDataLayer.JneCommSitesDataBaseEntities(); var queryCustomer = (from p in _dbContext.T_Customer where p.vCustomerName == model.custumerName select p).FirstOrDefault(); if (queryCustomer != null) { ModelState.AddModelError(string.Empty, "The Customer already exist"); model._StatesList = Helper.Helper.GetUSAStates(); return(Json("The Customer already exist")); } JneCommSitesDataLayer.T_Customer newCustomer = new JneCommSitesDataLayer.T_Customer(); newCustomer.vCustomerName = model.custumerName; newCustomer.vCustomerAddress = model.customerAddress; newCustomer.vCustomerCity = model.customerCity; newCustomer.vStateCode = model.states; _dbContext.T_Customer.Add(newCustomer); _dbContext.SaveChanges(); foreach (var item in model._ListContacts) { JneCommSitesDataLayer.T_ContactsByCustomer newContactByCustomer = new JneCommSitesDataLayer.T_ContactsByCustomer(); newContactByCustomer.vContactName = item.contactName; newContactByCustomer.vEmailContact = item.contactEmail; newContactByCustomer.vPhoneContact = item.contactPhone; newContactByCustomer.vAreaContact = item.contactArea; newContactByCustomer.vCustomerName = model.custumerName; _dbContext.T_ContactsByCustomer.Add(newContactByCustomer); _dbContext.SaveChanges(); } return(Json(true)); } if (model._ListContacts == null) { return(Json("You need add a contact for the costumer.")); } return(Json("There is a error, please try again.")); }
public ActionResult CustomersIndex(string customerID) { if (string.IsNullOrEmpty(customerID)) { customerID = ""; } JneCommSitesDataLayer.JneCommSitesDataBaseEntities _dbContext = new JneCommSitesDataLayer.JneCommSitesDataBaseEntities(); var queryCustomers = (from p in _dbContext.T_Customer where p.vCustomerName.Contains(customerID) orderby p.vCustomerName descending select p); return(View(queryCustomers)); }
public ActionResult PaymentPeriod() { JneCommSitesDataLayer.JneCommSitesDataBaseEntities _dbContext = new JneCommSitesDataLayer.JneCommSitesDataBaseEntities(); var paymentPeriodQuery = (from p in _dbContext.T_PaymentPeriod select p).FirstOrDefault(); if (paymentPeriodQuery == null) { paymentPeriodQuery = new JneCommSitesDataLayer.T_PaymentPeriod(); paymentPeriodQuery.dStartCutOffDate = DateTime.Now; } return(View(paymentPeriodQuery)); }
public ActionResult CrewEmployeeIndex(string userID) { if (string.IsNullOrEmpty(userID)) { userID = ""; } JneCommSitesDataLayer.JneCommSitesDataBaseEntities _dbContext = new JneCommSitesDataLayer.JneCommSitesDataBaseEntities(); var queryUsers = (from p in _dbContext.vwUserData where p.UserName.Contains(userID) && p.RoleName == "CrewRole" select p); return(View(queryUsers)); }
public ActionResult Purchase(Models.ActivityLogsPurchase model) { if (ModelState.IsValid) { JneCommSitesDataLayer.JneCommSitesDataBaseEntities _dbContext = new JneCommSitesDataLayer.JneCommSitesDataBaseEntities(); string userName = HttpContext.User.Identity.Name; var queryCurrentActivityLog = (from p in _dbContext.T_ActivityLog where p.AspNetUsers.UserName == userName && (p.dtEndWorkingDay == null) select p).FirstOrDefault(); var queryPurchaseID = (from p in _dbContext.T_PurchaseType where p.vPurchaseTypeName == model.purchaseType select p.iPuchaseTypeID).FirstOrDefault(); JneCommSitesDataLayer.T_Purchase newPurchase = new JneCommSitesDataLayer.T_Purchase(); string invoiceName = "Nothing"; newPurchase.iActivityLogID = queryCurrentActivityLog.iActivityLogID; newPurchase.Description = model.description; newPurchase.iPuchaseTypeID = queryPurchaseID; newPurchase.dtPurchaseEndDate = Convert.ToDateTime(DateTime.Now); newPurchase.dtPurchaseStartDate = Convert.ToDateTime(model.startPurchaseCheckPoint, culture); newPurchase.dPrice = Convert.ToDecimal(model.price); newPurchase.vPosition = model.position; _dbContext.T_Purchase.Add(newPurchase); if (model.documentToUpload != null) { invoiceName = userName + "_" + model.description.Replace(" ", "") + DateTime.Now.Year + DateTime.Now.Month + DateTime.Now.Day + DateTime.Now.Hour + DateTime.Now.Minute + DateTime.Now.Second + "_" + Path.GetExtension(model.documentToUpload.FileName).Replace(" ", ""); string path = System.IO.Path.Combine(Server.MapPath("~/Documents/Invoices/"), invoiceName); // file is uploaded model.documentToUpload.SaveAs(path); } newPurchase.InvoiceName = invoiceName; _dbContext.SaveChanges(); return(View(model)); } else { return(RedirectToAction("CreateActivityLogOptions")); } }
public ActionResult EditCertification(string certificationName) { JneCommSitesDataLayer.JneCommSitesDataBaseEntities _dbContext = new JneCommSitesDataLayer.JneCommSitesDataBaseEntities(); Models.CertificationModel newCertificationModel = new CertificationModel(); var queryCertification = (from p in _dbContext.T_Certifications where p.vCertificationName == certificationName select p).FirstOrDefault(); if (queryCertification == null) { RedirectToAction("CertificationsList", "Maintenance"); } newCertificationModel.certificationpDescription = queryCertification.vCertificationDescription; newCertificationModel.certificationName = queryCertification.vCertificationName; return(View(newCertificationModel)); }
public ActionResult EditTaskProgress(int taskProgressID) { JneCommSitesDataLayer.JneCommSitesDataBaseEntities _dbContext = new JneCommSitesDataLayer.JneCommSitesDataBaseEntities(); Models.TaskProgress newTaskProgressModel = new TaskProgress(); var queryTaskProgress = (from p in _dbContext.T_TaskProgress where p.iTaskProgressID == taskProgressID select p).FirstOrDefault(); newTaskProgressModel.taskName = queryTaskProgress.vTaskProgressName; newTaskProgressModel.taskDescription = queryTaskProgress.vTaskDescription; newTaskProgressModel.canUploadFile = queryTaskProgress.bCanLoadFile; newTaskProgressModel.isActive = Convert.ToBoolean(queryTaskProgress.bIsActive); return(View(newTaskProgressModel)); }
public ActionResult EditCrewRol(string crewRoleName) { JneCommSitesDataLayer.JneCommSitesDataBaseEntities _dbContext = new JneCommSitesDataLayer.JneCommSitesDataBaseEntities(); Models.CrewRolModel newCrewRolModel = new CrewRolModel(); var queryCrewRole = (from p in _dbContext.T_CrewRoles where p.vCrewRoleName == crewRoleName select p).FirstOrDefault(); if (queryCrewRole == null) { RedirectToAction("CrewRolesList", "Maintenance"); } newCrewRolModel.crewRoleName = queryCrewRole.vCrewRoleName; newCrewRolModel.crewRoleDescription = queryCrewRole.vCrewRoleDescription; return(View(newCrewRolModel)); }
public ActionResult EditTechEvolutionCode(string techEvolutionCodeName) { JneCommSitesDataLayer.JneCommSitesDataBaseEntities _dbContext = new JneCommSitesDataLayer.JneCommSitesDataBaseEntities(); Models.TechEvolutionCodesModel newTechEvolutionCode = new TechEvolutionCodesModel(); var querytechEvolutionCode = (from p in _dbContext.T_TechEvolutionCodes where p.vTechEvolutionCodeName == techEvolutionCodeName select p).FirstOrDefault(); if (querytechEvolutionCode == null) { RedirectToAction("TechEvolutionCodesList", "Maintenance"); } newTechEvolutionCode.techEvolutionCodeName = querytechEvolutionCode.vTechEvolutionCodeName; newTechEvolutionCode.techEvolutionCodeDescription = querytechEvolutionCode.vTechEvolutionCodeDescription; return(View(newTechEvolutionCode)); }
public static List <Entry> GetCustomers() { JneCommSitesDataLayer.JneCommSitesDataBaseEntities _dbContext = new JneCommSitesDataLayer.JneCommSitesDataBaseEntities(); List <JneCommSitesDataLayer.T_Customer> itemList = (from p in _dbContext.T_Customer select p).ToList(); List <Entry> items = new List <Entry>(); foreach (JneCommSitesDataLayer.T_Customer item in itemList) { items.Add(new Entry { ID = item.vCustomerName, Description = item.vCustomerName }); } return(items); }
public static List <Entry> GetTechEvolutionCodes() { JneCommSitesDataLayer.JneCommSitesDataBaseEntities _dbContext = new JneCommSitesDataLayer.JneCommSitesDataBaseEntities(); List <JneCommSitesDataLayer.T_TechEvolutionCodes> itemList = (from p in _dbContext.T_TechEvolutionCodes select p).ToList(); List <Entry> items = new List <Entry>(); foreach (JneCommSitesDataLayer.T_TechEvolutionCodes item in itemList) { items.Add(new Entry { ID = item.vTechEvolutionCodeName, Description = item.vTechEvolutionCodeName }); } return(items); }
public ActionResult CreateTaskProgress(Models.TaskProgress model) { if (ModelState.IsValid) { JneCommSitesDataLayer.JneCommSitesDataBaseEntities _dbContext = new JneCommSitesDataLayer.JneCommSitesDataBaseEntities(); JneCommSitesDataLayer.T_TaskProgress newTaskProgress = new JneCommSitesDataLayer.T_TaskProgress(); newTaskProgress.vTaskProgressName = model.taskName; newTaskProgress.vTaskDescription = model.taskDescription; newTaskProgress.bCanLoadFile = model.canUploadFile; newTaskProgress.bIsActive = model.isActive; _dbContext.T_TaskProgress.Add(newTaskProgress); _dbContext.SaveChanges(); return(RedirectToAction("TaskProgressList")); } ModelState.AddModelError(string.Empty, "There is an error, Try again."); return(View()); }