public static Boolean UpdatePropertyBand(PropertyBand Band) { using (TransactionScope scope = new TransactionScope()) { Boolean bol = false; using (var context = new SycousCon()) { try { var Update = context.PropertyBands.Where(c => c.ID == Band.ID); foreach (PropertyBand p in Update) { if (Band.PropertyBand1 != null) { p.PropertyBand1 = Band.PropertyBand1; } if (Band.PropertyLevel != null) { p.PropertyLevel = Band.PropertyLevel; } if (Band.PropertySize != null) { p.PropertySize = Band.PropertySize; } if (Band.PropertyType != null) { p.PropertyType = Band.PropertyType; } if (Band.PropertyOwnershipType != null) { p.PropertyOwnershipType = Band.PropertyOwnershipType; } if (Band.ClientID != null) { p.ClientID = Band.ClientID; } if (Band.SiteID!= null) { p.SiteID = Band.SiteID; } p.ModifyBy = Band.ModifyBy; p.ModifyDate = DateTime.Now; }// context.SaveChanges(); context.AcceptAllChanges(); scope.Complete(); context.Dispose(); bol = true; } catch (Exception ex) { context.Dispose(); throw; } }// using return bol; } //trans }
public static bool IsExistingPropertyBand(PropertyBand band) { using (var context = new SycousCon()) { try { PropertyBand objband = context.PropertyBands.SingleOrDefault(p => p.PropertyBand1.ToUpper() == band.PropertyBand1.ToUpper() && p.ClientID == band.ClientID && p.SiteID == band.SiteID); if (objband != null) { return true; } else { return false; } } catch (Exception ex) { context.Dispose(); throw; } } }
public static PropertyBand EditPropertyBand(Int32 bandID) { PropertyBand band = new PropertyBand(); using (var context = new SycousCon()) { try { band = context.PropertyBands.SingleOrDefault(s => s.ID == bandID); } catch (Exception ex) { context.Dispose(); throw; } } return band; }
public static Boolean CreatePropertyBand(PropertyBand band) { Boolean flag = false; if (!(IsExistingPropertyBand(band))) { using (TransactionScope scope = new TransactionScope()) { using (var context = new SycousCon()) { try { context.PropertyBands.AddObject(band); context.SaveChanges(); scope.Complete(); context.AcceptAllChanges(); flag = true; } catch (Exception ex) { context.Dispose(); throw; } }// }// using }//if return flag; }
/// <summary> /// Create a new PropertyBand object. /// </summary> /// <param name="id">Initial value of the ID property.</param> /// <param name="isDeleted">Initial value of the IsDeleted property.</param> public static PropertyBand CreatePropertyBand(global::System.Int32 id, global::System.Int32 isDeleted) { PropertyBand propertyBand = new PropertyBand(); propertyBand.ID = id; propertyBand.IsDeleted = isDeleted; return propertyBand; }
/// <summary> /// Deprecated Method for adding a new object to the PropertyBands EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead. /// </summary> public void AddToPropertyBands(PropertyBand propertyBand) { base.AddObject("PropertyBands", propertyBand); }