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> 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 <List <SP_ModelByKotaIDMerkID> > GetModelByKotaIDMerkID(ModelBarangRequest model) { if (db != null) { try { return(await db.Set <SP_ModelByKotaIDMerkID>().FromSql("EXEC sp_ModelByKotaIDMerkID {0},{1}", model.KotaID, model.MerkID).AsNoTracking().ToListAsync()); } catch (Exception ex) { throw ex; } } return(null); }
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 <IActionResult> GetModelByKotaIDMerkID([FromBody] ModelBarangRequest model) { try { var post = await facade.GetModelByKotaIDMerkID(model); if (post == null) { return(NotFound()); } return(Ok(post)); } catch (Exception) { return(BadRequest()); } }
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> UpdatePost(ModelBarangRequest 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.UserName; model.MerkId = request.MerkID; model.Name = request.Name; model.Description = request.Description; 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> 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 <IActionResult> UpdatePost([FromBody] ModelBarangRequest model) { if (ModelState.IsValid) { try { await facade.UpdatePost(model); return(Ok()); } catch (Exception ex) { if (ex.GetType().FullName == "Microsoft.EntityFrameworkCore.DbUpdateConcurrencyException") { return(NotFound()); } return(BadRequest()); } } return(BadRequest()); }
public async Task <ModelBarangResponse> GetModelWithMerkID(ModelBarangRequest model) { return(await dep.GetModelWithMerkID(model)); }