public bool CreateRecord(Object _DisConnectedobj) { Boolean flag = false; DisConnectedSupplyClass DisConnected = (DisConnectedSupplyClass)_DisConnectedobj; try { DAL.DisConnectedSupply _DisConnected = new DisConnectedSupply(); if (DisConnected.ClientID != null) { _DisConnected.ClientID = Convert.ToInt64(DisConnected.ClientID); } if (DisConnected.SiteID != null) { _DisConnected.SiteID = Convert.ToInt64(DisConnected.SiteID); } if (DisConnected.SupplierID != null) { _DisConnected.SupplierID = Convert.ToInt64(DisConnected.SupplierID); } if (DisConnected.ConsumptionValue != null) { _DisConnected.ConsumptionValue = Convert.ToDecimal(DisConnected.ConsumptionValue); } if (DisConnected.FromDate != null) { _DisConnected.FormDate = BAL.Common.DateGB(DisConnected.FromDate); } else { _DisConnected.FormDate = null; } if (DisConnected.ToDate != null) { _DisConnected.ToDate = BAL.Common.DateGB(DisConnected.ToDate); } else { _DisConnected.ToDate = null; } _DisConnected.CreateBy = DisConnected.CreateBy; _DisConnected.CreateDate = DateTime.Now; if ((_DisConnected.ClientID != null) && (_DisConnected.SiteID != null) && (_DisConnected.SupplierID != null)) { flag = DAL.DALDisConnectedSupply.CreateDisConnectedSupply(_DisConnected); } } catch (Exception ex) { throw; } return flag; }
public static Boolean CreateDisConnectedSupply(DisConnectedSupply DisConnected) { Boolean flag = false; if (!(IsExistingDisConnectedSupply(DisConnected))) { using (TransactionScope scope = new TransactionScope()) { using (var context = new SycousCon()) { try { context.DisConnectedSupplies.AddObject(DisConnected); context.SaveChanges(); scope.Complete(); context.AcceptAllChanges(); flag = true; } catch (Exception ex) { context.Dispose(); throw; } }// }// using }//if return flag; }
public static Boolean UpdateDisConnectedSupply(DisConnectedSupply DisConnected) { using (TransactionScope scope = new TransactionScope()) { Boolean bol = false; using (var context = new SycousCon()) { try { var Update = context.DisConnectedSupplies.Where(c => c.ID == DisConnected.ID); foreach (DisConnectedSupply p in Update) { if (DisConnected.ClientID != null) { p.ClientID = DisConnected.ClientID; } if (DisConnected.SiteID != null) { p.SiteID = DisConnected.SiteID; } if (DisConnected.SupplierID != null) { p.SupplierID = DisConnected.SupplierID; } if (DisConnected.ConsumptionValue != null) { p.ConsumptionValue = DisConnected.ConsumptionValue; } else { p.ConsumptionValue = null; } if (DisConnected.FormDate != null) { p.FormDate = DisConnected.FormDate; } else { p.FormDate = null; } if (DisConnected.ToDate != null) { p.ToDate = DisConnected.ToDate; } else { p.FormDate = null; } p.ModifyBy = DisConnected.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 IsExistingDisConnectedSupply(DisConnectedSupply DisConnected) { using (var context = new SycousCon()) { try { DisConnectedSupply objDisConnected = context.DisConnectedSupplies.SingleOrDefault(p => p.ClientID == DisConnected.ClientID && p.SiteID == DisConnected.SiteID && p.SupplierID == DisConnected.SupplierID); if (objDisConnected != null) { return true; } else { return false; } } catch (Exception ex) { context.Dispose(); throw; } } }
public static DisConnectedSupply EditDisConnectedSupply(Int64 DisConnectedID) { DisConnectedSupply DisConnected = new DisConnectedSupply(); using (var context = new SycousCon()) { try { DisConnected = context.DisConnectedSupplies.SingleOrDefault(s => s.ID == DisConnectedID); } catch (Exception ex) { context.Dispose(); throw; } } return DisConnected; }
/// <summary> /// Deprecated Method for adding a new object to the DisConnectedSupplies EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead. /// </summary> public void AddToDisConnectedSupplies(DisConnectedSupply disConnectedSupply) { base.AddObject("DisConnectedSupplies", disConnectedSupply); }
/// <summary> /// Create a new DisConnectedSupply object. /// </summary> /// <param name="id">Initial value of the ID property.</param> /// <param name="isDeleted">Initial value of the IsDeleted property.</param> public static DisConnectedSupply CreateDisConnectedSupply(global::System.Int64 id, global::System.Int32 isDeleted) { DisConnectedSupply disConnectedSupply = new DisConnectedSupply(); disConnectedSupply.ID = id; disConnectedSupply.IsDeleted = isDeleted; return disConnectedSupply; }