public IHttpActionResult ReadAll(int?regID = null)
{
using (var db = new DB_Context())
{
try
{
RegionDetailViewModel listResult = new RegionDetailViewModel();
var listRegionEntity = db.Regions.AsQueryable();
List <RegionDetailViewModel> listRegion = new List <RegionDetailViewModel>();
if (regID != null)
{
listRegionEntity = listRegionEntity.Where(data => data.RegionID == regID);
}
foreach (var item in listRegionEntity.AsEnumerable().ToList())
{
RegionDetailViewModel region = new RegionDetailViewModel(item);
listRegion.Add(region);
}
Dictionary <string, object> finalReturn = listResult.FinalResult(listRegion, "Read Data Success");
return(Ok(finalReturn));
}
catch (Exception)
{
throw;
}
}
}
public IHttpActionResult ReadAll(int?regionID = null)
{
using (var DB = new DB_Context())
{
try
{
var tem = DB.Regions.AsQueryable();
RegionDetailViewModel regionObj = new RegionDetailViewModel();
List <RegionDetailViewModel> listRegion = new List <RegionDetailViewModel>();
if (regionID != null)
{
tem = tem.Where(data => data.RegionID == regionID);
}
var listRegionEntity = tem.AsEnumerable().ToList();
foreach (var item in listRegionEntity)
{
RegionDetailViewModel region = new RegionDetailViewModel(item);
listRegion.Add(region);
}
return(Ok(regionObj.finalResult(listRegion, "Read Data Success")));
}
catch (Exception)
{
throw;
}
}
}
public IHttpActionResult Update([FromBody] RegionDetailViewModel dataBody)
{
using (var db = new DB_Context())
{
try
{
List <RegionDetailViewModel> listRegion = new List <RegionDetailViewModel>();
Region region = db.Regions.Find(dataBody.RegionID);
var temp = dataBody.convertToRegion2(region);
RegionDetailViewModel reg = new RegionDetailViewModel(temp);
listRegion.Add(reg);
db.SaveChanges();
return(Ok(dataBody.finalResult(listRegion, "Update Data Success")));
}
catch (Exception)
{
throw;
}
}
}
public IHttpActionResult Create([FromBody] RegionDetailViewModel dataBody)
{
using (var DB = new DB_Context())
{
try
{
List <RegionDetailViewModel> listRegion = new List <RegionDetailViewModel>();
var temp = dataBody.convertToRegion();
DB.Regions.Add(temp);
DB.SaveChanges();
var reg = DB.Regions.Where(dt => dt.RegionID == dataBody.RegionID).AsEnumerable().ToList();
RegionDetailViewModel regionView = new RegionDetailViewModel(reg);
listRegion.Add(regionView);
dataBody.Insertdata(DB);
return(Ok(dataBody.finalResult(listRegion, "Insert Data Success")));
}
catch (Exception)
{
throw;
}
}
}
public IHttpActionResult Create([FromBody] RegionDetailViewModel dataBody)
{
using (var db = new DB_Context())
{
try
{
Dictionary <string, object> result = new Dictionary <string, object>();
List <RegionDetailViewModel> listDetail = new List <RegionDetailViewModel>();
var temp = dataBody.convertToRegion();
db.Regions.Add(temp);
db.SaveChanges();
var regTemp = db.Regions.Where(dt => dt.RegionID == dataBody.RegionID).AsEnumerable().ToList();
RegionDetailViewModel regView = new RegionDetailViewModel(regTemp);
listDetail.Add(regView);
result.Add("data region", listDetail);
dataBody.InputData(db);
return(Ok(result));
}
catch (Exception)
{
throw;
}
}
}
