public static Boolean UpdateConsumerTemplate(ConsumerTemplate consumer)
{
using (TransactionScope scope = new TransactionScope())
{
Boolean bol = false;
using (var context = new SycousCon())
{
try
{
var Update = context.ConsumerTemplates.Where(c => c.ID == consumer.ID);
foreach (ConsumerTemplate p in Update)
{
if (consumer.ClientID != null)
{
p.ClientID = consumer.ClientID;
}
if (consumer.SiteID != null)
{
p.SiteID = consumer.SiteID;
}
if (consumer.Telephone != null)
{
p.Telephone = consumer.Telephone;
}
else { p.Telephone = null; }
if (consumer.Email != null)
{
p.Email = consumer.Email;
}
else { p.Email = null; }
if (consumer.OpeningHoursFrom != null)
{
p.OpeningHoursFrom = consumer.OpeningHoursFrom;
}
else
{
p.OpeningHoursFrom = null;
}
if (consumer.OpeningHoursEnd != null)
{
p.OpeningHoursEnd = consumer.OpeningHoursEnd;
}
else
{ p.OpeningHoursEnd = null; }
if (consumer.Address != null)
{
p.Address = consumer.Address;
}
else
{
p.Address = null;
}
if (consumer.Address2 != null)
{
p.Address2 = consumer.Address2;
}
else { p.Address2 = null; }
if (consumer.County != null)
{
p.County = consumer.County;
}
else
{ p.County = null; }
if (consumer.City != null)
{
p.City = consumer.City;
}
else { p.City = null; }
if (consumer.ZipCode != null)
{
p.ZipCode = consumer.ZipCode;
}
else { p.ZipCode = null; }
if (consumer.SupplierID != null)
{
p.SupplierID = consumer.SupplierID;
}
p.DirectDebit = consumer.DirectDebit;
p.PayPoint = consumer.PayPoint;
p.PayZone = consumer.PayZone;
p.PostOffice = consumer.PostOffice;
p.BankTransfer = consumer.BankTransfer;
p.OnlinePay = consumer.OnlinePay;
p.TelephonePay = consumer.TelephonePay;
p.OnlineNTelephonePay = consumer.OnlineNTelephonePay;
p.CashPayments = consumer.CashPayments;
p.AppNSMS = consumer.AppNSMS;
p.WebsitePayments = consumer.WebsitePayments;
if (consumer.PaymentTelephoneNo != null)
{
p.PaymentTelephoneNo = consumer.PaymentTelephoneNo;
}
else
{
p.PaymentTelephoneNo = null;
}
if (consumer.SortCode != null)
{
p.SortCode = consumer.SortCode;
}
else
{
p.SortCode = null;
}//
if (consumer.AccountNumber != null)
{
p.AccountNumber = consumer.AccountNumber;
}
else
{
p.AccountNumber = null;
}//
if (consumer.WebsiteAddress != null)
{
p.WebsiteAddress = consumer.WebsiteAddress;
}
else
{
p.WebsiteAddress = null;
}
p.ModifyBy = consumer.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 IsExistingConsumerTemplate(ConsumerTemplate consumer)
{
using (var context = new SycousCon())
{
try
{
ConsumerTemplate objconsumer = context.ConsumerTemplates.SingleOrDefault(p => p.ClientID == consumer.ClientID && p.SiteID == consumer.SiteID && p.IsDeleted == 0);
if (objconsumer != null)
{ return true; }
else
{
return false;
}
}
catch (Exception ex)
{
context.Dispose();
throw;
}
}
}
public static ConsumerTemplate EditConsumerTemplate(Int64 ID)
{
ConsumerTemplate consumer = new ConsumerTemplate();
using (var context = new SycousCon())
{
try
{
consumer = context.ConsumerTemplates.SingleOrDefault(s => s.ID == ID && s.IsDeleted == 0);
}
catch (Exception ex)
{
context.Dispose();
throw;
}
}
return consumer;
}
public static Boolean CreateConsumerTemplate(ConsumerTemplate consumer)
{
Boolean flag = false;
if (!(IsExistingConsumerTemplate(consumer)))
{
using (TransactionScope scope = new TransactionScope())
{
using (var context = new SycousCon())
{
try
{
context.ConsumerTemplates.AddObject(consumer);
context.SaveChanges();
scope.Complete();
context.AcceptAllChanges();
flag = true;
}
catch (Exception ex)
{
context.Dispose();
throw;
}
}
}
}
return flag;
}
/// <summary>
/// Create a new ConsumerTemplate object.
/// </summary>
/// <param name="id">Initial value of the ID property.</param>
/// <param name="isDeleted">Initial value of the IsDeleted property.</param>
/// <param name="directDebit">Initial value of the DirectDebit property.</param>
/// <param name="payPoint">Initial value of the PayPoint property.</param>
/// <param name="payZone">Initial value of the PayZone property.</param>
/// <param name="postOffice">Initial value of the PostOffice property.</param>
/// <param name="bankTransfer">Initial value of the BankTransfer property.</param>
/// <param name="onlinePay">Initial value of the OnlinePay property.</param>
/// <param name="telephonePay">Initial value of the TelephonePay property.</param>
/// <param name="onlineNTelephonePay">Initial value of the OnlineNTelephonePay property.</param>
/// <param name="cashPayments">Initial value of the CashPayments property.</param>
/// <param name="appNSMS">Initial value of the AppNSMS property.</param>
/// <param name="websitePayments">Initial value of the WebsitePayments property.</param>
public static ConsumerTemplate CreateConsumerTemplate(global::System.Int64 id, global::System.Int32 isDeleted, global::System.Int32 directDebit, global::System.Int32 payPoint, global::System.Int32 payZone, global::System.Int32 postOffice, global::System.Int32 bankTransfer, global::System.Int32 onlinePay, global::System.Int32 telephonePay, global::System.Int32 onlineNTelephonePay, global::System.Int32 cashPayments, global::System.Int32 appNSMS, global::System.Int32 websitePayments)
{
ConsumerTemplate consumerTemplate = new ConsumerTemplate();
consumerTemplate.ID = id;
consumerTemplate.IsDeleted = isDeleted;
consumerTemplate.DirectDebit = directDebit;
consumerTemplate.PayPoint = payPoint;
consumerTemplate.PayZone = payZone;
consumerTemplate.PostOffice = postOffice;
consumerTemplate.BankTransfer = bankTransfer;
consumerTemplate.OnlinePay = onlinePay;
consumerTemplate.TelephonePay = telephonePay;
consumerTemplate.OnlineNTelephonePay = onlineNTelephonePay;
consumerTemplate.CashPayments = cashPayments;
consumerTemplate.AppNSMS = appNSMS;
consumerTemplate.WebsitePayments = websitePayments;
return consumerTemplate;
}
/// <summary>
/// Deprecated Method for adding a new object to the ConsumerTemplates EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead.
/// </summary>
public void AddToConsumerTemplates(ConsumerTemplate consumerTemplate)
{
base.AddObject("ConsumerTemplates", consumerTemplate);
}