//public async Task<ModelBarangResponse> GetPost(long ID)
//{
// var model = await dep.GetPost(ID);
// if (model == null)
// {
// return null;
// }
// return model;
//}
public async Task <ModelBarangResponse> AddPost(ModelBarangRequest model)
{
ModelBarangResponse response = new ModelBarangResponse();
try
{
ModelBarang request = new ModelBarang();
request.MerkId = model.MerkID;
request.Name = model.Name;
ModelBarang result = await dep.GetModelWithMerkIDModelName(request);
if (result != null)
{
response.IsSuccess = false;
response.Message = "Data Duplicate with Existing";
}
else
{
response = await dep.AddPost(model);
}
}
catch (Exception ex)
{
log.Error(ex);
response.Message = ex.ToString();
response.IsSuccess = false;
}
return(response);
}
public async Task <ModelBarangResponse> UpdateCategory(ModelBarang request)
{
ModelBarangResponse response = new ModelBarangResponse();
try
{
if (db != null)
{
ModelBarang model = await db.ModelBarang.Where(x => x.Id == request.Id).FirstAsync();
model.Modified = DateTime.Now;
model.ModifiedBy = request.ModifiedBy;
model.Category = request.Category;
db.ModelBarang.Update(model);
//Commit the transaction
await db.SaveChangesAsync();
response.Message = "Update success";
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 <ModelBarangResponse> DeleteCategory(ModelBarangRequest model)
{
ModelBarangResponse resp = new ModelBarangResponse();
ModelBarang m = await dep.GetModelBarangByID(model.ID);
m.Id = model.ID;
m.ModifiedBy = model.UserName;
m.Modified = DateTime.Now;
m.Category = m.Category.Replace("other,", "");
m.Category = m.Category.Replace("other", "");
long result = 0;
result = await dep.DeleteCategory(m);
if (result == 0)
{
resp.IsSuccess = false;
resp.Message = "Failed when delete Model Bareng";
}
else
{
resp.IsSuccess = true;
resp.Message = "Success Delete Model Barang";
}
return(resp);
}
public async Task <ModelBarangResponse> AddCategory([FromBody] ModelBarangRequest model)
{
ModelBarangResponse resp = new ModelBarangResponse();
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);
}
model.UserName = username;
if (model.ID > 0)
{
resp = await facade.UpdateCategory(model);
}
//else
//{
// resp = await facade.AddPost(model);
//}
return(resp);
}
catch (Exception ex)
{
resp.IsSuccess = false;
resp.Message = ex.Message.ToString();
return(resp);
}
}
public async Task <ModelBarangResponse> UpdateCategory(ModelBarangRequest model)
{
ModelBarangResponse response = new ModelBarangResponse();
try
{
ModelBarang request = new ModelBarang();
request.Id = model.ID;
ModelBarang result = await dep.GetModelBarangByID(model.ID);
if (result != null)
{
result.Modified = DateTime.Now;
result.ModifiedBy = model.UserName;
if (result.Category != null || !string.IsNullOrWhiteSpace(result.Category))
{
result.Category = result.Category + ", " + model.Category;
}
else
{
result.Category = model.Category;
}
response = await dep.UpdateCategory(result);
response.IsSuccess = true;
response.Message = "Update Success";
}
else
{
response.IsSuccess = false;
response.Message = "Data Does not exist.";
}
}
catch (Exception ex)
{
log.Error(ex);
response.Message = ex.ToString();
response.IsSuccess = false;
}
return(response);
}
public async Task <ModelBarangResponse> DeletePost(ModelBarangRequest model)
{
ModelBarangResponse resp = new ModelBarangResponse();
long result = 0;
result = await dep.DeletePost(model.ID, model.UserName);
if (result == 0)
{
resp.IsSuccess = false;
resp.Message = "Failed when delete Model Bareng";
}
else
{
resp.IsSuccess = true;
resp.Message = "Success Delete Model Barang";
}
return(resp);
}
public async Task <ModelBarangResponse> GetModelByKotaIDMerkID(ModelBarangRequest model)
{
ModelBarangResponse response = new ModelBarangResponse();
try
{
response.ListSP_ModelByKotaIDMerkID = await dep.GetModelByKotaIDMerkID(model);
response.Message = "Success";
response.IsSuccess = true;
}
catch (Exception ex)
{
response.Message = ex.ToString();;
response.IsSuccess = false;
}
return(response);
}
public async Task <ModelBarangResponse> GetModelWithMerkID(ModelBarangRequest request)
{
ModelBarangResponse response = new ModelBarangResponse();
try
{
if (db != null)
{
response.ListModel = await(from model in db.ModelBarang
where model.MerkId == request.MerkID & model.RowStatus == true
select new ModelBarangViewModel
{
ID = model.Id,
Name = model.Name,
MerkID = model.MerkId,
Description = model.Description,
Created = model.Created,
CreatedBy = model.Createdby,
Modified = model.Modified,
ModifiedBy = model.ModifiedBy,
RowStatus = model.RowStatus
}).OrderBy(x => x.Name).ToListAsync();
response.Message = "Load Success";
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 <ModelBarangResponse> AddPost(ModelBarangRequest request)
{
ModelBarangResponse response = new ModelBarangResponse();
try
{
if (db != null)
{
ModelBarang model = new ModelBarang();
model.Name = request.Name;
model.Description = request.Description;
model.MerkId = request.MerkID;
model.Created = DateTime.Now;
model.Createdby = request.UserName;
model.RowStatus = true;
await db.ModelBarang.AddAsync(model);
await db.SaveChangesAsync();
response.IsSuccess = true;
response.Message = "Data Already Saved";
}
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 <ModelBarangResponse> GetAllCategory(string search, string order, string orderDir, int startRec, int pageSize, int draw, string type)
{
ModelBarangResponse response = new ModelBarangResponse();
try
{
if (db != null)
{
var query = (from model in db.ModelBarang
join merk in db.Merk
on model.MerkId equals merk.Id
where model.Category != null &&
model.Category.Contains(type) &&
merk.RowStatus == true &&
model.RowStatus == true
select new
{
model.Id,
model.Name,
NamaMerk = merk.Name,
model.MerkId,
model.Description,
model.Created,
model.Createdby,
model.Modified,
model.ModifiedBy,
model.RowStatus
}
);
int totalRecords = query.Count();
if (!string.IsNullOrEmpty(search) && !string.IsNullOrWhiteSpace(search))
{
query = query.Where(p => p.Name.ToString().ToLower().Contains(search.ToLower()) ||
p.NamaMerk.ToString().ToLower().Contains(search.ToLower()) ||
p.Description.ToLower().Contains(search.ToLower()));
}
int recFilter = query.Count();
response.ListModel = await(from model in query
select new ModelBarangViewModel
{
ID = model.Id,
Name = model.Name,
NamaMerk = model.NamaMerk,
MerkID = model.MerkId,
Description = model.Description,
Created = model.Created,
CreatedBy = model.Createdby,
Modified = model.Modified,
ModifiedBy = model.ModifiedBy,
RowStatus = model.RowStatus
}).Skip(startRec).Take(pageSize).ToListAsync();
response.draw = Convert.ToInt32(draw);
response.recordsTotal = totalRecords;
response.recordsFiltered = recFilter;
response.Message = "Load Success";
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);
}
