private void detach_PartSafeties(PartSafety entity)
{
this.SendPropertyChanging();
entity.PartInfo = null;
}
protected void ProcessSafety(long piId)
{
long wId;
foreach (GridViewRow row in gvSafeties.Rows)
{
TextBox txt = (TextBox)row.FindControl("txtSafetyQuantity");
long.TryParse(txt.Attributes["WHID"], out wId);
PartSafety ps = PartInfoDAO.GetPartSafety(piId, wId);
if (ps == null && (wId > 0) && (piId > 0))
{
ps = new PartSafety() { PartInfoId = piId, WarehouseId = wId };
PartInfoDAO.PartDC.PartSafeties.InsertOnSubmit(ps);
}
if (ps != null)
{
int qty;
int.TryParse(txt.Text, out qty);
ps.SafetyQuantity = qty;
}
}
}
private void attach_PartSafeties(PartSafety entity)
{
this.SendPropertyChanging();
entity.Warehouse = this;
}
public PartSafetySetting(PartSafety ps)
{
this.PartCode = ps.PartInfo.PartCode;
this.PartInfo = ps.PartInfo;
this.PartInfoId = ps.PartInfoId;
this.SafetyQuantity = ps.SafetyQuantity;
this.CurrentStock = ps.CurrentStock;
this.Warehouse = ps.Warehouse;
this.WarehouseId = ps.WarehouseId;
}
public static PartSafety CreatePartSafety(PartInfo pInfo, long warehouseId, int quantity, int safeQty)
{
//Warehouse wh = PartDC.ActiveWarehouses.SingleOrDefault(w => w.WarehouseId == warehouseId);
//if (wh == null) return null;
//PartInfo pi = PartDC.PartInfos.SingleOrDefault(p => p.PartCode == partCode && p.DealerCode == wh.DealerCode);
//if (pi == null) return null;
var db = DCFactory.GetDataContext<PartDataContext>();
PartSafety ps = null;
if (pInfo.PartInfoId != 0) ps = db.PartSafeties.SingleOrDefault(p => p.PartInfoId == pInfo.PartInfoId);
if (ps != null)
ps.CurrentStock += quantity;
else
{
ps = new PartSafety
{
CurrentStock = quantity,
SafetyQuantity = safeQty,
WarehouseId = warehouseId
};
db.PartSafeties.InsertOnSubmit(ps);
}
return ps;
}
public PartSafetySetting(PartSafety ps, string vName, string eName)
: this(ps)
{
this.EnglishName = eName;
this.VietNameName = vName;
}
/// <summary>
/// Inc Current Stock n Create "part safety" if needed
/// </summary>
/// <param name="pi"></param>
/// <param name="Quantity"></param>
/// <param name="warehouseId"></param>
public static void IncCurrentStock(PartInfo pi, int Quantity, long warehouseId)
{
var ps = PartInfoDAO.GetPartSafety(pi.PartInfoId, warehouseId);
if (ps == null)
{
var db = new PartDataContext(); // must create another data context
ps = new PartSafety
{
WarehouseId = warehouseId,
PartInfoId = pi.PartInfoId,
CurrentStock = 0,
SafetyQuantity = 0
};
db.PartSafeties.InsertOnSubmit(ps);
db.SubmitChanges();
//db.Dispose();
}
ps = PartInfoDAO.GetPartSafety(pi.PartInfoId, warehouseId);
if (ps != null)
{
ps.CurrentStock += Quantity;
if (ps.CurrentStock < 0)
{
throw new Exception(string.Format("On hand quantity of \"{0}\" will be negative!", pi.PartCode));
}
}
else throw new Exception(string.Format("Cannot create safatyStock to inc current stock for {0}!", pi.PartCode));
}
protected void txtSafetyQuantity_OnTextChanged(object sender, EventArgs e)
{
try
{
TextBox txt = (TextBox)sender;
long piId, wId;
long.TryParse(txt.Attributes["WHID"], out wId);
long.TryParse(txt.Attributes["PIID"], out piId);
PartSafety ps = PartInfoDAO.GetPartSafety(piId, wId);
if (ps == null && (wId > 0) && (piId > 0))
{
ps = new PartSafety() { PartInfoId = piId, WarehouseId = wId };
PartInfoDAO.PartDC.PartSafeties.InsertOnSubmit(ps);
}
if (ps != null)
{
int qty;
int.TryParse(txt.Text, out qty);
ps.SafetyQuantity = qty;
}
}
catch (Exception ex) { AddErrorMsg(ex.Message); }
}
private void detach_PartSafeties(PartSafety entity)
{
this.SendPropertyChanging("PartSafeties");
entity.Warehouse = null;
}
private void attach_PartSafeties(PartSafety entity)
{
this.SendPropertyChanging("PartSafeties");
entity.PartInfo = this;
}