public void EditSupply_duphong(String supplyid, int quantity)
{
QuangHanhManufacturingEntities db = new QuangHanhManufacturingEntities();
RepairRegularly1 duphong = db.RepairRegularly1.Where(x => x.supply_id == supplyid).FirstOrDefault();
if (duphong != null)
{
duphong.quantity -= quantity;
db.Entry(duphong).State = EntityState.Modified;
}
db.SaveChanges();
}
private void EditSupply_duphong(string oldEquipmentId, string oldSupplyid, int oldQuantity, string newEquipmentId, string newSupplyid, int newQuantity)
{
//find old supplies by device.
QuangHanhManufacturingEntities db = new QuangHanhManufacturingEntities();
using (DbContextTransaction transaction = db.Database.BeginTransaction())
{
try
{
//if equipmentId and supplyId doesn't change after editing.
if (oldEquipmentId == newEquipmentId && oldSupplyid == newSupplyid)
{
RepairRegularly1 duphong = db.RepairRegularly1.Where(x => (x.supply_id == newSupplyid && x.equipment_id == newEquipmentId)).FirstOrDefault();
if (duphong != null)
{
duphong.quantity += oldQuantity;
duphong.quantity -= newQuantity;
db.Entry(duphong).State = EntityState.Modified;
}
}
else
{
//update quantity of old and new supplies remaining by each eqID.
RepairRegularly1 oldRecord = db.RepairRegularly1.Where(x => (x.supply_id == oldSupplyid && x.equipment_id == oldEquipmentId)).FirstOrDefault();
RepairRegularly1 newRecord = db.RepairRegularly1.Where(x => (x.supply_id == newSupplyid && x.equipment_id == newEquipmentId)).FirstOrDefault();
oldRecord.quantity += oldQuantity;
// if new doesn't exist => create new with quantity = -newQuantity
if (newRecord == null)
{
RepairRegularly1 sp = new RepairRegularly1()
{
supply_id = newSupplyid,
equipment_id = newEquipmentId,
quantity = -newQuantity
};
db.RepairRegularly1.Add(sp);
}
else
{
newRecord.quantity -= newQuantity;
}
}
db.SaveChanges();
transaction.Commit();
}
catch (Exception)
{
transaction.Rollback();
}
}
}
private void AddSupply_duphong(string newEquipmentId, string newSupplyid, int newQuantity)
{
//find old supplies by device.
QuangHanhManufacturingEntities db = new QuangHanhManufacturingEntities();
using (DbContextTransaction transaction = db.Database.BeginTransaction())
{
try
{
RepairRegularly1 duphong = db.RepairRegularly1.Where(x => (x.supply_id == newSupplyid && x.equipment_id == newEquipmentId)).FirstOrDefault();
//if existed
if (duphong != null)
{
duphong.quantity -= newQuantity;
db.Entry(duphong).State = EntityState.Modified;
}
//if doesn't exist before
else
{
RepairRegularly1 sp = new RepairRegularly1()
{
supply_id = newSupplyid,
equipment_id = newEquipmentId,
quantity = -newQuantity
};
db.RepairRegularly1.Add(sp);
}
db.SaveChanges();
transaction.Commit();
}
catch (Exception)
{
transaction.Rollback();
}
}
}
