public bool UpdateItem(WFMain o, params System.Linq.Expressions.Expression <Func <WFMain, object> >[] properties)
{
var item = db.WFMains.Where(i => 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));
}
db.SaveChanges();
}
else
{
return(false);
}
return(true);
}
/// <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(HardwareRequirement o, OrderStatus status, WFMain w)
{
using (TransactionScope transaction = new TransactionScope())
{
try
{
if (o.ID.Length == 0 || o.ID == null)
{
o.ID = Guid.NewGuid().ToString();
}
if (o.Description == null)
{
o.Description = "";
}
if (o.Reason == null)
{
o.Reason = "";
}
if (o.HardwareRequirementDetails != null)
{
int sequence = 0;
foreach (HardwareRequirementDetail i in o.HardwareRequirementDetails)
{
sequence += 1;
i.ID = Guid.NewGuid().ToString();
i.HardwareRequirementID = o.ID;
i.ItemNo = GetItemNo(sequence);
i.Temp1 = 0;
}
}
db.HardwareRequirements.Add(o);
// Check for sending?
if (status == OrderStatus.SENDING)
{
db.WFMains.Add(w);
}
db.SaveChanges();
transaction.Complete();
return(o.ID);
}
catch (Exception)
{
transaction.Dispose();
}
}
return("");
}
/// <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(DeviceRegistration o, OrderStatus status, WFMain w)
{
using (TransactionScope transaction = new TransactionScope())
{
try
{
if (o.ID.Length == 0 || o.ID == null)
{
o.ID = Guid.NewGuid().ToString();
}
if (o.Description == null)
{
o.Description = "";
}
if (o.Reason == null)
{
o.Reason = "";
}
if (o.DeviceRegistrationDetails != null)
{
foreach (DeviceRegistrationDetail i in o.DeviceRegistrationDetails)
{
i.ID = Guid.NewGuid().ToString();
i.DeviceRegistrationID = o.ID;
i.Temp1 = "";
}
}
db.DeviceRegistrations.Add(o);
// Check for sending?
if (status == OrderStatus.SENDING)
{
db.WFMains.Add(w);
}
db.SaveChanges();
transaction.Complete();
return(o.ID);
}
catch (Exception)
{
transaction.Dispose();
}
}
return("");
}
public bool InsertItem(WFMain o)
{
db.WFMains.Add(o);
db.SaveChanges();
return(true);
}
