public async Task <IActionResult> Add(PersonnelVM vm)
{
if (ModelState.IsValid)
{
try
{
var obj = (await objRep.Add(vm));
if (obj.Successed)
{
if (obj.ResultObject.PersonnelId > 0)
{
return(Ok(obj));
}
else
{
return(NotFound());
}
}
else
{
return(NotFound(obj));
}
}
catch (Exception)
{
return(BadRequest());
}
}
return(BadRequest());
}
public async Task <RepResult <PersonnelVM> > Login(string nationalCode, string passWord)
{
if (dbContext != null)
{
var query = from prs in dbContext.Personnels join user in dbContext.Users on prs.PersonnelId equals user.PersonnelId
where prs.NationalCode == nationalCode && user.Password == passWord select prs;
if (await query.AnyAsync())
{
var obj = await query.Include(c => c.Users).SingleOrDefaultAsync();
PersonnelRepository.LoadUser(obj);
return(new RepResult <PersonnelVM> {
Successed = true, ResultObject = PersonnelVM.GetVM(obj)
});
}
else
{
return(new RepResult <PersonnelVM> {
Successed = false,
Message = "پرسنل با این کد ملی و پسورد در سیستم موجود نمی باشد"
});
}
}
return(new RepResult <PersonnelVM>());
}
public async Task <RepResult <PersonnelVM> > Update(PersonnelVM vm)
{
if (dbContext != null)
{
if (!await dbContext.Personnels.AnyAsync(a => a.NationalCode.Contains(vm.NationalCode) && a.PersonnelId != vm.PersonnelId))
{
var obj = PersonnelVM.GetAnyObject(vm, false);
dbContext.Entry(obj.Item1).State = EntityState.Modified;
dbContext.Entry(obj.Item2).State = EntityState.Modified;
await dbContext.SaveChangesAsync();
return(new RepResult <PersonnelVM> {
Successed = true, ResultObject = (await Get(obj.Item1.PersonnelId)).ResultObject
});
}
else
{
return(new RepResult <PersonnelVM> {
Successed = false, Message = "پرسنل با این کد ملی در سیستم ثبت شده است. شما قادر به ثبت مجدد نمی باشید", ResultObject = null
});
}
}
return(new RepResult <PersonnelVM>());
}
public async Task <RepResult <PersonnelVM> > Get(int id)
{
if (dbContext != null)
{
var obj = await entity.Include(c => c.Users).SingleOrDefaultAsync(s => s.PersonnelId == id);
LoadUser(obj);
return(new RepResult <PersonnelVM> {
Successed = true, ResultObject = PersonnelVM.GetVM(obj)
});
}
return(new RepResult <PersonnelVM>());
}
public async Task <RepResult <IEnumerable <PersonnelVM> > > Get()
{
if (dbContext != null)
{
var objs = await entity.Include(c => c.Users).ToAsyncEnumerable().ToList();
foreach (Personnel obj in objs)
{
LoadUser(obj);
}
return(new RepResult <IEnumerable <PersonnelVM> > {
Successed = true, ResultObject = objs.Select(m => PersonnelVM.GetVM(m))
});
}
return(new RepResult <IEnumerable <PersonnelVM> >());
}
public async Task <IActionResult> Update(PersonnelVM vm)
{
if (ModelState.IsValid)
{
try
{
var obj = (await objRep.Update(vm));
if (obj.Successed)
{
if (obj.ResultObject.PersonnelId > 0)
{
return(Ok(obj));
}
else
{
return(NotFound());
}
}
else
{
return(NotFound(obj));
}
}
catch (Exception ex)
{
if (ex.GetType().FullName == "Microsoft.EntityFrameworkCore.DbUpdateConcurrencyException")
{
return(NotFound());
}
return(BadRequest());
}
}
return(BadRequest());
}