public async Task <ModelBarangResponse> UpdateCategory(ModelBarang 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.ModifiedBy;
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> 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 <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 <long> Add(ModelBarang model)
{
if (db != null)
{
await db.ModelBarang.AddAsync(model);
await db.SaveChangesAsync();
return(model.Id);
}
return(0);
}
public async Task <ModelBarang> GetModelWithMerkIDModelName(ModelBarang request)
{
ModelBarang result = new ModelBarang();
try
{
result = await db.ModelBarang.Where(x => x.RowStatus == true && x.MerkId == request.MerkId && x.Name == request.Name).FirstOrDefaultAsync();
}
catch (Exception ex)
{
throw ex;
}
return(result);
}
public async Task <ModelBarang> GetModelBarangByID(long ID)
{
ModelBarang response = new ModelBarang();
try
{
if (db != null)
{
response = await db.ModelBarang.Where(x => x.RowStatus == true && x.Id == ID).FirstOrDefaultAsync();
}
}
catch (Exception ex)
{
throw ex;
}
return(response);
}
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 <long> DeleteCategory(ModelBarang model)
{
int result = 0;
if (db != null)
{
//Find the warna for specific userprofile
var modelBrg = await db.ModelBarang.FirstOrDefaultAsync(x => x.Id == model.Id);
if (modelBrg != null)
{
modelBrg.Modified = DateTime.Now;
modelBrg.ModifiedBy = model.ModifiedBy;
modelBrg.Category = model.Category;
db.ModelBarang.Update(modelBrg);
result = await db.SaveChangesAsync();
}
return(result);
}
return(result);
}
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 <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);
}
