private static ProjectInfo getFirstProject(DSMContext dbcontext) { var item = dbcontext.ProjectInfo.FirstOrDefault(); if (item == null) { item = new ProjectInfo(); item.Id = Guid.NewGuid(); item.Name = "测试工程。"; dbcontext.Add(item); dbcontext.SaveChanges(); } return(item); }
/// <summary> /// Add and Edit Document /// </summary> /// <param name="data"></param> /// <param name="userId"></param> /// <returns></returns> public CommonResponse AddAndEditCheckListJobAssignedResource(CheckListJobAssignedResourceMasterCustom data, long userId = 0) { CommonResponse obj = new CommonResponse(); try { var res = db.CheckListJobAssignedResourceMaster.Where(m => m.CheckListJobMasterId == data.checkListJobMasterId && m.CheckListJobGroupId == data.checkListJobGroupId).FirstOrDefault(); if (res == null) { try { CheckListJobAssignedResourceMaster item = new CheckListJobAssignedResourceMaster(); item.CheckListJobMasterId = data.checkListJobMasterId; item.CheckListJobGroupId = data.checkListJobGroupId; item.PrimaryResource = data.primaryResource; item.PrimaryResourceToAllFlag = data.primaryResourceToAllFlag; item.SecondaryResource = data.secondaryResource; item.SecondaryResourceToAllFlag = data.secondaryResourceToAllFlag; item.IsActive = true; item.IsDeleted = false; item.CreatedBy = userId; item.CreatedOn = DateTime.Now; db.CheckListJobAssignedResourceMaster.Add(item); db.SaveChanges(); obj.response = ResourceResponse.AddedSucessfully; obj.isStatus = true; } catch (Exception ex) { log.Error(ex); if (ex.InnerException != null) { log.Error(ex.InnerException.ToString()); } obj.response = ResourceResponse.ExceptionMessage; obj.isStatus = false; } } else { try { res.CheckListJobMasterId = data.checkListJobMasterId; res.CheckListJobGroupId = data.checkListJobGroupId; res.PrimaryResource = data.primaryResource; res.PrimaryResourceToAllFlag = data.primaryResourceToAllFlag; res.SecondaryResource = data.secondaryResource; res.SecondaryResourceToAllFlag = data.secondaryResourceToAllFlag; res.ModifiedBy = userId; res.ModifiedOn = DateTime.Now; db.SaveChanges(); obj.response = ResourceResponse.UpdatedSucessfully; obj.isStatus = true; } catch (Exception ex) { log.Error(ex); if (ex.InnerException != null) { log.Error(ex.InnerException.ToString()); } obj.response = ResourceResponse.ExceptionMessage; obj.isStatus = false; } } } catch (Exception ex) { log.Error(ex); if (ex.InnerException != null) { log.Error(ex.InnerException.ToString()); } obj.response = ResourceResponse.ExceptionMessage; obj.isStatus = false; } return(obj); }
/// <summary> /// Add and Edit Document /// </summary> /// <param name="data"></param> /// <param name="userId"></param> /// <returns></returns> public CommonResponse AddAndEditCheckListJobActivity(CheckListJobActivityCustom data, long userId = 0) { CommonResponse obj = new CommonResponse(); CommonFunction commonFunction = new CommonFunction(); try { var res = db.CheckListJobActivityMaster.Where(m => m.CheckListJobActivityId == data.checkListJobActivityId).FirstOrDefault(); if (res == null) { try { var stepCount = commonFunction.ChangeCheckListAndJobStepNumberOfPreviousItem(data.checkListJobMasterId, data.checkListJobGroupId, "Activity", "Job"); CheckListJobActivityMaster item = new CheckListJobActivityMaster(); item.CheckListJobMasterId = data.checkListJobMasterId; item.CheckListJobGroupId = data.checkListJobGroupId; item.ActivitySubCategoryId = data.activitySubCategoryId; item.CheckListJobStepNumber = stepCount + 1; item.Remarks = data.remarks; item.ActivityDescription = data.activityDescription; item.IsActivityManditory = data.isActivityManditory; item.IsPhotoManditory = data.isPhotoManditory; item.IsBarCodeManditory = data.isBarCodeManditory; try { item.ExpectedCompletionTime = data.expectedCompletionTime; } catch (Exception ex) { } item.AssetId = data.assetId; item.IsActive = true; item.IsDeleted = false; item.IsAdminApproved = true; item.CreatedBy = userId; item.CreatedOn = DateTime.Now; db.CheckListJobActivityMaster.Add(item); db.SaveChanges(); obj.response = ResourceResponse.AddedSucessfully; obj.isStatus = true; } catch (Exception ex) { log.Error(ex); if (ex.InnerException != null) { log.Error(ex.InnerException.ToString()); } obj.response = ResourceResponse.ExceptionMessage; obj.isStatus = false; } } else { try { res.CheckListJobMasterId = data.checkListJobMasterId; res.CheckListJobGroupId = data.checkListJobGroupId; res.ActivitySubCategoryId = data.activitySubCategoryId; res.CheckListJobStepNumber = data.checkListJobStepNumber; res.Remarks = data.remarks; res.ActivityDescription = data.activityDescription; res.IsActivityManditory = data.isActivityManditory; res.IsPhotoManditory = data.isPhotoManditory; res.IsBarCodeManditory = data.isBarCodeManditory; res.AssetId = data.assetId; try { res.ExpectedCompletionTime = data.expectedCompletionTime; } catch (Exception ex) { } res.ModifiedBy = userId; res.ModifiedOn = DateTime.Now; db.SaveChanges(); obj.response = ResourceResponse.UpdatedSucessfully; obj.isStatus = true; } catch (Exception ex) { log.Error(ex); if (ex.InnerException != null) { log.Error(ex.InnerException.ToString()); } obj.response = ResourceResponse.ExceptionMessage; obj.isStatus = false; } } } catch (Exception ex) { log.Error(ex); if (ex.InnerException != null) { log.Error(ex.InnerException.ToString()); } obj.response = ResourceResponse.ExceptionMessage; obj.isStatus = false; } return(obj); }
/// <summary> /// Add and Edit Document /// </summary> /// <param name="data"></param> /// <param name="userId"></param> /// <returns></returns> public CommonResponse AddAndEditDesignation(DesignationCustom data, long userId = 0) { CommonResponse obj = new CommonResponse(); try { var res = db.DesignationMaster.Where(m => m.DesignationId == data.designationId).FirstOrDefault(); if (res == null) { try { DesignationMaster item = new DesignationMaster(); item.DesignationName = data.designationName; item.DesignationDescription = data.designationDescription; item.IsActive = true; item.IsDeleted = false; item.CreatedBy = userId; item.CreatedOn = DateTime.Now; db.DesignationMaster.Add(item); db.SaveChanges(); obj.response = ResourceResponse.AddedSucessfully; obj.isStatus = true; } catch (Exception ex) { log.Error(ex); if (ex.InnerException != null) { log.Error(ex.InnerException.ToString()); } obj.response = ResourceResponse.ExceptionMessage; obj.isStatus = false; } } else { try { res.DesignationName = data.designationName; res.DesignationDescription = data.designationDescription; res.ModifiedBy = userId; res.ModifiedOn = DateTime.Now; db.SaveChanges(); obj.response = ResourceResponse.UpdatedSucessfully; obj.isStatus = true; } catch (Exception ex) { log.Error(ex); if (ex.InnerException != null) { log.Error(ex.InnerException.ToString()); } obj.response = ResourceResponse.ExceptionMessage; obj.isStatus = false; } } } catch (Exception ex) { log.Error(ex); if (ex.InnerException != null) { log.Error(ex.InnerException.ToString()); } obj.response = ResourceResponse.ExceptionMessage; obj.isStatus = false; } return(obj); }
/// <summary> /// Add and Edit Document /// </summary> /// <param name="data"></param> /// <param name="userId"></param> /// <returns></returns> public CommonResponse AddAndEditUser(UserDetailsCustom data, long usersId = 0) { CommonResponse obj = new CommonResponse(); Security security = new Security(); string passwordEncrypt = security.Encrypt(data.password); try { var res = db.UserDetails.Where(m => m.UserId == data.userId).FirstOrDefault(); if (res == null) { try { UserDetails item = new UserDetails(); item.UserName = data.userName; item.Password = passwordEncrypt; item.UserFirstName = data.userFirstName; item.UserLastName = data.userLastName; item.UserFullName = data.userFullName; item.EmailId = data.emailId; item.PhoneNumber = data.phoneNumber; item.RoleId = data.roleId; item.DesignationId = data.designationId; item.DepartmentId = data.departmentId; item.ReportingManagerName = data.reportingManagerName; item.ReportManagerId = data.reportingManagerId; item.EmployeeUniqueCode = data.employeeUniqueCode; item.DocumentUploadedId = data.documentUploadedId; item.IsActive = true; item.IsAdminApproved = true; item.IsDeleted = false; item.CreatedBy = usersId; item.CreatedOn = DateTime.Now; db.UserDetails.Add(item); db.SaveChanges(); obj.response = ResourceResponse.AddedSucessfully; obj.isStatus = true; } catch (Exception ex) { log.Error(ex); if (ex.InnerException != null) { log.Error(ex.InnerException.ToString()); } obj.response = ResourceResponse.ExceptionMessage; obj.isStatus = false; } } else { try { res.UserName = data.userName; //res.Password = passwordEncrypt; res.UserFirstName = data.userFirstName; res.UserLastName = data.userLastName; res.UserFullName = data.userFullName; res.EmailId = data.emailId; res.PhoneNumber = data.phoneNumber; res.RoleId = data.roleId; res.DesignationId = data.designationId; res.DepartmentId = data.departmentId; res.ReportingManagerName = data.reportingManagerName; res.ReportManagerId = data.reportingManagerId; res.EmployeeUniqueCode = data.employeeUniqueCode; res.DocumentUploadedId = data.documentUploadedId; res.ModifiedBy = usersId; res.ModifiedOn = DateTime.Now; db.SaveChanges(); obj.response = ResourceResponse.UpdatedSucessfully; obj.isStatus = true; } catch (Exception ex) { log.Error(ex); if (ex.InnerException != null) { log.Error(ex.InnerException.ToString()); } obj.response = ResourceResponse.ExceptionMessage; obj.isStatus = false; } } } catch (Exception ex) { log.Error(ex); if (ex.InnerException != null) { log.Error(ex.InnerException.ToString()); } obj.response = ResourceResponse.ExceptionMessage; obj.isStatus = false; } return(obj); }
/// <summary> /// Add and Edit Document /// </summary> /// <param name="data"></param> /// <param name="userId"></param> /// <returns></returns> public CommonResponse AddAndEditCheckListLOTOTO(CheckListLOTOTOCustom data, long userId = 0) { CommonResponse obj = new CommonResponse(); CommonFunction commonFunction = new CommonFunction(); try { var res = db.CheckListLototomaster.Where(m => m.LototoCheckListId == data.checkListLOTOTOId).FirstOrDefault(); if (res == null) { try { var stepCount = commonFunction.ChangeCheckListAndJobStepNumberOfPreviousItem(data.checkListMasterId, data.checkListGroupId, "LOTOTO", "CheckList"); CheckListLototomaster item = new CheckListLototomaster(); item.CheckListMasterId = data.checkListMasterId; item.CheckListGroupId = data.checkListGroupId; item.CheckListLockStepNumber = stepCount + 1; item.PositionDescription = data.positionDescription; item.IsLockOutRequired = data.isLockOutRequired; item.IsTagOutRequired = data.isTagOutRequired; item.IsTryOutRequired = data.isTryOutRequired; item.Remarks = data.remarks; item.IsActive = true; item.IsDeleted = false; item.IsAdminApproved = true; item.CreatedBy = userId; item.CreatedOn = DateTime.Now; db.CheckListLototomaster.Add(item); db.SaveChanges(); obj.response = ResourceResponse.AddedSucessfully; obj.isStatus = true; } catch (Exception ex) { log.Error(ex); if (ex.InnerException != null) { log.Error(ex.InnerException.ToString()); } obj.response = ResourceResponse.ExceptionMessage; obj.isStatus = false; } } else { try { res.CheckListMasterId = data.checkListMasterId; res.CheckListGroupId = data.checkListGroupId; res.CheckListLockStepNumber = data.checkListLockStepNumber; res.PositionDescription = data.positionDescription; res.IsLockOutRequired = data.isLockOutRequired; res.IsTagOutRequired = data.isTagOutRequired; res.IsTryOutRequired = data.isTryOutRequired; res.Remarks = data.remarks; res.ModifiedBy = userId; res.ModifiedOn = DateTime.Now; db.SaveChanges(); obj.response = ResourceResponse.UpdatedSucessfully; obj.isStatus = true; } catch (Exception ex) { log.Error(ex); if (ex.InnerException != null) { log.Error(ex.InnerException.ToString()); } obj.response = ResourceResponse.ExceptionMessage; obj.isStatus = false; } } } catch (Exception ex) { log.Error(ex); if (ex.InnerException != null) { log.Error(ex.InnerException.ToString()); } obj.response = ResourceResponse.ExceptionMessage; obj.isStatus = false; } return(obj); }
/// <summary> /// Add and Edit Document /// </summary> /// <param name="data"></param> /// <param name="userId"></param> /// <returns></returns> /// //public CommonResponseWithIds AddAndEditCheckListJobOperator(CheckListJobOperatorCustom data, long userId = 0) //{ // CommonResponseWithIds obj = new CommonResponseWithIds(); // try // { // var res = db.CheckListJobWrtoperator.Where(m => m.CheckListJobMasterId == data.checkListJobMasterId && m.CheckListJobGroupId == data.checkListJobGroupId).FirstOrDefault(); // if (res == null) // { // try // { // CheckListJobWrtoperator item = new CheckListJobWrtoperator(); // item.CheckListJobMasterId = Convert.ToInt32(data.checkListJobMasterId); // item.CheckListJobGroupId = data.checkListJobGroupId; // item.OperatorId = userId ; // item.CheckListJobStartTime = DateTime.Now ; // item.CheckListJobIsCompleted = false ; // item.CheckListJobIsPartialCompleted = true ; // item.IsAdminApproved = false ; // item.IsJobRejected = false ; // item.IsJobClosed = false ; // item.IsActive = true; // item.IsDeleted = false; // item.CreatedBy = userId; // item.CreatedOn = DateTime.Now; // db.CheckListJobWrtoperator.Add(item); // db.SaveChanges(); // obj.response = ResourceResponse.AddedSucessfully; // obj.isStatus = true; // obj.id = item.CheckListJobWrtoperatorId; // } // catch (Exception ex) // { // log.Error(ex); if (ex.InnerException != null) { log.Error(ex.InnerException.ToString()); } // obj.response = ResourceResponse.ExceptionMessage; // obj.isStatus = false; // } // } // else // { // try // { // res.OperatorId = userId; // res.IsAdminApproved = false; // res.IsJobClosed = false; // res.IsJobRejected = false; // res.ModifiedBy = userId; // res.ModifiedOn = DateTime.Now; // db.SaveChanges(); // obj.response = ResourceResponse.UpdatedSucessfully; // obj.isStatus = true; // obj.id = res.CheckListJobWrtoperatorId; // } // catch (Exception ex) // { // log.Error(ex); if (ex.InnerException != null) { log.Error(ex.InnerException.ToString()); } // obj.response = ResourceResponse.ExceptionMessage; // obj.isStatus = false; // } // } // } // catch (Exception ex) // { // log.Error(ex); if (ex.InnerException != null) { log.Error(ex.InnerException.ToString()); } // obj.response = ResourceResponse.ExceptionMessage; // obj.isStatus = false; // } // return obj; //} public CommonResponseWithIds AddAndEditCheckListJobOperator(CheckListJobOperatorCustom data, long userId = 0) { CommonResponseWithIds obj = new CommonResponseWithIds(); try { var res = db.CheckListJobWrtoperator.Where(m => m.CheckListJobMasterId == data.checkListJobMasterId && m.CheckListJobGroupId == data.checkListJobGroupId).FirstOrDefault(); if (res == null) { try { CheckListJobWrtoperator item = new CheckListJobWrtoperator(); item.CheckListJobMasterId = Convert.ToInt64(data.checkListJobMasterId); item.CheckListJobGroupId = data.checkListJobGroupId; item.OperatorId = userId; item.CheckListJobStartTime = DateTime.Now; item.CheckListJobIsCompleted = false; item.CheckListJobIsPartialCompleted = true; item.IsAdminApproved = false; item.IsJobRejected = false; item.IsJobClosed = false; item.IsActive = true; item.IsDeleted = false; item.CreatedBy = userId; item.CreatedOn = DateTime.Now; db.CheckListJobWrtoperator.Add(item); db.SaveChanges(); obj.response = ResourceResponse.AddedSucessfully; obj.isStatus = true; obj.id = item.CheckListJobWrtoperatorId; } catch (Exception ex) { log.Error(ex); if (ex.InnerException != null) { log.Error(ex.InnerException.ToString()); } obj.response = ResourceResponse.ExceptionMessage; obj.isStatus = false; } } else { try { res.OperatorId = userId; //if (res.IsAdminApproved == true) //{ // res.IsAdminApproved = true; //} //else //{ // res.IsAdminApproved = false; //} //if (res.IsJobClosed == true) //{ // res.IsJobClosed = true; //} //else //{ // res.IsJobClosed = false; //} if (res.IsJobRejected == true) { res.IsJobRejected = true; } else { res.IsJobRejected = false; } res.IsAdminApproved = false; res.IsJobClosed = false; // res.IsJobRejected = false; res.ModifiedBy = userId; res.ModifiedOn = DateTime.Now; db.SaveChanges(); obj.response = ResourceResponse.UpdatedSucessfully; obj.isStatus = true; obj.id = res.CheckListJobWrtoperatorId; } catch (Exception ex) { log.Error(ex); if (ex.InnerException != null) { log.Error(ex.InnerException.ToString()); } obj.response = ResourceResponse.ExceptionMessage; obj.isStatus = false; } } } catch (Exception ex) { log.Error(ex); if (ex.InnerException != null) { log.Error(ex.InnerException.ToString()); } obj.response = ResourceResponse.ExceptionMessage; obj.isStatus = false; } return(obj); }
/// <summary> /// ChangeCheckListAndJobStepNumberOfPreviousItem /// </summary> /// <param name="checkListMasterId"></param> /// <param name="checkListGroupId"></param> /// <param name="activityType"></param> /// <param name="major"></param> /// <returns></returns> public int ChangeCheckListAndJobStepNumberOfPreviousItem(long?checkListMasterId, long?checkListGroupId, string activityType, string major) { int stepNumber = 0; try { if (major == "CheckList") { switch (activityType) { case "Activity": var checkListActivityMaster = db.CheckListActivityMaster.Where(m => m.CheckListMasterId == checkListMasterId && m.CheckListGroupId == checkListGroupId && m.IsDeleted == false).OrderBy(m => m.CreatedOn).ToList(); int i = 1; foreach (var item in checkListActivityMaster) { item.CheckListStepNumber = i; db.SaveChanges(); i++; } stepNumber = checkListActivityMaster.Count; break; case "Advance": var checkListAdvanceMaster = db.CheckListAdvanceMaster.Where(m => m.CheckListMasterId == checkListMasterId && m.CheckListGroupId == checkListGroupId && m.IsDeleted == false).OrderBy(m => m.CreatedOn).ToList(); int j = 1; foreach (var item in checkListAdvanceMaster) { item.CheckListStepNumber = j; db.SaveChanges(); j++; } stepNumber = checkListAdvanceMaster.Count; break; case "LOTOTO": var checkListLototomaster = db.CheckListLototomaster.Where(m => m.CheckListMasterId == checkListMasterId && m.CheckListGroupId == checkListGroupId && m.IsDeleted == false).OrderBy(m => m.CreatedOn).ToList(); int k = 1; foreach (var item in checkListLototomaster) { item.CheckListLockStepNumber = k; db.SaveChanges(); k++; } stepNumber = checkListLototomaster.Count; break; default: break; } } else { switch (activityType) { case "Activity": var checkListActivityMaster = db.CheckListJobActivityMaster.Where(m => m.CheckListJobMasterId == checkListMasterId && m.CheckListJobGroupId == checkListGroupId && m.IsDeleted == false).OrderBy(m => m.CreatedOn).ToList(); int i = 1; foreach (var item in checkListActivityMaster) { item.CheckListJobStepNumber = i; db.SaveChanges(); i++; } stepNumber = checkListActivityMaster.Count; break; case "Advance": var checkListAdvanceMaster = db.CheckListJobAdvanceMaster.Where(m => m.CheckListJobMasterId == checkListMasterId && m.CheckListJobGroupId == checkListGroupId && m.IsDeleted == false).OrderBy(m => m.CreatedOn).ToList(); int j = 1; foreach (var item in checkListAdvanceMaster) { item.CheckListJobStepNumber = j; db.SaveChanges(); j++; } stepNumber = checkListAdvanceMaster.Count; break; case "LOTOTO": var checkListLototomaster = db.CheckListJobLototomaster.Where(m => m.CheckListJobMasterId == checkListMasterId && m.CheckListJobGroupId == checkListGroupId && m.IsDeleted == false).OrderBy(m => m.CreatedOn).ToList(); int k = 1; foreach (var item in checkListLototomaster) { item.CheckListJobLockStepNumber = k; db.SaveChanges(); k++; } stepNumber = checkListLototomaster.Count; break; default: break; } } } catch (Exception ex) { } return(stepNumber); }
/// <summary> /// Add and Edit Document /// </summary> /// <param name="data"></param> /// <param name="userId"></param> /// <returns></returns> public CommonResponse AddAndEditCheckListJobActivityOperator(CheckListJobActivityOperatorCustom data, long userId = 0) { CommonResponse obj = new CommonResponse(); try { var res = db.CheckListJobActivityOperator.Where(m => m.CheckListJobOperatorId == data.checkListJobOperatorId && m.CheckListJobActivityId == data.checkListJobActivityId).FirstOrDefault(); if (res == null) { try { CheckListJobActivityOperator item = new CheckListJobActivityOperator(); item.CheckListJobOperatorId = data.checkListJobOperatorId; item.OperatorId = userId; item.OperatorScannedBarcodeNumber = data.operatorScannedBarcodeNumber; item.BarcodeAssetId = data.barcodeAssetId; item.OperatorUpoadedDocumentId = data.operatorUpoadedDocumentId; item.OperatorRemark = data.operatorRemark; item.CheckListJobActivityId = data.checkListJobActivityId; item.IsActive = true; item.IsDeleted = false; item.IsJobRejected = false; item.IsAdminApproved = false; item.CreatedBy = userId; item.CreatedOn = DateTime.Now; db.CheckListJobActivityOperator.Add(item); db.SaveChanges(); obj.response = ResourceResponse.AddedSucessfully; obj.isStatus = true; } catch (Exception ex) { log.Error(ex); if (ex.InnerException != null) { log.Error(ex.InnerException.ToString()); } obj.response = ResourceResponse.ExceptionMessage; obj.isStatus = false; } } else { try { res.OperatorId = userId; res.OperatorScannedBarcodeNumber = data.operatorScannedBarcodeNumber; res.BarcodeAssetId = data.barcodeAssetId; res.OperatorUpoadedDocumentId = data.operatorUpoadedDocumentId; res.OperatorRemark = data.operatorRemark; res.CheckListJobActivityId = data.checkListJobActivityId; res.ActivityEndTime = DateTime.Now; res.IsAdminApproved = false; res.IsJobRejected = false; res.JobRejectedReason = ""; res.ModifiedBy = userId; res.ModifiedOn = DateTime.Now; db.SaveChanges(); obj.response = ResourceResponse.UpdatedSucessfully; obj.isStatus = true; } catch (Exception ex) { log.Error(ex); if (ex.InnerException != null) { log.Error(ex.InnerException.ToString()); } obj.response = ResourceResponse.ExceptionMessage; obj.isStatus = false; } } } catch (Exception ex) { log.Error(ex); if (ex.InnerException != null) { log.Error(ex.InnerException.ToString()); } obj.response = ResourceResponse.ExceptionMessage; obj.isStatus = false; } return(obj); }
/// <summary> /// Add and Edit Document /// </summary> /// <param name="data"></param> /// <param name="userId"></param> /// <returns></returns> public CommonResponseWithIds AddAndEditCheckList(CheckListCustom data, long userId) { CommonResponseWithIds obj = new CommonResponseWithIds(); try { var res = db.CheckListMaster.Where(m => m.CheckListName == data.checkListName && m.CheckListVersion == data.checkListVersion && m.IsDeleted == false && m.IsActive == true).FirstOrDefault(); if (res == null) { try { CheckListMaster item = new CheckListMaster(); item.CheckListName = data.checkListName.Trim(); item.CheckListDescription = data.checkListDescription; item.CheckListOwner = data.checkListOwner; item.CheckListVersion = data.checkListVersion; item.CheckListCategoryId = data.checkListCategoryId; item.CheckListTypeId = data.checkListTypeId; item.CheckListGroup = data.checkListGroup; //Mani item.EstimatedEndTime = data.estimatedTime; //Mani item.IsActive = true; item.IsDeleted = false; item.CreatedBy = userId; item.CreatedOn = DateTime.Now; db.CheckListMaster.Add(item); db.SaveChanges(); obj.response = ResourceResponse.AddedSucessfully; obj.isStatus = true; obj.id = item.CheckListId; } catch (Exception ex) { log.Error(ex); if (ex.InnerException != null) { log.Error(ex.InnerException.ToString()); } obj.response = ResourceResponse.ExceptionMessage; obj.isStatus = false; } } else { try { res.CheckListName = data.checkListName; res.CheckListDescription = data.checkListDescription; res.CheckListOwner = data.checkListOwner; res.CheckListVersion = data.checkListVersion; res.CheckListCategoryId = data.checkListCategoryId; res.CheckListTypeId = data.checkListTypeId; res.CheckListGroup = data.checkListGroup; res.EstimatedEndTime = data.estimatedTime; res.ModifiedBy = userId; res.ModifiedOn = DateTime.Now; db.SaveChanges(); obj.response = ResourceResponse.UpdatedSucessfully; obj.isStatus = true; obj.id = data.checkListId; } catch (Exception ex) { log.Error(ex); if (ex.InnerException != null) { log.Error(ex.InnerException.ToString()); } obj.response = ResourceResponse.ExceptionMessage; obj.isStatus = false; } } } catch (Exception ex) { log.Error(ex); if (ex.InnerException != null) { log.Error(ex.InnerException.ToString()); } obj.response = ResourceResponse.ExceptionMessage; obj.isStatus = false; } return(obj); }
/// <summary> /// Add and Edit Document /// </summary> /// <param name="data"></param> /// <param name="userId"></param> /// <returns></returns> public CommonResponseWithIds AddAndEditAsset(AssetCustom data, long userId = 0) { CommonResponseWithIds obj = new CommonResponseWithIds(); try { var res = db.AssetMaster.Where(m => m.AssetId == data.assetId).FirstOrDefault(); if (res == null) { try { AssetMaster item = new AssetMaster(); item.AssetName = data.assetName; item.AssetDescription = data.assetDescription; item.AssetDocumentUploadedId = data.assetDocumentUploadedId; item.BarcodeAllocatedNumber = data.barcodeAllocatedNumber; item.LineNumber = data.lineNumber; item.IsActive = true; item.IsDeleted = false; item.CreatedBy = userId; item.CreatedOn = DateTime.Now; db.AssetMaster.Add(item); db.SaveChanges(); obj.response = ResourceResponse.AddedSucessfully; obj.isStatus = true; obj.id = item.AssetId; } catch (Exception ex) { log.Error(ex); if (ex.InnerException != null) { log.Error(ex.InnerException.ToString()); } obj.response = ResourceResponse.ExceptionMessage; obj.isStatus = false; } } else { try { res.AssetName = data.assetName; res.AssetDescription = data.assetDescription; res.AssetDocumentUploadedId = data.assetDocumentUploadedId; res.BarcodeAllocatedNumber = data.barcodeAllocatedNumber; res.LineNumber = data.lineNumber; res.ModifiedBy = userId; res.ModifiedOn = DateTime.Now; db.SaveChanges(); obj.id = res.AssetId; obj.response = ResourceResponse.UpdatedSucessfully; obj.isStatus = true; } catch (Exception ex) { log.Error(ex); if (ex.InnerException != null) { log.Error(ex.InnerException.ToString()); } obj.response = ResourceResponse.ExceptionMessage; obj.isStatus = false; } } } catch (Exception ex) { log.Error(ex); if (ex.InnerException != null) { log.Error(ex.InnerException.ToString()); } obj.response = ResourceResponse.ExceptionMessage; obj.isStatus = false; } return(obj); }
/// <summary> /// Add And Edit Document Uploader /// </summary> /// <param name="documentDetails"></param> /// <param name="userId"></param> /// <returns></returns> public CommonResponseWithIdsDoc AddAndEditDocumentUploader(DocumentUplodedMasterCustom documentDetails, long userId) { CommonResponseWithIdsDoc response = new CommonResponseWithIdsDoc(); string fileName = ""; if (documentDetails.Image != null) { try { string extensionFile = documentDetails.Image.FileName; string[] fileArray = extensionFile.Split('.'); try { extensionFile = fileArray[1]; } catch { extensionFile = "jpeg"; } fileName = Guid.NewGuid().ToString() + "." + extensionFile; #region save file var path = Path.Combine(appSettings.ImageUrlSave, fileName); bool exists = System.IO.File.Exists(path); // Getting Image var image = documentDetails.Image; try { if (!exists) { if (image.Length > 0) { using (var fileStream = new FileStream(path, FileMode.Create)) { image.CopyTo(fileStream); } } } } catch (Exception ex) { log.Error(ex); if (ex.InnerException != null) { log.Error(ex.InnerException.ToString()); } } #endregion #region save file details in DB var dbItem = db.DocumentUplodedMaster.Where(m => m.DocumentUploaderId == documentDetails.documentUploaderId && m.IsDeleted == false && m.IsActive == true).FirstOrDefault(); if (dbItem == null) { #region insert item into DB DocumentUplodedMaster documentUplodedMaster = new DocumentUplodedMaster(); documentUplodedMaster.DocumentName = documentDetails.Image.FileName; documentUplodedMaster.DocumentMasterId = documentDetails.documentMasterId; documentUplodedMaster.FileName = fileName; documentUplodedMaster.FilePath = path; documentUplodedMaster.CreatedOn = DateTime.Now; documentUplodedMaster.CreatedBy = 0; documentUplodedMaster.IsDeleted = false; documentUplodedMaster.IsActive = true; documentUplodedMaster.DocumentUploadedFor = documentDetails.DocumentUploadedFor; db.DocumentUplodedMaster.Add(documentUplodedMaster); db.SaveChanges(); response.id = documentUplodedMaster.DocumentUploaderId; var doc = appSettings.ImageUrl + (from wfd in db.DocumentUplodedMaster where wfd.IsDeleted == false && wfd.DocumentUploaderId == documentUplodedMaster.DocumentUploaderId select wfd.FileName).FirstOrDefault(); response.url = doc; #endregion } else { #region delete old files try { var deleteFileName = Path.Combine(appSettings.ImageUrlSave, dbItem.FileName); if (deleteFileName != null || deleteFileName != string.Empty) { if ((System.IO.File.Exists(deleteFileName))) { System.IO.File.Delete(deleteFileName); } } } catch (Exception ex) { } #endregion #region update into DB dbItem.FileName = fileName; dbItem.DocumentName = documentDetails.Image.FileName; dbItem.DocumentUploadedFor = documentDetails.DocumentUploadedFor; dbItem.FilePath = path; dbItem.ModifiedOn = DateTime.Now; dbItem.ModifiedBy = 0; db.SaveChanges(); response.id = documentDetails.documentUploaderId; var doc = appSettings.ImageUrl + (from wfd in db.DocumentUplodedMaster where wfd.IsDeleted == false && wfd.DocumentUploaderId == dbItem.DocumentUploaderId select wfd.FileName).FirstOrDefault(); response.url = doc; #endregion } #endregion } catch (Exception ex) { log.Error(ex); if (ex.InnerException != null) { log.Error(ex.InnerException.ToString()); } response.isStatus = false; response.response = ResourceResponse.ExceptionMessage; } response.isStatus = true; response.response = ResourceResponse.FileUploaderSuccess; } else { response.isStatus = false; response.response = ResourceResponse.FileUploaderFailure; } return(response); }
/// <summary> /// Add and Edit Document /// </summary> /// <param name="data"></param> /// <param name="userId"></param> /// <returns></returns> public CommonResponse AddAndEditTargetOverAll(TargetOverAllCustom data, long userId = 0) { CommonResponse obj = new CommonResponse(); try { DateTime st = DateTime.Now; DateTime et = DateTime.Now; #region ST and ET try { st = Convert.ToDateTime(data.targetStartTime); } catch (Exception ex) { } try { et = Convert.ToDateTime(data.targetEndTime); } catch (Exception ex) { } #endregion var res = db.TargetOverall.Where(m => m.TargetId == data.targetId).FirstOrDefault(); if (res == null) { try { TargetOverall item = new TargetOverall(); item.TargetYearName = data.targetYearName; item.TargetValue = data.targetValue; item.TargetStartTime = st; item.TargetEndTime = et; item.IsActive = true; item.IsDeleted = false; db.TargetOverall.Add(item); db.SaveChanges(); obj.response = ResourceResponse.AddedSucessfully; obj.isStatus = true; } catch (Exception ex) { log.Error(ex); if (ex.InnerException != null) { log.Error(ex.InnerException.ToString()); } obj.response = ResourceResponse.ExceptionMessage; obj.isStatus = false; } } else { try { res.TargetYearName = data.targetYearName; res.TargetValue = data.targetValue; res.TargetStartTime = st; res.TargetEndTime = et; db.SaveChanges(); obj.response = ResourceResponse.UpdatedSucessfully; obj.isStatus = true; } catch (Exception ex) { log.Error(ex); if (ex.InnerException != null) { log.Error(ex.InnerException.ToString()); } obj.response = ResourceResponse.ExceptionMessage; obj.isStatus = false; } } } catch (Exception ex) { log.Error(ex); if (ex.InnerException != null) { log.Error(ex.InnerException.ToString()); } obj.response = ResourceResponse.ExceptionMessage; obj.isStatus = false; } return(obj); }
/// <summary> /// Add and Edit Document /// </summary> /// <param name="data"></param> /// <param name="userId"></param> /// <returns></returns> public CommonResponse AddAndEditCheckListJobLOTOTOOperator(CheckListJobLOTOTOOperatorCustom data, long userId = 0) { CommonResponse obj = new CommonResponse(); try { var checklWRT = db.CheckListJobWrtoperator.Where(m => m.CheckListJobWrtoperatorId == data.checkListJobOperatorId).FirstOrDefault(); var res = db.CheckListJobLototooperator.Where(m => m.checkListJobId == checklWRT.CheckListJobMasterId && m.checkListJobGroupId == checklWRT.CheckListJobGroupId && m.CheckListJobLototoid == data.checkListJobLOTOTOId).FirstOrDefault(); if (res == null) { try { CheckListJobLototooperator item = new CheckListJobLototooperator(); item.CheckListJobOperatorId = data.checkListJobOperatorId; item.OperatorId = userId; item.OverAllRemark = data.overAllRemark; // item.LockOutDoneByOperator = data.lockOutDoneByOperator; // item.LockOutRemark = data.lockOutRemark; // item.TagOutDoneByOperator = data.tagOutDoneByOperator; // item.TagOutRemark = data.tagOutRemark; item.TryOutDoneByOperator = data.tryOutDoneByOperator; item.CheckListJobLototoid = data.checkListJobLOTOTOId; item.TryOutRemark = data.tryOutRemark; item.IsJobRejected = false; item.IsActive = true; item.IsDeleted = false; item.IsAdminApproved = false; item.CreatedBy = userId; item.CreatedOn = DateTime.Now; db.CheckListJobLototooperator.Add(item); db.SaveChanges(); obj.response = ResourceResponse.AddedSucessfully; obj.isStatus = true; } catch (Exception ex) { log.Error(ex); if (ex.InnerException != null) { log.Error(ex.InnerException.ToString()); } obj.response = ResourceResponse.ExceptionMessage; obj.isStatus = false; } } else { try { res.CheckListJobOperatorId = data.checkListJobOperatorId; res.OperatorId = userId; res.OverAllRemark = data.overAllRemark; //res.LockOutDoneByOperator = data.lockOutDoneByOperator; //res.LockOutRemark = data.lockOutRemark; //res.TagOutDoneByOperator = data.tagOutDoneByOperator; //res.TagOutRemark = data.tagOutRemark; res.TryOutDoneByOperator = data.tryOutDoneByOperator; res.CheckListJobLototoid = data.checkListJobLOTOTOId; res.TryOutRemark = data.tryOutRemark; res.IsAdminApproved = false; res.IsJobRejected = false; res.JobRejectedReason = ""; res.ModifiedBy = userId; res.ModifiedOn = DateTime.Now; db.SaveChanges(); obj.response = ResourceResponse.UpdatedSucessfully; obj.isStatus = true; } catch (Exception ex) { log.Error(ex); if (ex.InnerException != null) { log.Error(ex.InnerException.ToString()); } obj.response = ResourceResponse.ExceptionMessage; obj.isStatus = false; } } } catch (Exception ex) { log.Error(ex); if (ex.InnerException != null) { log.Error(ex.InnerException.ToString()); } obj.response = ResourceResponse.ExceptionMessage; obj.isStatus = false; } return(obj); }
/// <summary> /// Add and Edit HelpContent /// </summary> /// <param name="data"></param> /// <param name="userId"></param> /// <returns></returns> public CommonResponse AddAndEditHelpContent(HelpContentCustom data, long userId = 0) { CommonResponse obj = new CommonResponse(); try { var res = db.HelpContentMaster.Where(m => m.HelpContentId == data.helpContentId).FirstOrDefault(); if (res == null) { try { HelpContentMaster item = new HelpContentMaster(); item.HelpContentShortName = data.helpContentShortName; item.HelpContentDescription = data.helpContentDescription; item.InstructionLink = data.instructionLink; item.VisbleToRoleId = data.visbleToRoleId; item.IsActive = true; item.IsDeleted = false; item.CreatedBy = userId; item.CreatedOn = DateTime.Now; db.HelpContentMaster.Add(item); db.SaveChanges(); obj.response = ResourceResponse.AddedSucessfully; obj.isStatus = true; } catch (Exception ex) { log.Error(ex); if (ex.InnerException != null) { log.Error(ex.InnerException.ToString()); } obj.response = ResourceResponse.ExceptionMessage; obj.isStatus = false; } } else { try { res.HelpContentShortName = data.helpContentShortName; res.HelpContentDescription = data.helpContentDescription; res.InstructionLink = data.instructionLink; res.VisbleToRoleId = data.visbleToRoleId; res.ModifiedBy = userId; res.ModifiedOn = DateTime.Now; db.SaveChanges(); obj.response = ResourceResponse.UpdatedSucessfully; obj.isStatus = true; } catch (Exception ex) { log.Error(ex); if (ex.InnerException != null) { log.Error(ex.InnerException.ToString()); } obj.response = ResourceResponse.ExceptionMessage; obj.isStatus = false; } } } catch (Exception ex) { log.Error(ex); if (ex.InnerException != null) { log.Error(ex.InnerException.ToString()); } obj.response = ResourceResponse.ExceptionMessage; obj.isStatus = false; } return(obj); }