public void Edit(CompanyModel companyModel) { try { Company company = dbContext.Companies.Where(x => x.Id == companyModel.Id).FirstOrDefault(); if (company == null) { base.HandleError(companyModel, CommonLayer.LookUps.ErrorType.Critical, null, Resources.NotFound); return; } if (Validate(companyModel)) { return; } CompanyMapper.Map(dbContext, companyModel, company); base.SaveChanges(); companyModel.AddSuccess(Resources.CompanyUpdatedSuccessfully, LookUps.SuccessType.Full); } catch (Exception ex) { base.HandleError(companyModel, CommonLayer.LookUps.ErrorType.Exception, ex); base.UndoUpdates(); } }
public GenericListModel <CompanyModel> GetSearchCompaniesList(DataTableSearchParameters <Nullable <bool> > dataTableSearchParameters) { GenericListModel <CompanyModel> baseListModel = new GenericListModel <CompanyModel>(); try { //if (!base.CompanyHasPermision(baseListModel)) // return baseListModel; IQueryable <Company> companies = prepareSearch(dataTableSearchParameters.search.value); foreach (JQDTColumnOrder order in dataTableSearchParameters.order) { switch (order.column) { case 0: if (order.dir == JQDTColumnOrderDirection.asc) { companies = companies.OrderBy(c => c.Name); } else { companies = companies.OrderByDescending(c => c.Name); } break; case 1: if (order.dir == JQDTColumnOrderDirection.asc) { companies = companies.OrderBy(c => c.Notes); } else { companies = companies.OrderByDescending(c => c.Notes); } break; } } baseListModel.Total = companies.Count(); companies = companies.Skip(dataTableSearchParameters.start); if (dataTableSearchParameters.length != -1) { companies = companies.Take(dataTableSearchParameters.length); } CompanyMapper.Map(dbContext, companies.ToList(), baseListModel.List); } catch (Exception ex) { base.HandleError(baseListModel, CommonLayer.LookUps.ErrorType.Critical, ex); } return(baseListModel); }
public void GetCompanyModel(CompanyModel companyModel) { try { Company company = dbContext.Companies.Where(x => x.Id == companyModel.Id).FirstOrDefault(); if (company == null) { base.HandleError(companyModel, CommonLayer.LookUps.ErrorType.Critical, null, Resources.NotFound); } else { CompanyMapper.Map(dbContext, company, companyModel); } } catch (Exception ex) { base.HandleError(companyModel, CommonLayer.LookUps.ErrorType.Critical, ex); } }
public void Create(CompanyModel companyModel) { try { if (Validate(companyModel)) { return; } using (var transaction = dbContext.Database.BeginTransaction()) { try { Company company = new Company(); CompanyMapper.Map(dbContext, companyModel, company); company.Id = Guid.NewGuid().ToString(); dbContext.Companies.Add(company); base.SaveChanges(); transaction.Commit(); } catch (Exception ex) { transaction.Rollback(); throw ex; } companyModel.AddSuccess(Resources.CompanyAddedSuccessfully, LookUps.SuccessType.Full); } } catch (Exception ex) { base.HandleError(companyModel, CommonLayer.LookUps.ErrorType.Exception, ex); base.UndoUpdates(); } }
public GenericListModel <CompanyModel> GetCompanies(Select2Parameters <bool> select2Parameters) { GenericListModel <CompanyModel> baseListModel = new GenericListModel <CompanyModel>(); try { IQueryable <Company> companies = prepareSearch(select2Parameters.text); companies = companies.OrderBy(x => x.CreatedAt); baseListModel.Total = companies.Count(); companies = companies.Skip(select2Parameters.start); companies = companies.Take(select2Parameters.pageSize); CompanyMapper.Map(dbContext, companies.ToList(), baseListModel.List); } catch (Exception ex) { base.HandleError(baseListModel, CommonLayer.LookUps.ErrorType.Critical, ex); } return(baseListModel); }