public ViewResult EditAuthor(int id)
{
ViewBag.Title = "Library :: Редакирование автора";
ViewBag.Caption = "Редактирование автора";
return(View("AuthorForm", aRepo.GetOne(id)));
}
public override bool ValidateUser(string userName, string password)
{
var query = _queryFactory.createFindValidatedUserByUsernameQuery(userName, "myApp");
var user = _repository.GetOne <User>(query);
return(false);
}
public ViewResult EditPublisher(int id)
{
ViewBag.Title = "Library :: Редакирование издателя";
ViewBag.Caption = "Редактирование издателя";
return(View("PublisherForm", pRepo.GetOne(id)));
}
/// <summary>
///
/// </summary>
/// <param name="customerLedger"></param>
public void Add(CustomerLedger customerLedger)
{
try
{
var identity = (LoginIdentity)Thread.CurrentPrincipal.Identity;
if (string.IsNullOrEmpty(customerLedger.CompanyId))
{
customerLedger.CompanyId = identity.CompanyId;
}
if (string.IsNullOrEmpty(customerLedger.BranchId))
{
customerLedger.BranchId = identity.BranchId;
}
customerLedger.Id = GenerateAutoId(customerLedger.CompanyId, customerLedger.BranchId, "CustomerLedger");
customerLedger.Sequence = GetAutoSequence("CustomerLedger");
Customer customer = _customerRepository.GetOne(x => x.Id == customerLedger.CustomerId);
customerLedger.TrackingNo = GenerateTrackingNo(customerLedger.CompanyId, customerLedger.BranchId, "CustomerLedger");
customerLedger.MoneyReceiveNo = GenerateMoneyReceiveNo(customerLedger.CompanyId, customerLedger.BranchId, "CustomerLedger");
customerLedger.TransactionDate = DateTime.Now;
customerLedger.CustomerMobileNumber = customer.Phone1;
customerLedger.Active = true;
customerLedger.SynchronizationType = SynchronizationType.Server.ToString();
customerLedger.AddedBy = identity.Name;
customerLedger.AddedDate = DateTime.Now;
customerLedger.AddedFromIp = identity.IpAddress;
_customerLedgerRepository.Add(customerLedger);
_unitOfWork.SaveChanges();
_rawSqlService.UpdateCustomerLedgerRunningBalance(customer.Id);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public ViewResult EditRole(int id)
{
ViewBag.Title = "Library :: Редакирование роли";
ViewBag.Caption = "Редактирование роли";
return(View("RoleForm", rRepo.GetOne(id)));
}
/// <summary>
/// 获取单条符合条件的 user 数据
/// </summary>
/// <param name="exp">条件表达式</param>
/// <returns></returns>
public UserDto GetOne(Expression <Func <UserDto, bool> > exp)
{
var where = exp.Cast <UserDto, User, bool>();
var entity = repository.GetOne(where);
return(Mapper.Map <User, UserDto>(entity));
}
public ViewResult EditRole(int id)
{
ViewBag.Title = "MVC CRUD :: Редакирование роли";
ViewBag.Caption = "Редактирование роли";
ViewBag.NewRole = roleRepo.GetOne(id).RoleName;
return(View("RoleForm"));
}
public void Add(PromotionalDiscount promotionalDiscount)
{
var flag = false;
try
{
_unitOfWork.BeginTransaction();
flag = true;
#region PromotionalDiscount
var identity = (LoginIdentity)Thread.CurrentPrincipal.Identity;
promotionalDiscount.Id = GetAutoNumber();
promotionalDiscount.Sequence = GetAutoSequence();
promotionalDiscount.Active = true;
promotionalDiscount.SynchronizationType = SynchronizationType.Server.ToString();
promotionalDiscount.AddedBy = identity.Name;
promotionalDiscount.AddedDate = DateTime.Now;
promotionalDiscount.AddedFromIp = identity.IpAddress;
#endregion
#region PromotionalDiscount Detail
var detailId = GetAutoIntNumber("PromotionalDiscountDetail");
var sequence = GetAutoSequence("PromotionalDiscountDetail");
if (promotionalDiscount.PromotionalDiscountDetails != null)
{
foreach (var item in promotionalDiscount.PromotionalDiscountDetails)
{
var itemDb = _itemRepository.GetOne(item.ProductId);
item.Id = detailId.ToString();
item.Sequence = sequence;
item.PromotionalDiscountId = promotionalDiscount.Id;
item.ProductCode = itemDb?.Code;
item.Active = true;
item.AddedBy = identity.Name;
item.AddedDate = DateTime.Now;
item.AddedFromIp = identity.IpAddress;
_promotionalDiscountDetailRepository.Add(item);
detailId++;
sequence++;
}
}
#endregion
_promotionalDiscountRepository.Add(promotionalDiscount);
_unitOfWork.SaveChanges();
flag = false;
_unitOfWork.Commit();
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
finally
{
if (flag)
{
_unitOfWork.Rollback();
}
}
}
public virtual void Delete(string id)
{
M model = _repo.GetOne(id);
if (model != null)
{
_repo.Delete(model);
}
}
public ViewResult EditBook(int id)
{
ViewBag.Title = "MVC CRUD :: Редакирование книги";
ViewBag.Caption = "Редактирование книги";
ViewBag.Book = bRepo.GetOne(id);
ViewBag.Publishers = pRepo.GetAll();
ViewBag.Authors = aRepo.GetAll();
return(View("BookForm"));
}
/// <summary>
///
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public ProductMaster GetById(string id)
{
try
{
return(_productMasterRepository.GetOne(id));
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public JobApplication GetApplication(string companyName)
{
JobApplicationUser user = _userResolver.GetCurrentUser().Result;
JobApplicationEntity jobApplication =
_repository.GetOne(f => f.Owner.Equals(user) && f.CompanyName.Equals(companyName, StringComparison.Ordinal));
if (jobApplication != null)
{
return(_mapper.Map <JobApplication>(jobApplication));
}
return(null);
}
public IActionResult GetViagensPorMotorista([FromRoute] decimal id)
{
var motorista = _repositoryUser.GetOne(u => u.Id == id);
if (motorista == null)
{
return(NotFound("Motorista não encontrado"));
}
var viagems = _repositoryViagem.GetAll(v => v.IdMotorista == id);
return(Ok(viagems));
}
public async Task <IActionResult> CriarRotaEmAndamento(int idViagem)
{
var viagem = _repositoryViagem.GetById(idViagem);
if (viagem == null)
{
return(NotFound("Viagem não encontrada"));
}
if (viagem.Finalizacao != null)
{
return(BadRequest($"Viagem informada já finalizada"));
}
var rotaEmAndamento = await _repositoryRotaAtiva.GetOne(r => r.IdViagem == viagem.Id);
if (rotaEmAndamento != null)
{
return(BadRequest($"Está viagem ja possui uma rota em andamento"));
}
if (viagem.IdMotorista != _idUser)
{
return(BadRequest("Motorista logado não condiz com a viagem selecionada"));
}
if (viagem.IdMotorista != _idUser)
{
return(BadRequest("Motorista logado não condiz com a viagem selecionada"));
}
var existRodaEmAndamento = _repositoryRotaAtiva.GetEntityByExpression(r => r.Viagem.IdMotorista == _idUser &&
r.Viagem.Finalizacao == null,
v => v.Viagem).Any();
if (existRodaEmAndamento)
{
return(BadRequest("Motorista ja possui um rota em andamento"));
}
var rotaCriada = _repositoryRotaAtiva.Save(new RotaAtiva()
{
IdViagem = viagem.Id
});
viagem.DataInicio = DateTime.Now;
_repositoryViagem.Update(viagem);
return(Created(nameof(GetById), rotaCriada));
}
public void OpenUoWConstructorTest()
{
var target = CreateUoW();
Assert.IsNotNull(_repository.GetOne <Project>(t => t._id == _currentProject._id));
Assert.IsNotNull(target);
}
public decimal GetCustomerDiscountRate(string customerId)
{
decimal cstmrdsctrt = 0;
var customer = _customerRepository.GetOne(customerId);
if (customer != null)
{
var checkRate = customer.DiscountRate;
if (checkRate > 0)
{
cstmrdsctrt = checkRate;
}
else
{
var cstmrctg = _customerCategoryRepository.GetOne(x => x.Id == customer.CustomerCategoryId);
if (cstmrctg != null)
{
checkRate = cstmrctg.DiscountRate;
if (checkRate > 0)
{
cstmrdsctrt = checkRate;
}
}
}
}
return(cstmrdsctrt);
}
//[Route("[area]/[controller]/[action]/{id:int}")]
public IActionResult Edit(int id)
{
PizzaViewModel pizzaVM = new PizzaViewModel();
Pizza pizza = repository.GetOne(id);
pizzaVM.Title = pizza.Title;
pizzaVM.PizzaID = pizza.PizzaID;
pizzaVM.Description = pizza.Description;
pizzaVM.PriceHT = pizza.Price;
pizzaVM.Image = pizza.Image;
return(View(pizzaVM));
}
protected virtual void DeleteOneFixture()
{
ClearRepository();
using (IRepository <TestModel> repository = GetNewDbRepository())
{
repository.AddOne(new TestModel()
{
TestId = 1, TestData = "data1"
}).UpdateAll();
}
using (IRepository <TestModel> repository = GetNewDbRepository())
{
var one = new TestModel()
{
TestId = 1
};
Assert.Throws <InvalidOperationException>(() => repository.DeleteOne(one));
repository.DeleteOne(one, attache: true, autoupdate: true);
}
using (IRepository <TestModel> repository = GetNewDbRepository())
{
var one = repository.GetOne(entity => entity.TestId == 1);
one.Should().Be.Null();
}
ClearRepository();
}
protected virtual void AddRangeFixture()
{
ClearRepository();
using (IRepository <TestModel> repository = GetNewDbRepository())
{
var models = new List <TestModel> {
new TestModel()
{
TestId = 1, TestData = "data1"
},
new TestModel()
{
TestId = 2, TestData = "data1"
},
new TestModel()
{
TestId = 3, TestData = "data1"
}
};
repository.AddRange(models).UpdateAll();
}
using (IRepository <TestModel> repository = GetNewDbRepository())
{
var one = repository.GetOne(entity => entity.TestId == 1);
one.Should().Not.Be.Null();
one.TestId.Should().Equal(1);
}
ClearRepository();
}
private List <BarcodeGeneratorViewModel> Barcode(string productId, int number, string companyId, string branchId)
{
try
{
List <BarcodeGeneratorViewModel> bracods = new List <BarcodeGeneratorViewModel>();
var product = _productRepository.GetOne(productId);
if (!string.IsNullOrEmpty(product?.Id))
{
var sizeName = _sizeRepository.GetOne(product?.SizeId)?.Name;
var companyName = _companyRepository.GetOne(companyId)?.Name;
var branchName = _branchRepository.GetOne(branchId)?.Name;
for (int i = 1; i <= number; i++)
{
if (columnNumber < 6)
{
columnNumber++;
}
else
{
rowNumber++;
columnNumber = 1;
}
bracods.Add(new BarcodeGeneratorViewModel {
RowNumber = rowNumber, ColumnNumber = columnNumber, ProductId = productId, ProductCode = product.Code, ProductName = product.Name, SizeName = sizeName, RetailPrice = product.RetailPrice, CompanyId = companyId, CompanyName = companyName, BranchId = branchId, BranchName = branchName
});
}
}
return(bracods);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public async Task <List <ViagemDtoSaida> > ListarViagensOferecidas()
{
var viagens = GetEntityByExpression(v => v.Finalizacao == null && v.Cancelada == null &&
v.DataViagem > DateTime.Now && v.IdMotorista == _idUsuario, v => v.Motorista);
var idsViagens = viagens.Select(v => v.Id).ToList();
var viagensDtoSaida = _mapper.Map <List <ViagemDtoSaida> >(viagens);
var viagensSolicitadas = _repositorySolicitacaoViagem.GetAll(vs => idsViagens.Contains(vs.IdViagem));
var rotaAtiva = await _repositoryRotaAtiva.GetOne(r => r.Viagem.IdMotorista == _idUsuario && r.Viagem.Finalizacao == null);
viagensDtoSaida.ForEach(viagem =>
{
viagem.MotoristaDaCorrida = viagem.IdMotorista == _idUsuario;
viagem.QuantidadeDeSolicitacaoAtiva = viagensSolicitadas.Where(v => v.IdViagem == viagem.Id && (v.Recusada == false || v.Recusada == null))
.Count();
});
if (rotaAtiva != null)
{
viagensDtoSaida.Where(v => rotaAtiva.IdViagem == v.Id).FirstOrDefault().EmAndamento = true;
}
return(viagensDtoSaida);
}
public async Task <IActionResult> RemoverSolicitacaoViagem([FromRoute] int idViagem)
{
var viagem = _repositoryViagem.GetById(idViagem);
if (viagem == null)
{
return(BadRequest("Viagem não encontrada"));
}
if (viagem.Finalizacao != null)
{
return(BadRequest("Viagem ja finalizada"));
}
var solicitacao = await _repositorySolicitacaoViagem.GetOne(s => s.IdUsuario == _idUsuarioLogado && s.IdViagem == idViagem);
if (solicitacao == null)
{
return(BadRequest("Solicitacao viagem não encontrada"));
}
_repositorySolicitacaoViagem.Remove(solicitacao);
return(NoContent());
}
public Task Handle(UpdateIdeaCommentCommand message)
{
var existingComment = _repository.GetOne <IdeaComment>(message.Comment.Id);
if (existingComment == null)
{
return(Task.CompletedTask);
}
existingComment.Content = message.Comment.Content;
existingComment.ModifiedOn = DateTime.UtcNow;
var updatedComment = _repository.Update(existingComment);
return(_bus.RaiseEvent(new IdeaCommentUpdatedEvent(_dataMapper.Map <IdeaCommentDto>(updatedComment))));
}
public User ValidateLogin(string email, string password)
{
var repoUser = _userRepo.GetOne(email);
if (repoUser == null || !repoUser.IsActive)
{
return(new User());
}
if (repoUser.Password == ComputeSha256Hash(password))
{
//authenticated
repoUser.Password = "";
try
{
repoUser.Restaurant = _restaurantRepo.GetOne(repoUser.RestaurantId);
}
catch
{
repoUser.Restaurant = null;
}
repoUser.Token = GenerateToken(repoUser);
return(repoUser);
}
else
{
//not authenticated
return(new User());
}
}
public async Task <IActionResult> DeleteEcoItem([HttpTrigger(AuthorizationLevel.Anonymous, "post", Route = "ecoitem/delete")] HttpRequest req)
{
try
{
if (req.Body is null)
{
throw new NullReferenceException();
}
else if (await IsTokenValid(req))
{
int.TryParse(req.Query["id"], out int id);
using EcoItem item = await IEcoItemRepo.GetOne(id);
IEcoItemRepo.Remove(item);
await Context.SaveChangesAsync();
return(new OkObjectResult(new Response(true, "Item has been deleted.", null)));
}
else
{
return(new UnauthorizedResult());
}
}
catch (Exception)
{ throw new Exception("Oops! Something went wrong!"); }
}
public override object Process(ServerParameters parameters, dynamic data)
{
var server = serversTable.GetOne(x => x.Endpoint == parameters.Endpoint);
if (server != null)
{
// Update already existing server
server.Info = data.ToObject <ServerInfo>();
serversTable.Update(server);
}
else
{
// First time we met this endpoint, insert new server
server = new Model.Server()
{
Endpoint = parameters.Endpoint,
Info = data.ToObject <ServerInfo>(),
};
serversTable.Insert(server);
}
return(new object());
}
public virtual async Task <IActionResult> Delete(string id)
{
if (id == null)
{
return(NotFound());
}
var entity = await Repo.GetOne(id);
if (entity == null)
{
return(NotFound());
}
return(View(entity));
} // POST: ExampleAdmin/Delete/5
public Department GetByDepartmentName(string depName)
{
Department dep = null;
var builder = Builders <Department> .Filter;
var filter = builder.Eq("DepartmentName", depName);
try
{
dep = repo.GetOne <Department>(filter);
}
catch (Exception ex)
{
DALUtils.ErrorRoutine(ex, "DepartmentDAO", "GetByDepartmentName");
}
return(dep);
}
/*
* GetByProblemDescription()
* Uses the Repository and Gets the specific employee based on the "Description" of the Problem
*/
public Problem GetByProblemDescription(string description)
{
Problem prob = null;
var builder = Builders <Problem> .Filter;
var filter = builder.Eq("Description", description);
try
{
prob = repo.GetOne <Problem>(filter);
}
catch (Exception ex)
{
DALUtils.ErrorRoutine(ex, "ProblemDAO", "GetByProblemDescription");
}
return(prob);
}
/*
* GetByLastname()
* Uses the Repository and Gets the specific employee based on the "Lastname" of the Employee
*/
public Employee GetByLastname(string name)
{
Employee emp = null;
var builder = Builders <Employee> .Filter;
var filter = builder.Eq("Lastname", name);
try
{
emp = repo.GetOne <Employee>(filter);
}
catch (Exception ex)
{
DALUtils.ErrorRoutine(ex, "EmployeeDAO", "GetByLastname");
}
return(emp);
}
public override void OnActionExecuted(ActionExecutedContext filterContext)
{
if (!filterContext.HttpContext.User.Identity.IsAuthenticated)
{
return;
}
//TODO: temporary fix. IoC should resolve it automatically
UserRepository = DependencyResolver.Current.GetService<IRepository<User, Guid>>();
var viewResult = filterContext.Result as ViewResult;
if (viewResult != null)
{
string currentUserEmail = filterContext.HttpContext.User.Identity.Name;
User currentUser = UserRepository.GetOne(r => r.Email == currentUserEmail);
if (currentUser != null)
{
viewResult.ViewBag.Username = currentUser.Name;
}
}
}
private static bool UserWithEmailExists(IRepository<User, Guid> userRepository, string userEmail)
{
return userRepository.GetOne(u => u.Email == userEmail) != null;
}
