public BaseResponse <SystemConfig> AddSystemConfig(SystemConfig model) { var response = new BaseResponse <SystemConfig>(); var errors = Validate <SystemConfig>(model, new SystemConfigValidator()); if (errors.Count() > 0) { BaseResponse <SystemConfig> errResponse = new BaseResponse <SystemConfig>(model, errors); errResponse.IsSuccess = false; return(errResponse); } try { model.CreatedOn = DateTime.Now; response.Value = _systemConfigRepository.Add(model); try { _applicationLoggingRepository.Log("EVENT", "CREATE", "SystemConfig", response.Value.Id.ToString(), "", "", model, "", System.Web.HttpContext.Current.Request.UserHostAddress, model.CreatedBy); } catch { } if (model.IsSystemConfig == false) { DepartmentQuery query = new DepartmentQuery(); query.Keyword = ""; query.ParentId = 0; query.Active = true; List <SPGetDepartment_Result> arrDepartments = _departmentRepository.Filter(query).Where(n => n.ParentId != 0).ToList(); SystemConfigDepartment config; if (arrDepartments.Count() > 0) { foreach (var item in arrDepartments) { config = new SystemConfigDepartment(); config.ConfigId = response.Value.Id; config.Value = model.Value; config.Description = model.Description; config.DepartmentId = item.Id; config.CreatedBy = model.CreatedBy; config.CreatedOn = model.CreatedOn; config.EditedBy = model.EditedBy; config.EditedOn = model.EditedOn; _systemConfigDepartmentRepository.Add(config); try { _applicationLoggingRepository.Log("EVENT", "CREATE", "SystemConfigDepartment", response.Value.Id.ToString(), "", "", config, "", System.Web.HttpContext.Current.Request.UserHostAddress, model.CreatedBy); } catch { } } } } } catch (Exception ex) { response.IsSuccess = false; response.Message = "Error: " + ex.Message + " StackTrace: " + ex.StackTrace; } return(response); }
public List <SPBuildOrganizationTree_Result> BuildOrganizationTree(DepartmentQuery query) { List <SPBuildOrganizationTree_Result> result = new List <SPBuildOrganizationTree_Result>(); result = _entities.SPBuildOrganizationTree(query.DepartmentId, query.Type, query.Action).ToList(); return(result); }
private void Department_Load(object sender, EventArgs e) { if (!IsEdit) { var departmentId = Guid.NewGuid().ToString(); while (new DepartmentQuery().GetDepartment(departmentId) != null) { departmentId = Guid.NewGuid().ToString(); } Txt_DepartmentID.Text = departmentId; } else { var items = new DepartmentQuery().GetDepartment(DepartmentID); if (items != null) { Txt_DepartmentID.Text = items.ObjectID; Txt_DepartmentName.Text = items.DepartmentName; if (items.IsEnable == "Y") { Rbtn_Yes.Checked = true; } else { Rbtn_No.Checked = true; } } } }
public List <SPGetDepartment_Result> Filter(DepartmentQuery query) { var keyword = string.IsNullOrEmpty(query.Keyword) != true ? query.Keyword : ""; List <SPGetDepartment_Result> result = new List <SPGetDepartment_Result>(); result = _entities.SPGetDepartment(Util.DetecVowel(keyword), query.ParentId, query.Active).ToList(); return(result); }
public List <SelectView> Sub(string id) { DepartmentQuery query = new DepartmentQuery() { ParentId = id }; return(_Service.Select(query)); }
public BaseListResponse <SPGetDepartment_Result> GetSubDepartmentNonSeft(DepartmentQuery query) { var response = new BaseListResponse <SPGetDepartment_Result>(); try { response.Data = _departmentRepository.Filter(query).Where(n => n.Id != query.ParentId).OrderBy(n => n.Order).ToList(); } catch (Exception ex) { response.Message = "Error: " + ex.Message + " StackTrace: " + ex.StackTrace; } return(response); }
public BaseListResponse <SPGetDepartment_Result> FilterDepartment(DepartmentQuery query) { var response = new BaseListResponse <SPGetDepartment_Result>(); try { response.Data = _departmentRepository.Filter(query); } catch (Exception ex) { response.Message = "Error: " + ex.Message + " StackTrace: " + ex.StackTrace; } return(response); }
public ActionResult GetDepartmentAuditorList() { try { var queryParams = new NameValueCollection(); if (!ParamHelper.CheckParaQ(ref queryParams)) { return(Json(new ResponseEntity <int>(RegularFunction.RegularSqlRegexText), JsonRequestBehavior.AllowGet)); } var query = new DepartmentQuery(queryParams); var sqlCondition = new StringBuilder(); sqlCondition.Append("ISNULL(IsDelete,0)!=1"); if (!string.IsNullOrEmpty(query.Name)) { sqlCondition.Append($" and Name like '%{query.Name}%'"); } PageRequest preq = new PageRequest { TableName = " [Department] ", Where = sqlCondition.ToString(), Order = " Id DESC ", IsSelect = true, IsReturnRecord = true, PageSize = query.PageSize, PageIndex = query.PageIndex, FieldStr = "*" }; var result = new DepartmentBLL().GetView_DepartmentAuditorByPage(preq); var response = new ResponseEntity <object>(true, string.Empty, new DataGridResultEntity <View_DepartmentAuditor> { TotalRecords = preq.Out_AllRecordCount, DisplayRecords = preq.Out_PageCount, ResultData = result }); return(Json(response, JsonRequestBehavior.AllowGet)); } catch (Exception ex) { return(Json(new ResponseEntity <object>(-999, string.Empty, ""), JsonRequestBehavior.AllowGet)); } }
public List <SelectView> MySub() { if (string.IsNullOrWhiteSpace(LogonInfo.DepartmentId)) { ApiException.ThrowBadRequest("您需要先有所属部门才可执行此操作"); } DepartmentQuery query = new DepartmentQuery() { ParentId = LogonInfo.DepartmentId }; List <SelectView> subList = _Service.Select(query); return(subList); }
public static DepartmentFilter CreateFromDepartmentQuery(DepartmentQuery query, DepartmentFilter existedFilter = null) { var filter = existedFilter ?? new DepartmentFilter(); switch (query.Field) { case DepartmentQueryFields.Code: filter.Code = query.Value; break; case DepartmentQueryFields.Name: filter.Name = query.Value; break; default: throw new ArgumentOutOfRangeException(); } return(filter); }
private void User_Load(object sender, EventArgs e) { var unitItem = new DepartmentQuery().GetDepartments(); //Com_DepartmentID.Items.Clear(); Com_DepartmentID.DataSource = unitItem; Com_DepartmentID.ValueMember = "ObjectID"; Com_DepartmentID.DisplayMember = "DepartmentName"; if (!IsEdit) { var userId = Guid.NewGuid().ToString(); while (new DepartmentQuery().GetDepartment(userId) != null) { userId = Guid.NewGuid().ToString(); } Txt_UserID.Text = userId; } else { var items = new UserQuery().GetUser(UserID); if (items != null) { Txt_UserID.Text = items.ObjectID; Txt_UserName.Text = items.UserName; Com_DepartmentID.SelectedValue = items.UserDepartmentID; if (items.IsEnable == "Y") { Rbtn_Yes.Checked = true; } else { Rbtn_No.Checked = true; } } } }
/// <summary> /// Test Find using the Query class /// </summary> private void Step_30_TestFindByQuery_Generated() { using (TransactionManager tm = CreateTransaction()) { //Insert Mock Instance Department mock = CreateMockInstance(tm); bool result = DataRepository.DepartmentProvider.Insert(tm, mock); Assert.IsTrue(result, "Could Not Test FindByQuery, Insert Failed"); DepartmentQuery query = new DepartmentQuery(); query.AppendEquals(DepartmentColumn.DepartmentId, mock.DepartmentId.ToString()); query.AppendEquals(DepartmentColumn.Name, mock.Name.ToString()); query.AppendEquals(DepartmentColumn.GroupName, mock.GroupName.ToString()); query.AppendEquals(DepartmentColumn.ModifiedDate, mock.ModifiedDate.ToString()); TList <Department> results = DataRepository.DepartmentProvider.Find(tm, query); Assert.IsTrue(results.Count == 1, "Find is not working correctly. Failed to find the mock instance"); } }
public BaseResponse DeleteLogicalDepartment(int id) { BaseResponse response = new BaseResponse(); Department model = _departmentRepository.GetById(id); try { DepartmentQuery query = new DepartmentQuery(); query.Keyword = ""; query.Active = null; query.ParentId = id; BaseListResponse <SPGetDepartment_Result> lstChild = GetSubDepartmentNonSeft(query); var lstStaffs = _staffRepository.SearchStaffs(id, 1, "", null); if (lstChild.Data.Count() > 0) { response.IsSuccess = false; response.Message = "Tồn tại đơn vị con. Xóa không thành công"; } else if (lstStaffs.Count() > 0) { response.IsSuccess = false; response.Message = "Tồn tại cán bộ thuộc đơn vị. Xóa không thành công"; } else { model.EditedOn = DateTime.Now; model.Deleted = true; _departmentRepository.Edit(model); _applicationLoggingRepository.Log("EVENT", "DELETE", "Department", model.Id.ToString(), "", "", model, "", HttpContext.Current.Request.UserHostAddress, model.CreatedBy); } } catch (Exception ex) { response.Message = ex.Message; response.IsSuccess = false; } return(response); }
public BaseResponse <SystemConfig> UpdateSystemConfig(SystemConfig model) { BaseResponse <SystemConfig> response = new BaseResponse <SystemConfig>(); var errors = Validate <SystemConfig>(model, new SystemConfigValidator()); if (errors.Count() > 0) { BaseResponse <SystemConfig> errResponse = new BaseResponse <SystemConfig>(model, errors); errResponse.IsSuccess = false; return(errResponse); } try { var config = _systemConfigRepository.GetById(model.Id); if (config.Title != model.Title) { IEnumerable <SystemConfig> listSystemConfig = _systemConfigRepository.FindBy(x => x.Value.ToLower() == model.Value.ToLower() && x.Deleted == false); if (listSystemConfig.Count() > 0) { response.IsSuccess = false; response.Message = "Cấu hình hệ thống đã tồn tại."; } else { model.EditedOn = DateTime.Now; response.Value = _systemConfigRepository.Update(config, model); } } else { model.EditedOn = DateTime.Now; response.Value = _systemConfigRepository.Update(config, model); try { _applicationLoggingRepository.Log("EVENT", "UPDATE", "SystemConfig", model.Id.ToString(), "", "", model, "", System.Web.HttpContext.Current.Request.UserHostAddress, model.CreatedBy); } catch { } } //nếu biến cấu hình cũ là có isSystemConfig=false bây giờ =true thì phải thêm các tham số HT đơn vị. if (config.IsSystemConfig == false && model.IsSystemConfig == true) { IEnumerable <SystemConfigDepartment> lstConfigDepartment = _systemConfigDepartmentRepository.FindBy(n => n.ConfigId == model.Id); if (lstConfigDepartment.Count() > 0) { _systemConfigDepartmentRepository.DeleteMulti(x => x.ConfigId == model.Id); } } else if (config.IsSystemConfig == true && model.IsSystemConfig == false) { DepartmentQuery query = new DepartmentQuery(); query.Keyword = ""; query.ParentId = 0; query.Active = true; List <SPGetDepartment_Result> arrDepartments = _departmentRepository.Filter(query).Where(n => n.ParentId != 0).ToList(); SystemConfigDepartment configSub; if (arrDepartments.Count() > 0) { foreach (var item in arrDepartments) { configSub = new SystemConfigDepartment(); configSub.ConfigId = response.Value.Id; configSub.Value = model.Value; configSub.Description = model.Description; configSub.DepartmentId = item.Id; configSub.CreatedBy = model.CreatedBy; configSub.CreatedOn = model.CreatedOn; configSub.EditedBy = model.EditedBy; configSub.EditedOn = model.EditedOn; _systemConfigDepartmentRepository.Add(configSub); try { _applicationLoggingRepository.Log("EVENT", "CREATE", "SystemConfigDepartment", response.Value.Id.ToString(), "", "", configSub, "", System.Web.HttpContext.Current.Request.UserHostAddress, model.CreatedBy); } catch { } } } } } catch (Exception ex) { response.IsSuccess = false; response.Message = "Error: " + ex.Message + " StackTrace: " + ex.StackTrace; } return(response); }
public BaseListResponse <SPBuildOrganizationTree_Result> BuildOrganizationTree([FromUri] DepartmentQuery query) { return(organizationService.BuildOrganizationTree(query)); }
public BaseListResponse <SPGetDepartment_Result> Search([FromUri] DepartmentQuery query) { return(organizationService.FilterDepartment(query)); }
public BaseListResponse <SPGetDepartment_Result> GetSubDepartmentNonSeft([FromUri] DepartmentQuery query) { return(organizationService.GetSubDepartmentNonSeft(query)); }
public BaseListResponse <SPBuildOrganizationTree_Result> BuildOrganizationTree(DepartmentQuery query) { var response = new BaseListResponse <SPBuildOrganizationTree_Result>(); try { response.Data = _departmentRepository.BuildOrganizationTree(query); } catch (Exception ex) { response.Message = "Error: " + ex.Message + " StackTrace: " + ex.StackTrace; } return(response); }
public async Task <QueryResult <DepartmentViewModel> > GetDepartmentList(DepartmentQuery queryObj) { var result = new QueryResult <DepartmentViewModel>(); var user = await _userRepo.GetUser(_userRepo.GetLoggedInUserId()); var query = (from d in _context.OrganizationDepartments //join og in _context.Organizations // on d.OrganizationId equals og.Id into OrgDepts ////do left join //from od in OrgDepts.DefaultIfEmpty() select new { Id = d.Id, Code = d.Code, Name = d.Name, Description = d.Description, OrganizationId = d.OrganizationId, Organization = d.Organization, Email1 = d.Email1, Email2 = d.Email2, Phone1 = d.Phone1, Phone2 = d.Phone2, UseSsl = d.UseSsl, HostName = d.HostName, Port = d.Port, MaxImageFileSize = d.MaxImageFileSize, AcceptedImageFileTypes = d.AcceptedImageFileTypes, MaxVideoFileSize = d.MaxVideoFileSize, AcceptedVideoFileTypes = d.AcceptedVideoFileTypes, SmsServiceProvider = d.SmsServiceProvider, EmailSenderName = d.EmailSenderName, EmailSendersEmail = d.EmailSendersEmail, EmailSenderPassword = d.EmailSenderPassword, EmailRecipientAddresses = d.EmailRecipientAddresses, SendSMS = d.SendSMS, SMSRecipientNumbers = d.SMSRecipientNumbers, SMSSenderName = d.SMSSenderName, ActivateEmailSenderSettings = d.ActivateEmailSenderSettings, ActivateFileSettings = d.ActivateFileSettings, Deleted = d.Deleted //DateCreated = d.DateCreated, //CreatedByUserId = inc.CreatedByUserId, //DateEdited = inc.DateEdited, //EditedByUserId = inc.EditedByUserId, }) .Where(x => user.UserName != "Admin" ? x.OrganizationId == user.OrganizationId && x.Deleted != true : x.Deleted != true) .ToList().Select((s, index) => new DepartmentViewModel() { SerialNumber = index + 1, Id = s.Id, Code = s.Code, Name = s.Name, Description = s.Description, OrganizationId = s.OrganizationId, Email1 = s.Email1, Email2 = s.Email2, Phone1 = s.Phone1, Phone2 = s.Phone2, UseSsl = s.UseSsl, HostName = s.HostName, Port = s.Port, MaxImageFileSize = s.MaxImageFileSize, AcceptedImageFileTypes = s.AcceptedImageFileTypes, MaxVideoFileSize = s.MaxVideoFileSize, AcceptedVideoFileTypes = s.AcceptedVideoFileTypes, SmsServiceProvider = s.SmsServiceProvider, EmailSenderName = s.EmailSenderName, EmailSendersEmail = s.EmailSendersEmail, EmailSenderPassword = s.EmailSenderPassword, EmailRecipientAddresses = s.EmailRecipientAddresses, SendSMS = s.SendSMS, SMSRecipientNumbers = s.SMSRecipientNumbers, SMSSenderName = s.SMSSenderName, ActivateEmailSenderSettings = s.ActivateEmailSenderSettings, ActivateFileSettings = s.ActivateFileSettings }) .AsQueryable(); if (!string.IsNullOrEmpty(queryObj.Name)) { query = query.Where(v => v.Code.Contains(queryObj.Code) | v.Name.Contains(queryObj.Name) | v.Description.Contains(queryObj.Description)); } //string key of the dictionary must be equal the column title in the ui. Value of the dictionary must be a valid column in db/query var columnsMap = new Dictionary <string, Expression <Func <DepartmentViewModel, object> > >() { ["Code"] = v => v.Code, ["Name"] = v => v.Name, ["Descriotion"] = v => v.Description }; query = query.ApplyOrdering(queryObj, columnsMap); result.TotalItems = query.Count(); // query = query.ApplyPaging(queryObj); result.Items = query.ToList(); return(result); }
/// <summary> /// 查询 /// </summary> /// <param name="query"></param> /// <returns></returns> public List <Department> Query(DepartmentQuery query) { return(_service.Query(query)); }
public PagedResult <DepartmentView> SearchPage([FromBody] DepartmentQuery queryInfo) { return(_Service.FilterPage(queryInfo)); }
public async Task <IActionResult> Page(DepartmentQuery departmentQuery) { return(Success(await _departmentService.PageAsync(departmentQuery))); }
public async Task <IActionResult> Get(DepartmentQuery departmentQuery) { return(Success(await _departmentService.RetrieveAsync(departmentQuery))); }
public List <DepartmentView> SearchFilter([FromBody] DepartmentQuery queryInfo) { return(_Service.Filter(queryInfo)); }
public List <SelectView> Select() { DepartmentQuery query = new DepartmentQuery(); return(_Service.Select(query)); }