public async Task <MerkResponse> AddPost(MerkRequest model)
{
MerkResponse response = new MerkResponse();
try
{
if (await dep.GetMerkByName(model.Name) != null)
{
response.Message = "Data is Duplicate with Existing Data";
response.IsSuccess = false;
}
else
{
response = await dep.AddPost(model);
}
}
catch (Exception ex)
{
log.Error(ex);
response.Message = ex.ToString();
response.IsSuccess = false;
}
return(response);
}
public async Task <MerkResponse> AddPost(MerkRequest request)
{
MerkResponse respose = new MerkResponse();
if (db != null)
{
try
{
Merk model = new Merk();
model.Name = request.Name;
model.Description = request.Description;
model.Created = DateTime.Now;
model.CreatedBy = request.UserName;
model.RowStatus = true;
await db.Merk.AddAsync(model);
await db.SaveChangesAsync();
respose.Message = "Data Already saved";
respose.IsSuccess = true;
}
catch (Exception ex)
{
respose.Message = ex.ToString();
respose.IsSuccess = false;
}
}
return(respose);
}
public async Task <MerkResponse> UpdatePost(MerkRequest request)
{
MerkResponse response = new MerkResponse();
if (db != null)
{
try
{
Merk model = await db.Merk.Where(x => x.Id == request.ID).FirstAsync();
model.Modified = DateTime.Now;
model.ModifiedBy = request.UserName;
model.Name = request.Name;
model.Description = request.Description;
//Delete that warna
db.Merk.Update(model);
//Commit the transaction
await db.SaveChangesAsync();
response.Message = "Data Already Updated";
response.IsSuccess = true;
}
catch (Exception ex)
{
response.Message = ex.ToString();
response.IsSuccess = false;
}
}
return(response);
}
public async Task <MerkResponse> GetPost(long ID)
{
MerkResponse response = new MerkResponse();
if (db != null)
{
try
{
response.Model = await(from model in db.Merk
where model.Id == ID && model.RowStatus == true
select new MerkViewModel
{
ID = model.Id,
Name = model.Name,
Description = model.Description,
Created = model.Created,
CreatedBy = model.CreatedBy,
Modified = model.Modified,
ModifiedBy = model.ModifiedBy,
RowStatus = model.RowStatus
}).FirstOrDefaultAsync();
response.IsSuccess = true;
response.Message = "Load Success";
}
catch (Exception ex)
{
response.IsSuccess = false;
response.Message = ex.ToString();
}
}
return(response);
}
public async Task <MerkResponse> DeletePost([FromBody] MerkRequest model)
{
MerkResponse resp = new MerkResponse();
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);
}
return(resp = await facade.DeletePost(model.ID, username));
}
catch (Exception ex)
{
resp.IsSuccess = false;
resp.Message = ex.Message.ToString();
return(resp);
}
//long postId = model.ID;
//if (postId < 1)
//{
// return BadRequest();
//}
//try
//{
// var response = await facade.DeletePost(postId);
// return Ok(response);
//}
//catch (Exception)
//{
// return BadRequest();
//}
}
public async Task <MerkResponse> GetAllWithoutFilter()
{
MerkResponse response = new MerkResponse();
if (db != null)
{
try
{
response.ListModel = await(from model in db.Merk
where model.RowStatus == true
select new MerkViewModel
{
ID = model.Id,
Name = model.Name,
Description = model.Description,
Created = model.Created,
CreatedBy = model.CreatedBy,
Modified = model.Modified,
ModifiedBy = model.ModifiedBy,
RowStatus = model.RowStatus
}).ToListAsync();
//response.ListModel = await (from model in db.Merk
// where model.RowStatus == true
// select new MerkViewModel
// {
// ID = model.Id,
// Nama = model.Nama,
// Description = model.Description,
// Created = model.Created,
// CreatedBy = model.CreatedBy,
// Modified = model.Modified,
// ModifiedBy = model.ModifiedBy,
// RowStatus = model.RowStatus
// }).ToListAsync();
response.Message = "Success";
response.IsSuccess = true;
}
catch (Exception ex)
{
response.IsSuccess = false;
response.Message = ex.ToString();
}
}
return(response);
}
public MerkResponse GetMerkRank(string search, int draw, int startRec, int pageSize)
{
MerkResponse response = new MerkResponse();
try
{
response.ListSP_MerkRank = dep.GetMerkRank(search, draw, startRec, pageSize).Result;
response.IsSuccess = true;
response.Message = "Succes";
response.recordsTotal = response.ListSP_MerkRank[0].Total;
}
catch (Exception ex)
{
log.Error(ex);
response.IsSuccess = false;
response.Message = "Something Error wtih System";
}
return(response);
}
public MerkResponse GetMerkByKotaID(long KotaID)
{
MerkResponse response = new MerkResponse();
try
{
response.ListSP_MerkByKotaID = dep.GetMerkByKotaID(KotaID);
response.IsSuccess = true;
response.Message = "Success Get Merk";
}
catch (Exception ex)
{
log.Error(ex);
response.IsSuccess = false;
response.Message = "Something Error with System";
}
return(response);
}
public async Task <MerkResponse> DeletePost(long ID, string username)
{
MerkResponse response = new MerkResponse();
if (db != null)
{
try
{
//Find the warna for specific userprofile
var model = await db.Merk.FirstOrDefaultAsync(x => x.Id == ID);
if (model != null)
{
model.Modified = DateTime.Now;
model.ModifiedBy = username;
model.RowStatus = false;
//Delete that warna
db.Merk.Update(model);
//Commit the transaction
await db.SaveChangesAsync();
response.Message = "Data Already Deleted";
response.IsSuccess = true;
}
else
{
response.Message = "Data not Found";
response.IsSuccess = false;
}
}
catch (Exception ex)
{
response.Message = ex.ToString();
response.IsSuccess = false;
}
}
return(response);
}
public async Task <MerkResponse> GetMerkRank()
{
string search = HttpContext.Request.Query["search[value]"].ToString();
int draw = Convert.ToInt32(HttpContext.Request.Query["draw"]);
string order = HttpContext.Request.Query["order[0][column]"];
string orderDir = HttpContext.Request.Query["order[0][dir]"];
int startRec = Convert.ToInt32(HttpContext.Request.Query["start"]);
int pageSize = Convert.ToInt32(HttpContext.Request.Query["length"]);
//var models = await facade.GetAll(search, order, orderDir, startRec, pageSize, draw);
MerkResponse resp = new MerkResponse();
try
{
resp.draw = draw;
resp = facade.GetMerkRank(search, draw, startRec, pageSize);
return(resp);
}
catch (Exception ex)
{
resp.Message = ex.ToString();
return(resp);
}
}
public async Task <MerkResponse> AddPost([FromBody] MerkRequest model)
{
MerkResponse resp = new MerkResponse();
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.UpdatePost(model);
}
else
{
resp = await facade.AddPost(model);
}
return(resp);
}
catch (Exception)
{
return(resp);
}
//if (ModelState.IsValid)
//{
// MerkResponse response = new MerkResponse();
// try
// {
// if ( model.ID != 0)
// {
// response = await facade.UpdatePost(model);
// }
// else
// {
// response = await facade.AddPost(model);
// }
// return Ok(response);
// }
// catch (Exception)
// {
// return BadRequest();
// }
//}
//return BadRequest();
}
public async Task <MerkResponse> UpdateMerkRank(MerkRequest model, string username)
{
MerkResponse response = new MerkResponse();
try
{
MerkRank item = await dep.GetMerkRankByMerkID(model.ID);
if (item != null)
{
if (item.Id == model.ID)
{
item.MerkId = model.ID;
item.Rank = model.MerkRank;
item.Modified = DateTime.Now;
item.ModifiedBy = username;
item.RowStatus = true;
if (await dep.UpdateMerkRank(item) > 0)
{
response.Message = "Data Already Save!";
response.IsSuccess = true;
}
else
{
response.Message = "There is something wrong in our system";
}
}
else
{
response.Message = "Data is Duplicate with Existing Data";
response.IsSuccess = false;
}
}
else
{
MerkRank merkRank = new MerkRank();
merkRank.MerkId = model.ID;
merkRank.Rank = model.MerkRank;
merkRank.Created = DateTime.Now;
merkRank.CreatedBy = username;
merkRank.RowStatus = true;
if (await dep.AddMerkRank(merkRank) > 0)
{
response.Message = "Data Already Save!";
response.IsSuccess = true;
}
else
{
response.Message = "There is something wrong in our system";
}
}
}
catch (Exception ex)
{
log.Error(ex);
response.Message = ex.ToString();
response.IsSuccess = false;
}
return(response);
}
public async Task <MerkResponse> GetAll(string search, string order, string orderDir, int startRec, int pageSize, int draw)
{
MerkResponse response = new MerkResponse();
if (db != null)
{
try
{
var query = (from model in db.Merk
where model.RowStatus == true
select model
);
//response.ListModel = await (from model in db.Merk
// where model.RowStatus == true
// select new MerkViewModel
// {
// ID = model.Id,
// Nama = model.Nama,
// Description = model.Description,
// Created = model.Created,
// CreatedBy = model.CreatedBy,
// Modified = model.Modified,
// ModifiedBy = model.ModifiedBy,
// RowStatus = model.RowStatus
// }).ToListAsync();
int totalRecords = query.Count();
if (!string.IsNullOrEmpty(search) && !string.IsNullOrWhiteSpace(search))
{
query = query.Where(p => p.Name.ToString().ToLower().Contains(search.ToLower()) ||
p.Description.ToLower().Contains(search.ToLower()));
}
int recFilter = query.Count();
response.ListModel = await(from model in query
select new MerkViewModel
{
ID = model.Id,
Name = model.Name,
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 = "Success";
}
catch (Exception ex)
{
response.IsSuccess = false;
response.Message = ex.ToString();
}
}
return(response);
}
