public bool UpdateRecord(Object Siteobj)
{
Boolean flag = false;
Site site = (Site)Siteobj;
try
{
SiteMaster _site = new SiteMaster();
_site.Id = Convert.ToInt64(site.Id);
if (site.ClientID != null)
{
_site.ClientID = Convert.ToInt64(site.ClientID);
}
if (site.SiteName != null)
{
_site.SiteName = site.SiteName.Trim();
}
if (site.BillingFrequency != null)
{
_site.BillingFrequency = site.BillingFrequency;
}
if (site.BillingUpto != null)
{
_site.BillingUpto = Common.DateGB(site.BillingUpto);
}
if (site.BillingDate != null)
{
_site.BillingDate = Common.DateGB(site.BillingDate);
}
if (site.FixedBillNotice != null)
{
_site.FixedBillNotice = site.FixedBillNotice;
}
if (site.FixedBillNotice == true)
{
if (site.FixedBillNote != null)
{
_site.FixedBillNote = site.FixedBillNote;
}
else
{
_site.FixedBillNote = "";
}
}
else
{ _site.FixedBillNote = ""; }
if (site.BankName != null)
{
_site.BankName = site.BankName;
}
if (site.BankSortCode != null)
{
_site.BankSortCode = site.BankSortCode;
}
if (site.BankAccount != null)
{
_site.BankAccount = site.BankAccount;
}
if (site.OINSUNNumber != null)
{
_site.OINSUNNumber = site.OINSUNNumber;
}
if (site.ManualReviewofBill != null)
{
_site.ManualReviewofBill =Convert.ToBoolean(site.ManualReviewofBill);
}
if (site.ContactName != null)
{
_site.ContactName = site.ContactName;
}
if (site.DepartmentID != null)
{
_site.DepartmentID = site.DepartmentID;
}
if (site.Telephone != null)
{
_site.Telephone = site.Telephone;
}
if (site.Mobile != null)
{
_site.Mobile = site.Mobile;
}
if (site.Email != null)
{
_site.Email = site.Email;
}
if (site.DomesticProperties != null)
{
_site.DomesticProperties = site.DomesticProperties;
}
if (site.CommercialProperties != null)
{
_site.CommercialProperties = site.CommercialProperties;
}
if (site.BulkSupplies != null)
{
_site.BulkSupplies = site.BulkSupplies;
}
if (site.CreditControl != null)
{
_site.CreditControl = site.CreditControl;
}
if (site.EndDate != null)
{
_site.EndDate = Common.DateGB(site.EndDate);
}
if (site.ClientRefNo != null)
{
_site.ClientRefNo = site.ClientRefNo;
}
_site.ModifyBy = site.modifyBy;
_site.ModifyDate = DateTime.Now;
if (_site.Id != null)
{
flag = DAL.DALSite.UpdateSite(_site);
}
}
catch (Exception ex)
{
throw;
}
return flag;
}
public static bool IsExistingSite(SiteMaster site)
{
using (var context = new SycousCon())
{
try
{
SiteMaster objsite = context.SiteMasters.SingleOrDefault(p => p.SiteName.ToUpper() == site.SiteName.ToUpper());
if (objsite != null)
{ return true; }
else
{
return false;
}
}
catch (Exception ex)
{
context.Dispose();
throw;
}
}
}
public bool CreateRecord(Object Siteobj)
{
Boolean flag = false;
Site site = (Site)Siteobj;
try
{
SiteMaster _site = new SiteMaster();
if (site.ClientID != null)
{
_site.ClientID = Convert.ToInt64(site.ClientID);
}
if (site.SiteName != null)
{
_site.SiteName = site.SiteName.Trim();
}
if ((site.SiteName != null) && (!String.IsNullOrEmpty(site.SiteName)))
{
Int32 Lastnummer = DAL.DALSite.GetLastSiteNumber(site.SiteName);
_site.SiteRef = site.SiteName.ToUpper().Substring(0, 3) + Common.Get_TwoDigitCode(Lastnummer);
}
if (site.BillingFrequency != null)
{
_site.BillingFrequency = site.BillingFrequency;
}
if (site.BillingUpto != null)
{
_site.BillingUpto = Common.DateGB(site.BillingUpto);
}
if (site.BillingDate != null)
{
_site.BillingDate = Common.DateGB(site.BillingDate);
}
if (site.FixedBillNotice != null)
{
_site.FixedBillNotice = site.FixedBillNotice;
}
if (site.FixedBillNotice == true)
{
if (site.FixedBillNote != null)
{
_site.FixedBillNote = site.FixedBillNote.Trim();
}
}
else
{
_site.FixedBillNote = "";
}
if (site.BankName != null)
{
_site.BankName = site.BankName;
}
if (site.BankSortCode != null)
{
_site.BankSortCode = site.BankSortCode;
}
if (site.BankAccount != null)
{
_site.BankAccount = site.BankAccount;
}
if (site.OINSUNNumber != null)
{
_site.OINSUNNumber = site.OINSUNNumber;
}
if (site.ManualReviewofBill != null)
{
_site.ManualReviewofBill = Convert.ToBoolean(site.ManualReviewofBill);
}
if (site.ContactName != null)
{
_site.ContactName = site.ContactName;
}
if (site.DepartmentID != null)
{
_site.DepartmentID = site.DepartmentID;
}
if (site.Telephone != null)
{
_site.Telephone = site.Telephone;
}
if (site.Mobile != null)
{
_site.Mobile = site.Mobile;
}
if (site.Email != null)
{
_site.Email = site.Email;
}
if (site.DomesticProperties != null)
{
_site.DomesticProperties = site.DomesticProperties;
}
if (site.CommercialProperties != null)
{
_site.CommercialProperties = site.CommercialProperties;
}
if (site.BulkSupplies != null)
{
_site.BulkSupplies = site.BulkSupplies;
}
if (site.CreditControl != null)
{
_site.CreditControl = site.CreditControl;
}
if (site.EndDate != null)
{
_site.EndDate = Common.DateGB(site.EndDate);
}
if (site.ClientRefNo != null)
{
_site.ClientRefNo = site.ClientRefNo.Trim();
}
_site.CreateBy = site.CreateBy;
_site.CreateDate = DateTime.Now;
if ((_site.SiteRef != null) && (_site.ClientID != null))
{
flag = DAL.DALSite.CreateSite(_site);
}
}
catch (Exception ex)
{
throw;
}
return flag;
}
public static SiteMaster EditSite(Int64 siteId)
{
SiteMaster site = new SiteMaster();
using (var context = new SycousCon())
{
try
{
site = context.SiteMasters.SingleOrDefault(s => s.Id == siteId);
}
catch (Exception ex)
{
context.Dispose();
throw;
}
}
return site;
}
public static Boolean UpdateSite(SiteMaster site)
{
using (TransactionScope scope = new TransactionScope())
{
Boolean bol = false;
using (var context = new SycousCon())
{
try
{
var Update = context.SiteMasters.Where(c => c.Id == site.Id);
foreach (SiteMaster p in Update)
{
if (site.SiteName != null)
{
p.SiteName = site.SiteName;
}
if (site.ClientID != null)
{
p.ClientID = site.ClientID;
}
if (site.BillingFrequency != null)
{
p.BillingFrequency = site.BillingFrequency;
}
if (site.BillingUpto != null)
{
p.BillingUpto = site.BillingUpto;
}
if (site.BillingDate != null)
{
p.BillingDate = site.BillingDate;
}
if (site.FixedBillNotice != null)
{
p.FixedBillNotice = site.FixedBillNotice;
if (site.FixedBillNotice == true)
{
if (site.FixedBillNote != null)
{
p.FixedBillNote = site.FixedBillNote;
}
}
else {
p.FixedBillNote = "";
}
}//
if (site.BankName != null)
{
p.BankName = site.BankName;
}
if (site.BankSortCode != null)
{
p.BankSortCode = site.BankSortCode;
}
if (site.BankAccount != null)
{
p.BankAccount = site.BankAccount;
}
if (site.OINSUNNumber != null)
{
p.OINSUNNumber = site.OINSUNNumber;
}
if (site.ManualReviewofBill != null)
{
p.ManualReviewofBill = site.ManualReviewofBill;
}
if (site.ContactName != null)
{
p.ContactName = site.ContactName;
}
if (site.DepartmentID != null)
{
p.DepartmentID = site.DepartmentID;
}
if (site.Telephone != null)
{
p.Telephone = site.Telephone;
}
if (site.Mobile != null)
{
p.Mobile = site.Mobile;
}
if (site.Email != null)
{
p.Email = site.Email;
}
if (site.DomesticProperties != null)
{
p.DomesticProperties = site.DomesticProperties;
}
if (site.CommercialProperties != null)
{
p.CommercialProperties = site.CommercialProperties;
}
if (site.BulkSupplies != null)
{
p.BulkSupplies = site.BulkSupplies;
}
if (site.EndDate != null)
{
p.EndDate = site.EndDate;
}
if (site.CreditControl != null)
{
p.CreditControl = site.CreditControl;
}
if (site.ClientRefNo != null)
{
p.ClientRefNo = site.ClientRefNo;
}
else { p.ClientRefNo = null; }
p.ModifyDate = DateTime.Now;
p.ModifyBy = site.ModifyBy;
}//
context.SaveChanges();
context.AcceptAllChanges();
scope.Complete();
context.Dispose();
bol = true;
}
catch (Exception ex)
{
context.Dispose();
throw;
}
}// using
return bol;
} //trans
}
public static Boolean CreateSite(SiteMaster site)
{
Boolean flag = false;
if (!(IsExistingSite(site)))
{
using (TransactionScope scope = new TransactionScope())
{
using (var context = new SycousCon())
{
try
{
context.SiteMasters.AddObject(site);
context.SaveChanges();
scope.Complete();
context.AcceptAllChanges();
flag = true;
}
catch (Exception ex)
{
context.Dispose();
throw;
}
}
}
}
return flag;
}
/// <summary>
/// Create a new SiteMaster object.
/// </summary>
/// <param name="id">Initial value of the Id property.</param>
/// <param name="clientID">Initial value of the ClientID property.</param>
/// <param name="manualReviewofBill">Initial value of the ManualReviewofBill property.</param>
/// <param name="isDeleted">Initial value of the IsDeleted property.</param>
public static SiteMaster CreateSiteMaster(global::System.Int64 id, global::System.Int64 clientID, global::System.Boolean manualReviewofBill, global::System.Int32 isDeleted)
{
SiteMaster siteMaster = new SiteMaster();
siteMaster.Id = id;
siteMaster.ClientID = clientID;
siteMaster.ManualReviewofBill = manualReviewofBill;
siteMaster.IsDeleted = isDeleted;
return siteMaster;
}
/// <summary>
/// Deprecated Method for adding a new object to the SiteMasters EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead.
/// </summary>
public void AddToSiteMasters(SiteMaster siteMaster)
{
base.AddObject("SiteMasters", siteMaster);
}
