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);
}
