public async Task <ProvinsiResponse> DeletePost(ProvinsiRequest request)
{
ProvinsiResponse response = new ProvinsiResponse();
if (db != null)
{
try
{
Provinsi model = await db.Provinsi.Where(x => x.RowStatus == true && x.Id == request.ID).FirstOrDefaultAsync();
if (model != null)
{
model.Modified = DateTime.Now;
model.ModifiedBy = request.UserName;
model.RowStatus = false;
await db.SaveChangesAsync();
response.IsSuccess = true;
response.Message = "Data has been Saved";
}
else
{
response.IsSuccess = false;
response.Message = "Data Not Found";
}
}
catch (Exception ex)
{
response.Message = ex.ToString();
response.IsSuccess = false;
}
}
return(response);
}
public async Task <ProvinsiResponse> GetPost(ProvinsiRequest request)
{
ProvinsiResponse response = new ProvinsiResponse();
if (db != null)
{
try
{
response.Model = await(from prov in db.Provinsi
where prov.RowStatus == true && request.ID == prov.Id
select new ProvinsiViewModel
{
ID = prov.Id,
Name = prov.Name,
Created = prov.Created,
CreatedBy = prov.CreatedBy,
Description = prov.Description,
Modified = prov.Modified,
ModifiedBy = prov.ModifiedBy,
RowStatus = prov.RowStatus
}).FirstOrDefaultAsync();
response.Message = "Success";
}
catch (Exception ex)
{
response.Message = ex.ToString();
response.IsSuccess = false;
}
}
return(response);
}
public async Task <ProvinsiResponse> GetPost(ProvinsiRequest req)
{
var model = await dep.GetPost(req);
if (model == null)
{
return(null);
}
return(model);
}
public async Task <ProvinsiResponse> DeletePost(ProvinsiRequest req)
{
ProvinsiResponse resp = new ProvinsiResponse();
try
{
string bearer = Request.HttpContext.Request.Headers["Authorization"];
string token = bearer.Substring("Bearer ".Length).Trim();
string username = string.Empty;
if (string.IsNullOrEmpty(token))
{
resp.IsSuccess = false;
resp.Message = "You don't have access.";
return(resp);
}
username = sec.ValidateToken(token);
if (username == null)
{
Response.HttpContext.Response.Cookies.Append("access_token", "", new CookieOptions()
{
Expires = DateTime.Now.AddDays(-1)
});
resp.IsSuccess = false;
resp.Message = "Your session was expired, please re-login.";
return(resp);
}
req.UserName = username;
return(resp = await facade.DeletePost(req));
}
catch (Exception ex)
{
resp.IsSuccess = false;
resp.Message = ex.Message.ToString();
return(resp);
}
//try
//{
// var result = await facade.DeletePost(req);
// return Ok(result);
//}
//catch (Exception)
//{
// return BadRequest();
//}
}
public async Task <ProvinsiResponse> AddPost(ProvinsiRequest req)
{
ProvinsiResponse response = new ProvinsiResponse();
long result = 0;
try
{
Provinsi getModel = await dep.GetByName(req.Name);
if (getModel == null)
{
Provinsi provinsi = new Provinsi();
provinsi.Name = req.Name;
provinsi.Description = req.Description;
provinsi.Created = DateTime.Now;
provinsi.CreatedBy = req.UserName;
provinsi.RowStatus = true;
result = await dep.AddPost(provinsi);
if (result > 0)
{
response.Message = "Data Already Saved";
response.IsSuccess = true;
}
else
{
response.Message = "Save data failed";
response.IsSuccess = false;
}
}
else
{
response.Message = "Duplicate with Existing Data";
response.IsSuccess = false;
}
}
catch (Exception ex)
{
log.Error(ex);
response.Message = ex.ToString();
response.IsSuccess = false;
}
return(response);
}
public async Task <IActionResult> GetPost(ProvinsiRequest req)
{
if (req == null)
{
return(BadRequest());
}
try
{
var post = await facade.GetPost(req);
if (post == null)
{
return(NotFound());
}
return(Ok(post));
}
catch (Exception)
{
return(BadRequest());
}
}
public async Task <IActionResult> UpdatePost([FromBody] ProvinsiRequest req)
{
if (ModelState.IsValid)
{
try
{
var result = await facade.UpdatePost(req);
return(Ok(result));
}
catch (Exception ex)
{
if (ex.GetType().FullName ==
"Microsoft.EntityFrameworkCore.DbUpdateConcurrencyException")
{
return(NotFound());
}
return(BadRequest());
}
}
return(BadRequest());
}
public async Task <ProvinsiResponse> DeletePost(ProvinsiRequest req)
{
return(await dep.DeletePost(req));
}
