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> 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> GetAll(string search, string order, string orderDir, int startRec, int pageSize, int draw) { ProvinsiResponse response = new ProvinsiResponse(); if (db != null) { try { var query = (from model in db.Provinsi where model.RowStatus == true select model ); 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.ListProvinsi = await(from prov in query 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 }).Skip(startRec).Take(pageSize).ToListAsync(); response.Message = "Success"; response.draw = Convert.ToInt32(draw); response.recordsTotal = totalRecords; response.recordsFiltered = recFilter; response.Message = "Success"; } catch (Exception ex) { response.Message = ex.ToString(); response.IsSuccess = false; } } return(response); }
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> GetAllForDropdown() { ProvinsiResponse response = new ProvinsiResponse(); try { response.ListProvinces = await facade.GetAllForDropdown(); response.IsSuccess = true; response.Message = "Success"; if (response == null) { return(NotFound()); } return(Ok(response)); } catch (Exception ex) { return(BadRequest(ex)); } }
public async Task <ProvinsiResponse> GetAll() { 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); } 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); //} }