// --
public bool CancelConfirmItem(StockInEquipment o, Boolean isSaveDraff, params System.Linq.Expressions.Expression <Func <StockInEquipment, object> >[] properties)
{
using (TransactionScope transaction = new TransactionScope())
{
try
{
StockInEquipment item = db.StockInEquipments.Where(i => i.ID == o.ID || i.OrderCode == o.OrderCode).SingleOrDefault();
if (o.StockInEquipmentDetails != null)
{
ITInventoryManager itInManager = new ITInventoryManager();
foreach (StockInEquipmentDetail i in o.StockInEquipmentDetails)
{
itInManager.AddItemToWarehouse(i.ItemDetailID, i.UnitID, i.Quantity.Value, this.db);
}
}
item.Status = (int)OrderStatus.DRAFT;
db.SaveChanges();
transaction.Complete();
return(true);
}
catch
{
transaction.Dispose();
return(false);
}
}
}
/// <summary>
/// Insert Item:
/// DeviceRegistration
/// if OrderStatus was Save end Send then Insert WFMain to DB
/// </summary>
/// <param name="o"></param>
/// <returns></returns>
public string InsertItem(StockInEquipment o, bool isSaveDraff)
{
using (TransactionScope transaction = new TransactionScope())
{
try
{
o.ID = Guid.NewGuid().ToString();
if (o.StockInEquipmentDetails != null)
{
ITInventoryManager itInManager = new ITInventoryManager();
foreach (StockInEquipmentDetail i in o.StockInEquipmentDetails)
{
i.ID = Guid.NewGuid().ToString();
i.StockInEquipmentID = o.ID;
// Add Number in stock
if (!isSaveDraff)
{
itInManager.AddItemToWarehouse(i.ItemDetailID, i.UnitID, i.Quantity.Value, this.db);
}
}
}
if (isSaveDraff)
{
o.Status = (int)OrderStatus.DRAFT;
}
else
{
o.Status = (int)OrderStatus.FINSHED;
}
db.StockInEquipments.Add(o);
db.SaveChanges();
transaction.Complete();
return(o.ID);
}
catch (Exception)
{
transaction.Dispose();
}
}
return("");
}
/// <summary>
///
/// </summary>
/// <param name="sItemID"></param>
/// <returns></returns>
public bool DeleteItem(string sItemID, int iUserID)
{
StockInEquipment item = db.StockInEquipments.Where(i => i.ID == sItemID).SingleOrDefault();
if (item != null)
{
if (iUserID != item.CreatorID.Value)
{
return(false);
}
if (item.Status == (int)OrderStatus.FINSHED)
{
return(false);
}
item.Status = (int)OrderStatus.DELETED;
db.SaveChanges();
return(true);
}
return(false);
}
/// <summary>
/// Update Item
/// </summary>
/// <param name="o">DeviceRegistration to Update</param>
/// <param name="status">OrderStatus</param>
/// <param name="w">WFMainDetail</param>
/// <param name="properties"></param>
/// <returns></returns>
public bool UpdateItem(StockInEquipment o, Boolean isSaveDraff, params System.Linq.Expressions.Expression <Func <StockInEquipment, object> >[] properties)
{
using (TransactionScope transaction = new TransactionScope())
{
try
{
StockInEquipment item = db.StockInEquipments.Where(i => i.ID == o.ID || i.OrderCode == o.OrderCode).SingleOrDefault();
if (item != null)
{
foreach (var propertie in properties)
{
var lambda = (LambdaExpression)propertie;
MemberExpression memberExpression;
if (lambda.Body is UnaryExpression)
{
memberExpression = (MemberExpression)((UnaryExpression)lambda.Body).Operand;
}
else
{
memberExpression = (MemberExpression)lambda.Body;
}
string propertyName = memberExpression.Member.Name;
item.GetType().GetProperty(propertyName).SetValue(item, o.GetType().GetProperty(propertyName).GetValue(o));
}
}
// Xóa Detail
List <StockInEquipmentDetail> lstDeviceDetail = db.StockInEquipmentDetails.Where(i => i.StockInEquipmentID == item.ID).ToList();
if (lstDeviceDetail.Count > 0)
{
foreach (StockInEquipmentDetail i in lstDeviceDetail)
{
db.StockInEquipmentDetails.Remove(i);
}
}
//Add detail
if (o.StockInEquipmentDetails != null)
{
ITInventoryManager itInManager = new ITInventoryManager();
foreach (StockInEquipmentDetail i in o.StockInEquipmentDetails)
{
i.ID = Guid.NewGuid().ToString();
i.StockInEquipmentID = o.ID;
db.StockInEquipmentDetails.Add(i);
// Add Number in stock
if (!isSaveDraff)
{
itInManager.AddItemToWarehouse(i.ItemDetailID, i.UnitID, i.Quantity.Value, this.db);
}
}
}
if (isSaveDraff)
{
item.Status = (int)OrderStatus.DRAFT;
}
else
{
item.Status = (int)OrderStatus.FINSHED;
item.Temp1 = DateTime.Now;
}
db.SaveChanges();
transaction.Complete();
return(true);
}
catch
{
transaction.Dispose();
return(false);
}
}
}