//public async Task<TypeBarangResponse> GetTypeByName(TypeBarangRequest request)
//{
// TypeBarangResponse response = new TypeBarangResponse();
// return response;
//}
public async Task <TypeBarangResponse> AddPost(TypeBarangRequest request)
{
TypeBarangResponse response = new TypeBarangResponse();
try
{
TypeBarang req = new TypeBarang();
req.Name = request.Name;
TypeBarang model = await dep.GetTypeByName(req);
if (model != null)
{
response.IsSuccess = false;
response.Message = "Data Duplicate with Existing Data";
}
else
{
req.ModelBarangId = request.ModelBarangID;
req.Name = request.Name;
req.Description = request.Description;
req.Created = DateTime.Now;
req.CreatedBy = request.UserName;
req.RowStatus = true;
response = await dep.AddPost(req);
}
}
catch (Exception ex)
{
log.Error(ex);
response.Message = ex.Message.ToString();
response.IsSuccess = false;
}
return(response);
}
public async Task <TypeBarangResponse> GetPost(TypeBarangRequest request)
{
TypeBarangResponse response = new TypeBarangResponse();
try
{
if (db != null)
{
response.Model = await(from model in db.TypeBarang
where model.Id == request.ID && model.RowStatus == true
select new TypeBarangViewModel
{
ID = model.Id,
Name = model.Name,
ModelBarangID = model.ModelBarangId,
Description = model.Description,
Created = model.Created,
CreatedBy = model.CreatedBy,
Modified = model.Modified,
ModifiedBy = model.ModifiedBy,
RowStatus = model.RowStatus
}).FirstOrDefaultAsync();
if (response.Model == null)
{
response.IsSuccess = true;
response.Message = "Data Not Found";
}
response.IsSuccess = true;
response.Message = "Load Success";
}
else
{
response.Message = "Opps, Something Error with System Righ Now !";
response.IsSuccess = false;
}
}
catch (Exception ex)
{
response.Message = ex.ToString();
response.IsSuccess = false;
//return await (from model in db.TypeBarang
// where model.Id == ID && model.RowStatus == true
// select new TypeBarangViewModel
// {
// ID = model.Id,
// Nama = model.Name,
// ModelBarangID = model.ModelBarangId,
// Description = model.Description,
// Created = model.Created,
// CreatedBy = model.CreatedBy,
// Modified = model.Modified,
// ModifiedBy = model.ModifiedBy,
// RowStatus = model.RowStatus
// }).FirstOrDefaultAsync();
}
return(response);
}
public async Task <TypeBarangResponse> DeletePost([FromBody] TypeBarangRequest request)
{
TypeBarangResponse resp = new TypeBarangResponse();
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);
}
request.UserName = username;
return(resp = await facade.DeletePost(request));;
}
catch (Exception ex)
{
resp.IsSuccess = false;
resp.Message = ex.Message.ToString();
return(resp);
}
//try
//{
// var result = await facade.DeletePost(request);
// return Ok(result);
//}
//catch (Exception)
//{
// return BadRequest();
//}
}
public async Task <BarangResponse> UpdatePost(BarangRequest request, string username)
{
BarangResponse response = new BarangResponse();
try
{
TypeBarangRequest typeRequest = new TypeBarangRequest();
typeRequest.ID = request.TypeBarangId;
var getTYpe = da_type.GetPost(typeRequest).Result;
Barang model = new Barang();
model.Id = request.ID;
model.HargaOtr = request.HargaOtr;
model.Name = getTYpe.Model.Name;
model.WarnaId = request.WarnaId;
model.TypeBarangId = request.TypeBarangId;
model.KotaId = request.KotaID.Value;
//model.PhotoPath = request.PhotoPath;
model.Year = request.Year.Value;
model.Modified = DateTime.Now;
model.ModifiedBy = username;
bool result = await dep.UpdatePost(model);
if (result)
{
response.Message = "Data Already Saved";
response.IsSuccess = true;
}
else
{
response.Message = "Update Failed";
response.IsSuccess = false;
}
}
catch (Exception ex)
{
log.Error(ex);
response.Message = ex.ToString();
response.IsSuccess = false;
}
return(response);
}
public async Task <IActionResult> GetPost([FromBody] TypeBarangRequest request)
{
try
{
var post = await facade.GetPost(request);
if (post == null)
{
return(NotFound());
}
return(Ok(post));
}
catch (Exception)
{
return(BadRequest());
}
}
public async Task <IActionResult> GetAllWithModelID([FromBody] TypeBarangRequest request)
{
try
{
var models = await facade.GetAllWithModelID(request);
if (models == null)
{
return(NotFound());
}
return(Ok(models));
}
catch (Exception ex)
{
return(BadRequest(ex));
}
}
public async Task <TypeBarangResponse> DeletePost(TypeBarangRequest request)
{
TypeBarangResponse response = new TypeBarangResponse();
try
{
if (db != null)
{
//Find the warna for specific userprofile
TypeBarang model = await db.TypeBarang.FirstOrDefaultAsync(x => x.Id == request.ID);
if (model != null)
{
model.Modified = DateTime.Now;
model.ModifiedBy = request.UserName;
model.RowStatus = false;
//Commit the transaction
await db.SaveChangesAsync();
response.Message = "Data Already Saved";
response.IsSuccess = true;
}
else
{
response.Message = "Data Not Found";
response.IsSuccess = false;
}
}
else
{
response.Message = "Opps, Something Error with System Righ Now !";
response.IsSuccess = false;
}
}
catch (Exception ex)
{
response.Message = ex.ToString();
response.IsSuccess = false;
}
return(response);
}
public async Task <TypeBarangResponse> GetTypeByKotaIDMerkIDModelID(TypeBarangRequest request)
{
TypeBarangResponse response = new TypeBarangResponse();
try
{
response.ListSP__TypeByKotaIDMerkIDModelID = await dep.GetTypeByKotaIDMerkIDModelID(request);
response.Message = "Success";
response.IsSuccess = true;
}
catch (Exception ex)
{
log.Error(ex);
response.IsSuccess = false;
response.Message = "Failed";
}
return(response);
}
public async Task <BarangResponse> AddPost(BarangRequest request, string email)
{
BarangResponse response = new BarangResponse();
try
{
TypeBarangRequest typeRequest = new TypeBarangRequest();
typeRequest.ID = request.TypeBarangId;
var getTYpe = da_type.GetPost(typeRequest).Result;
Barang model = new Barang();
model.HargaOtr = request.HargaOtr;
model.Name = getTYpe.Model.Name;
model.WarnaId = request.WarnaId;
model.PhotoPath = request.PhotoPath;
model.TypeBarangId = request.TypeBarangId;
model.Created = DateTime.Now;
model.CreatedBy = email;
model.RowStatus = true;
model.KotaId = request.KotaID.Value;
var postId = await dep.AddPost(model);
if (postId > 0)
{
response.Message = "Data Already Saved";
response.IsSuccess = true;
}
else
{
response.Message = "Save Failed";
response.IsSuccess = false;
}
}
catch (Exception ex)
{
response.Message = ex.ToString();
response.IsSuccess = false;
}
return(response);
}
public async Task <TypeBarangResponse> UpdatePost(TypeBarangRequest request)
{
TypeBarangResponse response = new TypeBarangResponse();
try
{
if (db != null)
{
TypeBarang model = await db.TypeBarang.Where(x => x.RowStatus == true && x.Id == request.ID).FirstAsync();
model.ModelBarangId = request.ModelBarangID;
model.Name = request.Name;
model.Description = request.Description;
model.Modified = DateTime.Now;
model.ModifiedBy = request.CreatedBy;
db.TypeBarang.Update(model);
//Commit the transaction
await db.SaveChangesAsync();
response.Message = "Data Already Saved";
response.IsSuccess = true;
}
else
{
response.Message = "Opps, Something Error with System Righ Now !";
response.IsSuccess = false;
}
}
catch (Exception ex)
{
response.Message = ex.ToString();
response.IsSuccess = false;
}
return(response);
}
public async Task <IActionResult> GetTypeByKotaIDMerkIDModelID([FromBody] TypeBarangRequest request)
{
if (ModelState.IsValid)
{
try
{
var result = await facade.GetTypeByKotaIDMerkIDModelID(request);
return(Ok(result));
}
catch (Exception ex)
{
if (ex.GetType().FullName ==
"Microsoft.EntityFrameworkCore.DbUpdateConcurrencyException")
{
return(NotFound());
}
return(BadRequest());
}
}
return(BadRequest());
}
public async Task <TypeBarangResponse> GetPost(TypeBarangRequest request)
{
return(await dep.GetPost(request));
}
public async Task <TypeBarangResponse> GetAllWithModelID(TypeBarangRequest request)
{
return(await dep.GetAllWithModelID(request));
}
public async Task <List <SP_TypeByKotaIDMerkIDModelID> > GetTypeByKotaIDMerkIDModelID(TypeBarangRequest request)
{
if (db != null)
{
try
{
return(await db.Set <SP_TypeByKotaIDMerkIDModelID>().FromSql("EXEC sp_TypeByKotaIDMerkIDModelID {0},{1},{2}",
request.KotaID, request.MerkID, request.ModelBarangID).AsNoTracking().ToListAsync());
}
catch (Exception ex)
{
throw ex;
}
}
return(null);
}
