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