public ActionResult Create(tbl_RequestProcess collection) { try { // TODO: Add insert logic here CheckViewBagData(); collection.RequestProcessDate = DateTime.Now; _DbWorkPermitSystemEntities.tbl_RequestProcess.Add(collection); _DbWorkPermitSystemEntities.SaveChanges(); return(RedirectToAction("Index")); } catch { return(View()); } }
public JsonResult ManageProcessRequestStatusUpdate(tbl_RequestProcess collection) { try { var _objAllRequestProcessModel = _DbWorkPermitSystemEntities.tbl_RequestProcess.Where(a => a.RequestProcessSrNo == collection.RequestProcessSrNo).FirstOrDefault(); _objAllRequestProcessModel.SafetyStatus = collection.SafetyStatus; _objAllRequestProcessModel.AreaOwnerStatus = collection.AreaOwnerStatus; _objAllRequestProcessModel.ActivityOwnerStatus = collection.ActivityOwnerStatus; _objAllRequestProcessModel.ContractorStatus = collection.ContractorStatus; _DbWorkPermitSystemEntities.Entry(_objAllRequestProcessModel).State = EntityState.Modified; _DbWorkPermitSystemEntities.SaveChanges(); ResultModel _objResult = new ResultModel(); _objResult.success = 1; _objResult.msg = "Save Successfully"; var _objAllRequestProcessNewModel = _DbWorkPermitSystemEntities.tbl_RequestProcess.Where(a => a.RequestProcessSrNo == collection.RequestProcessSrNo).FirstOrDefault(); if (_objAllRequestProcessNewModel.EmployeeDepartmentID == collection.EmployeeDepartmentID && _objAllRequestProcessNewModel.AreaOwnerStatus == "Accepted" && _objAllRequestProcessNewModel.ActivityOwnerStatus == "None" && _objAllRequestProcessNewModel.SafetyStatus == "None" && _objAllRequestProcessNewModel.ContractorStatus == "None") { var _departmentlist = _DbWorkPermitSystemEntities.tbl_DepartmentEmployeeRegistration.ToList().Where(a => a.tbl_DepartmentMaster.DepartmentID == collection.EmployeeDepartmentID && a.tbl_DesignationMaster.DesignationName == "Area Owner"); //Notification For Area Owner foreach (var item in _departmentlist) { SendPushNotification(item.DeviceTokenId, "New Vendor Request", "Manage Vendors"); } } else if (_objAllRequestProcessNewModel.EmployeeDepartmentID == collection.EmployeeDepartmentID && _objAllRequestProcessNewModel.AreaOwnerStatus == "Accepted" && _objAllRequestProcessNewModel.ActivityOwnerStatus == "Accepted" && _objAllRequestProcessNewModel.SafetyStatus == "None" && _objAllRequestProcessNewModel.ContractorStatus == "None") { var _departmentlist = _DbWorkPermitSystemEntities.tbl_DepartmentEmployeeRegistration.ToList().Where(a => a.tbl_DepartmentMaster.DepartmentID == collection.EmployeeDepartmentID && a.tbl_DesignationMaster.DesignationName == "Activity Owner"); //Notification For Activity Owner foreach (var item in _departmentlist) { SendPushNotification(item.DeviceTokenId, "Request Accepted From Area Owner..! Request ID " + _objAllRequestProcessNewModel.RequestProcessSrNo.ToString(), "Manage Vendors"); } } else if (_objAllRequestProcessNewModel.AreaOwnerStatus == "Accepted" && _objAllRequestProcessNewModel.ActivityOwnerStatus == "Accepted" && _objAllRequestProcessNewModel.SafetyStatus == "None" && _objAllRequestProcessNewModel.ContractorStatus == "None") { var _departmentlist = _DbWorkPermitSystemEntities.tbl_DepartmentEmployeeRegistration.ToList().Where(a => a.tbl_DesignationMaster.DesignationName == "Safety"); //Notification For Safety foreach (var item in _departmentlist) { SendPushNotification(item.DeviceTokenId, "Request Accepted From Activity Owner..! Request ID " + _objAllRequestProcessNewModel.RequestProcessSrNo.ToString(), "Manage Vendors"); } } else if (_objAllRequestProcessNewModel.AreaOwnerStatus == "Accepted" && _objAllRequestProcessNewModel.ActivityOwnerStatus == "Accepted" && _objAllRequestProcessNewModel.SafetyStatus == "Accepted" && _objAllRequestProcessNewModel.ContractorStatus == "None") { var _venderlist = _DbWorkPermitSystemEntities.tbl_VendorUserRegistration.ToList().Where(a => a.VendorSrNo == collection.VendorSrNo); //Notification VendorUser foreach (var item in _venderlist) { SendPushNotification(item.DeviceTokenId, "Request Accepted From Department...! Request ID " + _objAllRequestProcessNewModel.RequestProcessSrNo.ToString(), "Manage Vendors"); } } else if (_objAllRequestProcessNewModel.AreaOwnerStatus == "Accepted" && _objAllRequestProcessNewModel.ActivityOwnerStatus == "Accepted" && _objAllRequestProcessNewModel.SafetyStatus == "Accepted" && _objAllRequestProcessNewModel.ContractorStatus == "Accepted") { var _departmentlist = _DbWorkPermitSystemEntities.tbl_DepartmentEmployeeRegistration.ToList().Where(a => _objAllRequestProcessNewModel.EmployeeDepartmentID == collection.EmployeeDepartmentID && a.tbl_DesignationMaster.DesignationName == "Activity Owner" || a.tbl_DesignationMaster.DesignationName == "Area Owner"); var _safetylist = _DbWorkPermitSystemEntities.tbl_DepartmentEmployeeRegistration.ToList().Where(a => a.tbl_DesignationMaster.DesignationName == "Safety"); var AllList = _departmentlist.Union(_safetylist); //Notification For All Department Send From Vendor foreach (var item in AllList) { SendPushNotification(item.DeviceTokenId, "Contractor Submit Request", "Manage Vendors"); } } return(Json(_objResult, JsonRequestBehavior.AllowGet)); } catch (Exception ex) { ResultModel _objResult = new ResultModel(); _objResult.success = 0; _objResult.msg = ex.ToString(); return(Json(_objResult, JsonRequestBehavior.AllowGet)); } }
public JsonResult AddRequestProcess(RequestProcessModel collection) { try { if (ModelState.IsValid) { tbl_RequestProcess _objRequestProcess = new tbl_RequestProcess(); _objRequestProcess.EmployeeId = collection.EmployeeId; _objRequestProcess.RequestProcessSrNo = collection.RequestProcessSrNo; _objRequestProcess.VendorSrNo = collection.VendorSrNo; _objRequestProcess.EmployeeDepartmentID = collection.EmployeeDepartmentID; _objRequestProcess.VisitStartTime = collection.VisitStartTime; _objRequestProcess.VendorAccessories = collection.VendorAccessories; _objRequestProcess.NoOfVendors = collection.NoOfVendors; _objRequestProcess.VendorVisitResons = collection.VendorVisitResons; _objRequestProcess.RequestProcessDate = collection.RequestProcessDate; _objRequestProcess.ActivityOwnerStatus = collection.ActivityOwnerStatus; _objRequestProcess.AreaOwnerStatus = collection.AreaOwnerStatus; _objRequestProcess.SafetyStatus = collection.SafetyStatus; _objRequestProcess.ContractorStatus = collection.ContractorStatus; _objRequestProcess.VisitEndTime = collection.VisitEndTime; _DbWorkPermitSystemEntities.tbl_RequestProcess.Add(_objRequestProcess); _DbWorkPermitSystemEntities.SaveChanges(); ResultModel _objResult = new ResultModel(); _objResult.success = 1; _objResult.msg = "Save Successfully"; var _owneractivitylist = _DbWorkPermitSystemEntities.tbl_DepartmentEmployeeRegistration.ToList().Where(a => a.tbl_DepartmentMaster.DepartmentID == collection.EmployeeDepartmentID && a.tbl_DesignationMaster.DesignationName == "Area Owner"); //Notification Activity Owner foreach (var item in _owneractivitylist) { SendPushNotification(item.DeviceTokenId, "New Vendor Request", "Manage Vendors"); } return(Json(_objResult, JsonRequestBehavior.AllowGet)); } else { List <ErrorList> Errors = new List <ErrorList>(); //test errors. var modelStateErrors = this.ModelState.Keys.SelectMany(key => this.ModelState[key].Errors); foreach (var x in modelStateErrors) { var errorInfo = new ErrorList() { ErrorMessage = x.ErrorMessage }; Errors.Add(errorInfo); } return(Json(Errors, JsonRequestBehavior.AllowGet)); } } catch (Exception ex) { ResultModel _objResult = new ResultModel(); _objResult.success = 0; _objResult.msg = ex.ToString(); return(Json(_objResult, JsonRequestBehavior.AllowGet)); } }
public async void StatusUpdate() { try { progressDialog = ProgressDialog.Show(this, Android.Text.Html.FromHtml("<font color='#EC407A'> Please wait...</font>"), Android.Text.Html.FromHtml("<font color='#EC407A'> Checking User Info...</font>"), true); tbl_RequestProcess _objRequestProcessModel = new tbl_RequestProcess(); _objRequestProcessModel.EmployeeId = ResultProcessRequestDetailsByRequestIDModel.EmployeeId; _objRequestProcessModel.VendorSrNo = ResultProcessRequestDetailsByRequestIDModel.VendorSrNo; _objRequestProcessModel.RequestProcessSrNo = ResultProcessRequestDetailsByRequestIDModel.RequestProcessSrNo; _objRequestProcessModel.EmployeeDepartmentID = ResultProcessRequestDetailsByRequestIDModel.EmployeeDepartmentID; _objRequestProcessModel.VisitStartTime = ResultProcessRequestDetailsByRequestIDModel.VisitStartTime; _objRequestProcessModel.VisitEndTime = ResultProcessRequestDetailsByRequestIDModel.VisitEndTime; _objRequestProcessModel.VendorAccessories = ResultProcessRequestDetailsByRequestIDModel.VendorAccessories; _objRequestProcessModel.NoOfVendors = ResultProcessRequestDetailsByRequestIDModel.NoOfVendors; _objRequestProcessModel.VendorVisitResons = ResultProcessRequestDetailsByRequestIDModel.VendorVisitResons; _objRequestProcessModel.RequestProcessDate = ResultProcessRequestDetailsByRequestIDModel.RequestProcessDate; if (ButtonAcceptOrDecline == "Decline") { if (StatusModel.EmployeeDesignationName == "Activity Owner") { _objRequestProcessModel.ActivityOwnerStatus = "Decline"; } else { _objRequestProcessModel.ActivityOwnerStatus = ResultProcessRequestDetailsByRequestIDModel.ActivityOwnerStatus; } if (StatusModel.EmployeeDesignationName == "Area Owner") { _objRequestProcessModel.AreaOwnerStatus = "Decline"; } else { _objRequestProcessModel.AreaOwnerStatus = ResultProcessRequestDetailsByRequestIDModel.AreaOwnerStatus; } if (StatusModel.EmployeeDesignationName == "Safety") { _objRequestProcessModel.SafetyStatus = "Decline"; } else { _objRequestProcessModel.SafetyStatus = ResultProcessRequestDetailsByRequestIDModel.SafetyStatus; } if (StatusModel.LoginUserStatus == 1) { _objRequestProcessModel.ContractorStatus = "Decline"; } else { _objRequestProcessModel.ContractorStatus = ResultProcessRequestDetailsByRequestIDModel.ContractorStatus; } } else { if (StatusModel.EmployeeDesignationName == "Activity Owner") { _objRequestProcessModel.ActivityOwnerStatus = "Accepted"; } else { _objRequestProcessModel.ActivityOwnerStatus = ResultProcessRequestDetailsByRequestIDModel.ActivityOwnerStatus; } if (StatusModel.EmployeeDesignationName == "Area Owner") { _objRequestProcessModel.AreaOwnerStatus = "Accepted"; } else { _objRequestProcessModel.AreaOwnerStatus = ResultProcessRequestDetailsByRequestIDModel.AreaOwnerStatus; } if (StatusModel.EmployeeDesignationName == "Safety") { _objRequestProcessModel.SafetyStatus = "Accepted"; } else { _objRequestProcessModel.SafetyStatus = ResultProcessRequestDetailsByRequestIDModel.SafetyStatus; } if (StatusModel.LoginUserStatus == 1) { _objRequestProcessModel.ContractorStatus = "Accepted"; } else { _objRequestProcessModel.ContractorStatus = ResultProcessRequestDetailsByRequestIDModel.ContractorStatus; } } string Url = StatusModel.Url + "ManageProcessRequestStatusUpdate"; WebHelpper _objHelper = new WebHelpper(); var PostString = JsonConvert.SerializeObject(_objRequestProcessModel); var request = await _objHelper.MakePostRequest(Url, PostString, true); ResultModel ResultgetRequest = JsonConvert.DeserializeObject <ResultModel>(request); if (ResultgetRequest.success == 1) { progressDialog.Hide(); Toast.MakeText(this, ResultgetRequest.msg, ToastLength.Short).Show(); } else { progressDialog.Hide(); Toast.MakeText(this, ResultgetRequest.msg, ToastLength.Short).Show(); return; } } catch (Exception ex) { progressDialog.Hide(); string ErrorMsg = ex.ToString(); Toast.MakeText(this, ErrorMsg, ToastLength.Long).Show(); } }