public List <CorporatesViewModel> FilterJob(FilterViewModel FilterViewModel)
{
List <Corporates> CorporatesList = new List <Corporates>();
List <CorporatesViewModel> CorporatesViewModelList = new List <CorporatesViewModel>();
CorporatesList = db.Corporates.Where(w =>
(w.CityId == FilterViewModel.CityId || FilterViewModel.CityId == null) &&
(w.CountryId == FilterViewModel.CountryId || FilterViewModel.CountryId == null)).OrderByDescending(o => o.UserName).Skip(FilterViewModel.StartRecord).Take(FilterViewModel.RecordPerpage).ToList();
foreach (var item in CorporatesList)
{
CorporatesViewModel CorporatesViewModel = new CorporatesViewModel();
Mapper.CreateMap <Corporates, CorporatesViewModel>();
CorporatesViewModel = Mapper.Map <Corporates, CorporatesViewModel>(item);
CorporatesViewModel.CityName = item.City?.CityName;
CorporatesViewModel.CountryName = item.Country?.CountryName;
CorporatesViewModelList.Add(CorporatesViewModel);
}
return(CorporatesViewModelList);
}
public CorporatesViewModel GetCoroprate(int id)
{
CorporatesViewModel CorporatesViewModel = new CorporatesViewModel();
NGOdata.Corporates GetCorporates;
GetCorporates = db.Corporates.Where(x => x.Id == id).FirstOrDefault();
Mapper.CreateMap <Corporates, CorporatesViewModel>();
CorporatesViewModel = Mapper.Map <Corporates, CorporatesViewModel>(GetCorporates);
CorporatesViewModel.CityName = GetCorporates.City?.CityName;
CorporatesViewModel.CountryName = GetCorporates.Country?.CountryName;
CorporatesViewModel.SegmentName = GetCorporates.Segments?.SegmentsName;
return(CorporatesViewModel);
}
public IHttpActionResult PostCoroprates(CorporatesViewModel CorporatesViewModel)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
Corporates corporates = new Corporates();
Mapper.CreateMap <CorporatesViewModel, Corporates>();
corporates = Mapper.Map <CorporatesViewModel, Corporates>(CorporatesViewModel);
db.Corporates.Add(corporates);
db.SaveChanges();
return(CreatedAtRoute("DefaultApi", new { id = CorporatesViewModel.Id }, CorporatesViewModel));
}
public CorporatesViewModel GetUserByCorporateName(string UserName)
{
CorporatesViewModel Corporate = new CorporatesViewModel();
NGOdata.Corporates GetCorporate;
GetCorporate = db.Corporates.Where(x => x.UserName == UserName).FirstOrDefault();
Mapper.CreateMap <Corporates, CorporatesViewModel>();
Corporate = Mapper.Map <Corporates, CorporatesViewModel>(GetCorporate);
Corporate.CountryName = GetCorporate.Country?.CountryName;
Corporate.SegmentName = GetCorporate.Segments?.SegmentsName;
Corporate.CityName = GetCorporate.City?.CityName;
return(Corporate);
}
public IHttpActionResult PutCoroprates(int id, CorporatesViewModel CorporatesViewModel)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != CorporatesViewModel.Id)
{
return(BadRequest());
}
Corporates Corporates = new Corporates();
Mapper.CreateMap <CorporatesViewModel, Corporates>();
Corporates = Mapper.Map <CorporatesViewModel, Corporates>(CorporatesViewModel);
db.Entry(Corporates).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!CorporatesExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
// GET: api/Coroprates
public List <CorporatesViewModel> GetCoroprates()
{
var CorporatesList = db.Corporates.ToList();
List <CorporatesViewModel> CorporatesViewModelList = new List <CorporatesViewModel>();
foreach (var item in CorporatesList)
{
CorporatesViewModel CorporatesViewModel = new CorporatesViewModel();
Mapper.CreateMap <Corporates, CorporatesViewModel>();
CorporatesViewModel = Mapper.Map <Corporates, CorporatesViewModel>(item);
CorporatesViewModel.CityName = item.City?.CityName;
CorporatesViewModel.CountryName = item.Country?.CountryName;
CorporatesViewModel.SegmentName = item.Segments?.SegmentsName;
CorporatesViewModelList.Add(CorporatesViewModel);
}
return(CorporatesViewModelList);
}
