//public async Task<TypeBarangResponse> GetTypeByName(TypeBarangRequest request) //{ // TypeBarangResponse response = new TypeBarangResponse(); // return response; //} public async Task <TypeBarangResponse> AddPost(TypeBarangRequest request) { TypeBarangResponse response = new TypeBarangResponse(); try { TypeBarang req = new TypeBarang(); req.Name = request.Name; TypeBarang model = await dep.GetTypeByName(req); if (model != null) { response.IsSuccess = false; response.Message = "Data Duplicate with Existing Data"; } else { req.ModelBarangId = request.ModelBarangID; req.Name = request.Name; req.Description = request.Description; req.Created = DateTime.Now; req.CreatedBy = request.UserName; req.RowStatus = true; response = await dep.AddPost(req); } } catch (Exception ex) { log.Error(ex); response.Message = ex.Message.ToString(); response.IsSuccess = false; } return(response); }
public async Task <TypeBarangResponse> GetPost(TypeBarangRequest request) { TypeBarangResponse response = new TypeBarangResponse(); try { if (db != null) { response.Model = await(from model in db.TypeBarang where model.Id == request.ID && model.RowStatus == true select new TypeBarangViewModel { ID = model.Id, Name = model.Name, ModelBarangID = model.ModelBarangId, Description = model.Description, Created = model.Created, CreatedBy = model.CreatedBy, Modified = model.Modified, ModifiedBy = model.ModifiedBy, RowStatus = model.RowStatus }).FirstOrDefaultAsync(); if (response.Model == null) { response.IsSuccess = true; response.Message = "Data Not Found"; } response.IsSuccess = true; response.Message = "Load Success"; } else { response.Message = "Opps, Something Error with System Righ Now !"; response.IsSuccess = false; } } catch (Exception ex) { response.Message = ex.ToString(); response.IsSuccess = false; //return await (from model in db.TypeBarang // where model.Id == ID && model.RowStatus == true // select new TypeBarangViewModel // { // ID = model.Id, // Nama = model.Name, // ModelBarangID = model.ModelBarangId, // Description = model.Description, // Created = model.Created, // CreatedBy = model.CreatedBy, // Modified = model.Modified, // ModifiedBy = model.ModifiedBy, // RowStatus = model.RowStatus // }).FirstOrDefaultAsync(); } return(response); }
public async Task <TypeBarangResponse> DeletePost([FromBody] TypeBarangRequest request) { TypeBarangResponse resp = new TypeBarangResponse(); 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); } request.UserName = username; return(resp = await facade.DeletePost(request));; } catch (Exception ex) { resp.IsSuccess = false; resp.Message = ex.Message.ToString(); return(resp); } //try //{ // var result = await facade.DeletePost(request); // return Ok(result); //} //catch (Exception) //{ // return BadRequest(); //} }
public async Task <BarangResponse> UpdatePost(BarangRequest request, string username) { BarangResponse response = new BarangResponse(); try { TypeBarangRequest typeRequest = new TypeBarangRequest(); typeRequest.ID = request.TypeBarangId; var getTYpe = da_type.GetPost(typeRequest).Result; Barang model = new Barang(); model.Id = request.ID; model.HargaOtr = request.HargaOtr; model.Name = getTYpe.Model.Name; model.WarnaId = request.WarnaId; model.TypeBarangId = request.TypeBarangId; model.KotaId = request.KotaID.Value; //model.PhotoPath = request.PhotoPath; model.Year = request.Year.Value; model.Modified = DateTime.Now; model.ModifiedBy = username; bool result = await dep.UpdatePost(model); if (result) { response.Message = "Data Already Saved"; response.IsSuccess = true; } else { response.Message = "Update Failed"; response.IsSuccess = false; } } catch (Exception ex) { log.Error(ex); response.Message = ex.ToString(); response.IsSuccess = false; } return(response); }
public async Task <IActionResult> GetPost([FromBody] TypeBarangRequest request) { try { var post = await facade.GetPost(request); if (post == null) { return(NotFound()); } return(Ok(post)); } catch (Exception) { return(BadRequest()); } }
public async Task <IActionResult> GetAllWithModelID([FromBody] TypeBarangRequest request) { try { var models = await facade.GetAllWithModelID(request); if (models == null) { return(NotFound()); } return(Ok(models)); } catch (Exception ex) { return(BadRequest(ex)); } }
public async Task <TypeBarangResponse> DeletePost(TypeBarangRequest request) { TypeBarangResponse response = new TypeBarangResponse(); try { if (db != null) { //Find the warna for specific userprofile TypeBarang model = await db.TypeBarang.FirstOrDefaultAsync(x => x.Id == request.ID); if (model != null) { model.Modified = DateTime.Now; model.ModifiedBy = request.UserName; model.RowStatus = false; //Commit the transaction await db.SaveChangesAsync(); response.Message = "Data Already Saved"; response.IsSuccess = true; } else { response.Message = "Data Not Found"; response.IsSuccess = false; } } 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 <TypeBarangResponse> GetTypeByKotaIDMerkIDModelID(TypeBarangRequest request) { TypeBarangResponse response = new TypeBarangResponse(); try { response.ListSP__TypeByKotaIDMerkIDModelID = await dep.GetTypeByKotaIDMerkIDModelID(request); response.Message = "Success"; response.IsSuccess = true; } catch (Exception ex) { log.Error(ex); response.IsSuccess = false; response.Message = "Failed"; } return(response); }
public async Task <BarangResponse> AddPost(BarangRequest request, string email) { BarangResponse response = new BarangResponse(); try { TypeBarangRequest typeRequest = new TypeBarangRequest(); typeRequest.ID = request.TypeBarangId; var getTYpe = da_type.GetPost(typeRequest).Result; Barang model = new Barang(); model.HargaOtr = request.HargaOtr; model.Name = getTYpe.Model.Name; model.WarnaId = request.WarnaId; model.PhotoPath = request.PhotoPath; model.TypeBarangId = request.TypeBarangId; model.Created = DateTime.Now; model.CreatedBy = email; model.RowStatus = true; model.KotaId = request.KotaID.Value; var postId = await dep.AddPost(model); if (postId > 0) { response.Message = "Data Already Saved"; response.IsSuccess = true; } else { response.Message = "Save Failed"; response.IsSuccess = false; } } catch (Exception ex) { response.Message = ex.ToString(); response.IsSuccess = false; } return(response); }
public async Task <TypeBarangResponse> UpdatePost(TypeBarangRequest request) { TypeBarangResponse response = new TypeBarangResponse(); try { if (db != null) { TypeBarang model = await db.TypeBarang.Where(x => x.RowStatus == true && x.Id == request.ID).FirstAsync(); model.ModelBarangId = request.ModelBarangID; model.Name = request.Name; model.Description = request.Description; model.Modified = DateTime.Now; model.ModifiedBy = request.CreatedBy; db.TypeBarang.Update(model); //Commit the transaction await db.SaveChangesAsync(); response.Message = "Data Already Saved"; 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 <IActionResult> GetTypeByKotaIDMerkIDModelID([FromBody] TypeBarangRequest request) { if (ModelState.IsValid) { try { var result = await facade.GetTypeByKotaIDMerkIDModelID(request); return(Ok(result)); } catch (Exception ex) { if (ex.GetType().FullName == "Microsoft.EntityFrameworkCore.DbUpdateConcurrencyException") { return(NotFound()); } return(BadRequest()); } } return(BadRequest()); }
public async Task <TypeBarangResponse> GetPost(TypeBarangRequest request) { return(await dep.GetPost(request)); }
public async Task <TypeBarangResponse> GetAllWithModelID(TypeBarangRequest request) { return(await dep.GetAllWithModelID(request)); }
public async Task <List <SP_TypeByKotaIDMerkIDModelID> > GetTypeByKotaIDMerkIDModelID(TypeBarangRequest request) { if (db != null) { try { return(await db.Set <SP_TypeByKotaIDMerkIDModelID>().FromSql("EXEC sp_TypeByKotaIDMerkIDModelID {0},{1},{2}", request.KotaID, request.MerkID, request.ModelBarangID).AsNoTracking().ToListAsync()); } catch (Exception ex) { throw ex; } } return(null); }