public IActionResult GetAllBidsById([FromQuery] BarangRequest request) { long Id = request.ID;//Convert.ToInt32(HttpContext.Request.Query["id"]); int start = Convert.ToInt32(HttpContext.Request.Query["start"]); int limit = Convert.ToInt32(HttpContext.Request.Query["limit"]); int max = Convert.ToInt32(HttpContext.Request.Query["max"]); if (Id < 1) { return(BadRequest()); } try { BarangResponse post = facade.GetAllBidsById(request); post.IsSuccess = true; post.Message = "Success"; if (post == null) { return(NotFound()); } return(Ok(post)); } catch (Exception ex) { return(BadRequest(ex)); } }
public async Task <BarangResponse> DeletePost(long ID, string username) { BarangResponse response = new BarangResponse(); try { long result = 0; result = await dep.DeletePost(ID, username); if (result == 0) { response.IsSuccess = false; response.Message = "Delete Failed"; } else { response.IsSuccess = true; response.Message = "Data has been deleted"; } } catch (Exception ex) { response.IsSuccess = false; response.Message = ex.ToString(); } return(response); }
public async Task <BarangResponse> GetHargaOTR(BarangRequest request) { BarangResponse response = new BarangResponse(); try { Barang model = new Barang(); model.WarnaId = request.WarnaId; model.TypeBarangId = request.TypeBarangId; var result = await dep.GetHargaOTR(model); if (result != null) { response.Model.Id = result.Id; response.Model.HargaOtr = result.HargaOtr; response.IsSuccess = true; response.Message = "Load Harga OTR Success"; } else { response.Message = "Data dengan Warna dan Type tersebut Tidak ada"; response.IsSuccess = false; } } catch (Exception ex) { log.Error(ex); response.Message = ex.ToString(); response.IsSuccess = false; } return(response); }
public async Task <BarangResponse> GetHargaOTRTypeBarangID(BarangRequest request) { BarangResponse response = new BarangResponse(); try { Barang brg = await dep.GetHargaOTRTypeBarangID(request.TypeBarangId); response.Model = new BarangViewModel() { Id = brg.Id, Name = brg.Name, TypeBarangId = brg.TypeBarangId, HargaOtr = brg.HargaOtr }; response.IsSuccess = true; response.Message = "Success"; } catch (Exception ex) { log.Error(ex); response.IsSuccess = false; response.Message = ex.ToString(); } return(response); }
public async Task <BarangResponse> GetBarangDetail(int id) { BarangResponse resp = new BarangResponse(); BarangRequest req = new BarangRequest(); req.ID = id; resp.CarDetail = await dep.GetBarangDetail(id); resp.RelatedProducts = dep.GetRelatedProducts(id); resp.SP_GetPhotoAndWarnaByBarangIDS = await dep.GetPhotoAndWarnaByID(req); resp.ListModelForDetail = await dep.GetTypeBarangByBarangID(req); // Update Jumlah Klik Barang b = await dep.GetBarang(id); if (b != null) { if (!b.JumlahKlik.HasValue || b.JumlahKlik < 1) { b.JumlahKlik = 1; b.Modified = DateTime.Now; b.ModifiedBy = "System"; } if (await dep.UpdatePost(b)) { } } resp.IsSuccess = true; resp.Message = "Success"; return(resp); }
public async Task <IActionResult> GetBarangDetail(int Id) { if (Id < 1) { return(BadRequest()); } try { BarangResponse post = await facade.GetBarangDetail(Id); post.IsSuccess = true; post.Message = "Success"; if (post == null) { return(NotFound()); } return(Ok(post)); } catch (Exception ex) { return(BadRequest(ex)); } }
public BarangResponse GetAllBidsById(BarangRequest req) { BarangResponse resp = new BarangResponse(); resp.ListBids = dep.GetAllBidsById(req); return(resp); }
public BarangResponse GetAllForHomePage(string city) { BarangResponse resp = new BarangResponse(); resp.HighestBids = dep.GetHighestBid(city, 5); resp.LowestAsks = dep.GetLowestAsk(city, 5); resp.ListNormal = dep.GetListNormal(city, 10); return(resp); }
public async Task <IActionResult> UpdatePost([FromBody] BarangRequest request) { if (ModelState.IsValid) { try { BarangResponse response = new BarangResponse(); string bearer = Request.HttpContext.Request.Headers["Authorization"]; string token = bearer.Substring("Bearer ".Length).Trim(); string username = string.Empty; if (string.IsNullOrEmpty(token)) { response.IsSuccess = false; response.Message = "You don't have access."; return(BadRequest(response)); } username = sec.ValidateToken(token); if (username == null) { Response.HttpContext.Response.Cookies.Append("access_token", "", new CookieOptions() { Expires = DateTime.Now.AddDays(-1) }); response.IsSuccess = false; response.Message = "Your session was expired, please re-login."; return(BadRequest(response)); } var result = await facade.UpdatePost(request, username); return(Ok(result)); } catch (Exception ex) { if (ex.GetType().FullName == "Microsoft.EntityFrameworkCore.DbUpdateConcurrencyException") { return(NotFound()); } return(BadRequest()); } } return(BadRequest()); }
public async Task <IActionResult> AddPost([FromBody] BarangRequest model) { BarangResponse result = new BarangResponse(); if (ModelState.IsValid) { try { string bearer = Request.HttpContext.Request.Headers["Authorization"]; string token = bearer.Substring("Bearer ".Length).Trim(); string username = string.Empty; if (string.IsNullOrEmpty(token)) { result.IsSuccess = false; result.Message = "You don't have access."; return(BadRequest(result)); } username = sec.ValidateToken(token); if (username == null) { Response.HttpContext.Response.Cookies.Append("access_token", "", new CookieOptions() { Expires = DateTime.Now.AddDays(-1) }); result.IsSuccess = false; result.Message = "Your session was expired, please re-login."; return(BadRequest(result)); } if (model.ID > 0) { result = await facade.UpdatePost(model, username); } else { result = await facade.AddPost(model, username); } return(Ok(result)); } catch (Exception) { return(BadRequest()); } } 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> GetHargaOTRTypeBarangID([FromBody] BarangRequest request) { BarangResponse result = new BarangResponse(); if (ModelState.IsValid) { try { result = await facade.GetHargaOTRTypeBarangID(request); return(Ok(result)); } catch (Exception) { return(BadRequest()); } } return(BadRequest()); }
public IActionResult GetAllForHomePage([FromQuery] string city) { BarangResponse respon = new BarangResponse(); try { respon = facade.GetAllForHomePage(city); respon.IsSuccess = true; respon.Message = "Success"; return(Ok(respon)); } catch (Exception ex) { respon.Message = ex.Message; respon.IsSuccess = false; return(BadRequest(respon)); } }
public async Task <BarangResponse> UpdateImageBarang(BarangRequest request, string username) { BarangResponse response = new BarangResponse(); try { Barang model = new Barang() { Id = request.ID }; List <Barang> ListBarang = await dep.GetAllBarangSameTypeAndKota(model); foreach (Barang brg in ListBarang) { brg.PhotoPath = request.PhotoPath; brg.Modified = DateTime.Now; brg.ModifiedBy = username; } bool result = await dep.UpdateMany(ListBarang); 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 <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 <BarangResponse> GetBarangByHomeParameter(BarangRequest request) { BarangResponse response = new BarangResponse(); try { response.sp_GetBarangByHomeParameters = await dep.GetBarangByHomeParameter(request); response.SP_GetBarangByHomeParameterCount = await dep.GetBarangByHomeParameterCount(request); response.Total = response.SP_GetBarangByHomeParameterCount.total; response.IsSuccess = true; response.Message = "Success"; } catch (Exception ex) { response.IsSuccess = false; response.Message = ex.ToString(); } return(response); }
public async Task <BarangResponse> SubmitUpload(string fileName) { BarangResponse resp = new BarangResponse(); 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); } resp = await facade.SubmitUpload(fileName, username); return(resp); } catch (Exception) { return(resp); } }
public async Task <BarangResponse> SubmitUpload(string fileName, string username) { BarangResponse response = new BarangResponse(); try { string folderName = Path.Combine("Resources", "UploadDocs"); string filePath = Path.Combine(Directory.GetCurrentDirectory(), folderName); string sheetName = "Master"; DataTable dt = new DataTable(); string dbPath = Path.Combine(folderName, fileName); List <Kota> ListKota = await da_kota.GetAll(); List <Merk> ListMerk = await da_merk.GetAllMerk(); List <ModelBarang> ListModel = await da_model.GetAllModel(); List <TypeBarang> ListType = await da_type.GetAllType(); List <Warna> ListWarna = await da_warna.GetWarna(); List <Barang> ListBarang = await dep.GetAllBarang(); using (ExcelPackage pck = new ExcelPackage()) { using (FileStream stream = new FileStream(dbPath, FileMode.Open)) { pck.Load(stream); ExcelWorksheet oSheet = pck.Workbook.Worksheets[sheetName]; dt = WorksheetToDataTable(oSheet); for (int i = 0; i < dt.Rows.Count; i++) { long KotaID = 0; long MerkID = 0; long ModelID = 0; long TypeID = 0; long WarnaID = 0; long BarangID = 0; long NegoBarangID = 0; errMerk = dt.Rows[i].ItemArray.GetValue(1).ToString(); errModel = dt.Rows[i].ItemArray.GetValue(2).ToString(); errType = dt.Rows[i].ItemArray.GetValue(3).ToString(); errWarna = dt.Rows[i].ItemArray.GetValue(4).ToString(); errBarang = dt.Rows[i].ItemArray.GetValue(5).ToString(); errOTR = dt.Rows[i].ItemArray.GetValue(6).ToString(); errHargaFinal = dt.Rows[i].ItemArray.GetValue(8).ToString(); #region Insert To Kota string Kota = dt.Rows[i].ItemArray.GetValue(0).ToString(); if (!ListKota.Where(x => x.Name.ToLower() == Kota.ToLower()).Any()) { Kota k = new Kota(); k.Name = Kota; k.Description = Kota; k.RowStatus = true; k.Created = DateTime.Now; k.CreatedBy = username; KotaID = da_kota.AddPost(k).Result; ListKota.Add(k); } else { KotaID = ListKota.Where(x => x.Name.ToLower() == Kota.ToLower() && x.RowStatus == true).First().Id; } #endregion #region Insert To Merk string Merk = dt.Rows[i].ItemArray.GetValue(1).ToString(); if (!ListMerk.Where(x => x.Name.ToLower() == Merk.ToLower()).Any()) { Merk m = new Merk(); m.Name = Merk; m.Description = Merk; m.RowStatus = true; m.Created = DateTime.Now; m.CreatedBy = username; MerkID = da_merk.Add(m).Result; ListMerk.Add(m); } else { MerkID = ListMerk.Where(x => x.Name.ToLower() == Merk.ToLower() && x.RowStatus == true).First().Id; } #endregion #region Insert to ModelBarang string Model = dt.Rows[i].ItemArray.GetValue(2).ToString(); if (!ListModel.Where(x => x.Name.ToLower() == Model.ToLower()).Any()) { ModelBarang mb = new ModelBarang(); mb.MerkId = MerkID; mb.Name = Model; mb.Description = Model; mb.RowStatus = true; mb.Created = DateTime.Now; mb.Createdby = username; ModelID = da_model.Add(mb).Result; ListModel.Add(mb); } else { ModelID = ListModel.Where(x => x.Name.ToLower() == Model.ToLower() && x.RowStatus == true).First().Id; } #endregion #region Insert to TypeBarang string Type = dt.Rows[i].ItemArray.GetValue(4).ToString(); if (!ListType.Where(x => x.Name.ToLower() == Type.ToLower()).Any()) { TypeBarang tb = new TypeBarang(); tb.Name = Type; tb.ModelBarangId = ModelID; tb.Description = Type; tb.RowStatus = true; tb.Created = DateTime.Now; tb.CreatedBy = username; TypeID = da_type.Add(tb).Result; ListType.Add(tb); } else { TypeID = ListType.Where(x => x.RowStatus == true && x.Name.ToLower() == Type.ToLower()).First().Id; } #endregion #region Insert to Warna string Warna = dt.Rows[i].ItemArray.GetValue(6).ToString(); if (!ListWarna.Where(x => x.Name.ToLower() == Warna.ToLower()).Any()) { Warna w = new Warna(); w.Name = Warna; w.Description = Warna; w.Sapcode = dt.Rows[i].ItemArray.GetValue(5).ToString(); w.RowStatus = true; w.Created = DateTime.Now; w.CreatedBy = username; WarnaID = da_warna.Add(w).Result; ListWarna.Add(w); } else { WarnaID = ListWarna.Where(x => x.RowStatus == true && x.Name.ToLower() == Warna.ToLower()).First().Id; } #endregion string OTRstrRaw = dt.Rows[i].ItemArray.GetValue(8).ToString(); string OTRstr = OTRstrRaw.Contains('.') ? OTRstrRaw.Substring(0, OTRstrRaw.LastIndexOf('.')) : OTRstrRaw; string DiscstrRaw = dt.Rows[i].ItemArray.GetValue(9).ToString(); string Discstr = DiscstrRaw.Contains('.') ? DiscstrRaw.Substring(0, DiscstrRaw.LastIndexOf('.')) : DiscstrRaw; string FinalRaw = dt.Rows[i].ItemArray.GetValue(10).ToString(); string Finalstr = FinalRaw.Contains('.') ? FinalRaw.Substring(0, FinalRaw.LastIndexOf('.')) : FinalRaw; string YearstrRaw = dt.Rows[i].ItemArray.GetValue(7).ToString(); string Yearstr = YearstrRaw.Contains('.') ? YearstrRaw.Substring(0, OTRstrRaw.LastIndexOf('.')) : YearstrRaw; long OTR = Convert.ToInt64(OTRstr); long Discount = Convert.ToInt64(Discstr); long HargaFinal = Convert.ToInt64(Finalstr); int Year = Convert.ToInt32(Yearstr); #region Insert to Barang Barang brg = new Barang() { RowStatus = true, Created = DateTime.Now, CreatedBy = username, HargaOtr = OTR, Name = Type, WarnaId = WarnaID, TypeBarangId = TypeID, KotaId = KotaID, Year = Year, KodeType = dt.Rows[i].ItemArray.GetValue(3).ToString() }; BarangID = dep.AddPost(brg).Result; #endregion #region Insert to NegoBarang NegoBarang nb = new NegoBarang() { RowStatus = true, BarangId = BarangID, UserProfileId = 3, TypePenawaran = "ask", Harga = HargaFinal, Created = DateTime.Now, CreatedBy = username }; NegoBarangID = da_nego.AddPost(nb).Result; #endregion } response.IsSuccess = true; response.Message = "Success"; } } } catch (Exception ex) { log.Error(ex); string Ket = string.Format("Merk={0}, Model={1}, Type={2}, Warna={3}, Barang={4}, HargaOTR={5}, Harga Final={6}, Error={7} ", errMerk, errModel, errType, errWarna, errBarang, errOTR, errHargaFinal, ex.ToString()); response.Message = Ket;// ex.ToString(); response.IsSuccess = false; } return(response); }
public async Task <BarangResponse> GetAll(string search, string order, string orderDir, int startRec, int pageSize, int draw) { BarangResponse response = new BarangResponse(); try { if (db != null) { var query = (from brg in db.Barang join warna in db.Warna on brg.WarnaId equals warna.Id join type in db.TypeBarang on brg.TypeBarangId equals type.Id join model in db.ModelBarang on type.ModelBarangId equals model.Id join merk in db.Merk on model.MerkId equals merk.Id join kota in db.Kota on brg.KotaId equals kota.Id where merk.RowStatus == true && model.RowStatus == true select new { brg.Id, brg.Name, brg.HargaOtr, namaType = type.Name, namaModelBarang = model.Name, NamaMerk = merk.Name, brg.TypeBarangId, type.ModelBarangId, model.MerkId, brg.WarnaId, namaWarna = warna.Name, brg.Created, brg.CreatedBy, brg.Modified, brg.ModifiedBy, brg.RowStatus, brg.PhotoPath, kotaID = kota.Id, brg.Year } ); int totalRecords = query.Count(); if (!string.IsNullOrEmpty(search) && !string.IsNullOrWhiteSpace(search)) { query = query.Where(p => p.Name.ToString().ToLower().Contains(search.ToLower()) || p.namaType.ToString().ToLower().Contains(search.ToLower()) || p.namaModelBarang.ToString().ToLower().Contains(search.ToLower()) || p.namaWarna.ToString().ToLower().Contains(search.ToLower()) || p.NamaMerk.ToLower().Contains(search.ToLower()) || p.HargaOtr.ToString().ToLower().Contains(search.ToLower()) || p.Year.ToString().ToLower().Contains(search.ToLower()) ); } int recFilter = query.Count(); response.ListModel = await(from model in query where model.RowStatus == true select new BarangViewModel { Id = model.Id, Name = model.Name, HargaOtr = model.HargaOtr, NamaTypeBarang = model.namaType, TypeBarangId = model.TypeBarangId, NamaModelBarang = model.namaModelBarang, ModelBarangID = model.ModelBarangId, NamaMerk = model.NamaMerk, MerkBarangID = model.MerkId, NamaWarna = model.namaWarna, PhotoPath = model.PhotoPath, WarnaId = model.WarnaId, Created = model.Created, CreatedBy = model.CreatedBy, Modified = model.Modified, ModifiedBy = model.ModifiedBy, RowStatus = model.RowStatus, KotaID = model.kotaID, Year = model.Year }).Skip(startRec).Take(pageSize).ToListAsync(); response.draw = Convert.ToInt32(draw); response.recordsTotal = totalRecords; response.recordsFiltered = recFilter; 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); }