public int sppInsert(spp sppData)
{
//spp sppRequest = (spp)convertJsonToType(sppRequestJson, typeof(Model.spp));
sppData.verification_date = DateTime.Now;
sppData.status = "Sukses";
mspbu.spps.Add(sppData);
return mspbu.SaveChanges();
//int rowAffected = mspbu.SaveChanges();
//return rowAffected + " row inserted";
}
public int sppUpdate(spp sppData)
{
//spp sppRequest = (spp)convertJsonToType(sppRequestJson, typeof(Model.spp));
spp sppFound = mspbu.spps.Find(sppData.Id);
if (sppFound != null)
{
sppFound.name = (sppData.name != null) ? sppData.name : sppFound.name;
sppFound.address = (sppData.address != null) ? sppData.address : sppFound.address;
sppFound.police_no = (sppData.police_no != null) ? sppData.police_no : sppFound.police_no;
sppFound.shipment_no = (sppData.shipment_no != null) ? sppData.shipment_no : sppFound.shipment_no;
sppFound.volume = (sppData.volume != null) ? sppData.volume : sppFound.volume;
sppFound.dens_temp = (sppData.dens_temp != null) ? sppData.dens_temp : sppFound.dens_temp;
sppFound.buyer = (sppData.buyer != null) ? sppData.buyer : sppFound.buyer;
sppFound.product = (sppData.product != null) ? sppData.product : sppFound.product;
sppFound.print_date = (sppData.print_date != null) ? sppData.print_date : sppFound.print_date;
sppFound.verification_date = (sppData.verification_date != null) ? sppData.verification_date : sppFound.verification_date;
sppFound.status = (sppData.status != null) ? sppData.status : sppFound.status;
mspbu.Entry(sppFound).State = EntityState.Modified;
return mspbu.SaveChanges();
}
return -1;
//int rowAffected = mspbu.SaveChanges();
//return rowAffected + " row updated";
}
public List<spp> sppGetWhere(spp sppData)
{
List<spp> sppFound = mspbu.spps.ToList();
if (sppData.name != null)
sppFound = sppFound.Where(s => s.name == sppData.name).ToList();
if (sppData.address != null)
sppFound = sppFound.Where(s => s.address == sppData.address).ToList();
if (sppData.police_no != null)
sppFound = sppFound.Where(s => s.police_no == sppData.police_no).ToList();
if (sppData.shipment_no != null)
sppFound = sppFound.Where(s => s.shipment_no == sppData.shipment_no).ToList();
if (sppData.volume != null)
sppFound = sppFound.Where(s => s.volume == sppData.volume).ToList();
if (sppData.dens_temp != null)
sppFound = sppFound.Where(s => s.dens_temp == sppData.dens_temp).ToList();
if (sppData.buyer != null)
sppFound = sppFound.Where(s => s.buyer == sppData.buyer).ToList();
if (sppData.product != null)
sppFound = sppFound.Where(s => s.product == sppData.product).ToList();
if (sppData.print_date != null)
sppFound = sppFound.Where(s => s.print_date == sppData.print_date).ToList();
if (sppData.verification_date != null)
sppFound = sppFound.Where(s => s.verification_date == sppData.verification_date).ToList();
if (sppData.status != null)
sppFound = sppFound.Where(s => s.status == sppData.status).ToList();
return sppFound;
}