public async Task <KotaResponse> DeletePost(KotaRequest request) { KotaResponse response = new KotaResponse(); if (db != null) { try { Kota model = await db.Kota.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 <KotaResponse> AddPost(KotaRequest req) { KotaResponse response = new KotaResponse(); try { Kota model = new Kota(); model.ProvinsiId = req.ProvinsiID; model.Name = req.Name; model.Description = req.Description; model.Created = DateTime.Now; model.CreatedBy = req.UserName; model.RowStatus = true; await dep.AddPost(model); response.Message = "Success"; response.IsSuccess = true; } catch (Exception) { response.Message = "Failed"; response.IsSuccess = false; } return(response); }
public async Task <KotaResponse> GetPost(KotaRequest req) { KotaResponse response = new KotaResponse(); var model = await dep.GetPost(req); if (model == null) { return(null); } return(response); }
public async Task <KotaResponse> DeletePost(KotaRequest req) { KotaResponse resp = new KotaResponse(); 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 <KotaResponse> GetAllWithoutFilter() { KotaResponse response = new KotaResponse(); var listKota = await dep.GetAllWithoutFilter(); response.ListKota = (from kota in listKota select new KotaViewModel { ID = kota.Id, Name = kota.Name }).ToList(); return(response); }
public async Task <IActionResult> GetAllForDropdown(int ProvinsiID) { KotaResponse response = new KotaResponse(); try { response.ListKotas = await facade.GetAllForDropdown(ProvinsiID); response.IsSuccess = true; response.Message = "Success"; } catch (Exception ex) { response.IsSuccess = false; response.Message = ex.ToString(); return(BadRequest(ex)); } return(Ok(response)); }
public async Task <KotaResponse> UpdatePost(KotaRequest req) { KotaResponse response = new KotaResponse(); try { Kota model = new Kota(); model = await dep.GetPost(req); model.ProvinsiId = req.ProvinsiID; model.Name = req.Name; model.Description = req.Description; model.Modified = DateTime.Now; model.ModifiedBy = req.UserName; model.RowStatus = true; await dep.UpdatePost(model); var result = await dep.UpdatePost(model); if (result) { response.Message = "Success"; response.IsSuccess = true; } else { response.Message = "Failed"; response.IsSuccess = false; } } catch (Exception ex) { log.Error(ex); response.Message = "Failed"; response.IsSuccess = false; } return(response); }
public async Task <KotaResponse> GetAll() { KotaResponse resp = new KotaResponse(); 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); } 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"]); resp = await facade.GetAll(search, order, orderDir, startRec, pageSize, draw); return(resp); } catch (Exception ex) { resp.IsSuccess = false; resp.Message = ex.Message.ToString(); return(resp); } //try //{ // 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); // if (models == null) // { // return NotFound(); // } // return Ok(models); //} //catch (Exception ex) //{ // return BadRequest(ex); //} }
public async Task <KotaResponse> GetAll(string search, string order, string orderDir, int startRec, int pageSize, int draw) { KotaResponse response = new KotaResponse(); if (db != null) { try { var query = (from kota in db.Kota join provinsi in db.Provinsi on kota.ProvinsiId equals provinsi.Id where kota.RowStatus == true && provinsi.RowStatus == true select new { ID = kota.Id, Name = kota.Name, kota.Description, ProvinsiID = kota.ProvinsiId, ProvinsiName = provinsi.Name } ); int totalRecords = query.Count(); if (!string.IsNullOrEmpty(search) && !string.IsNullOrWhiteSpace(search)) { query = query.Where(p => p.Name.ToString().ToLower().Contains(search.ToLower()) || p.ProvinsiName.ToLower().Contains(search.ToLower()) || p.Description.ToLower().Contains(search.ToLower())); } int recFilter = query.Count(); response.ListKota = await(from model in query select new KotaViewModel { ID = model.ID, Name = model.Name, Description = model.Description, ProvinsiID = model.ProvinsiID, ProvinsiName = model.ProvinsiName, }).Skip(startRec).Take(pageSize).ToListAsync(); //response.ListProvinsi = await (from prov in db.Provinsi // where prov.RowStatus == true // select new ProvinsiViewModel // { // ID = prov.Id, // Nama = prov.Nama, // Created = prov.Created, // CreatedBy = prov.CreatedBy, // Description = prov.Description, // Modified = prov.Modified, // ModifiedBy = prov.ModifiedBy, // RowStatus = prov.RowStatus // }).ToListAsync(); response.Message = "Success"; response.draw = Convert.ToInt32(draw); response.recordsTotal = totalRecords; response.recordsFiltered = recFilter; response.IsSuccess = true; } catch (Exception ex) { throw ex; } } return(response); }