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); }