public Agreement selectAgreement(Agreement obj)
{
try
{
IAgreementSvc svc = (IAgreementSvc)this.getService(typeof(IAgreementSvc).Name);
return svc.selectAgreement(obj);
}
catch (ServiceLoadException ex)
{
throw ex;
}
}
public Boolean objectDataEquals(Agreement obj)
{
if (!(this.Agreement_ID.Equals(obj.Agreement_ID)))
{
return false;
}
if (!(this.Agreement_Name.Equals(obj.Agreement_Name)))
{
return false;
}
return true;
}
public bool deleteAgreement(Agreement obj)
{
using (RealReportContext db = new RealReportContext())
{
try
{
IQueryable<Agreement> AgreementList = from agreement in db.Agreements
where agreement.Agreement_ID == obj.Agreement_ID
select agreement;
if ((AgreementList.ToArray().Length > 0))
{
foreach (Agreement agreement in AgreementList.ToList())
{
for (int n = 0; n < (agreement.Properties.ToArray()).Length; n++ )
{
db.Properties.Remove((agreement.Properties.ToArray())[0]);
}
}
db.Agreements.Remove((AgreementList.ToArray())[0]);
#region Database Submission
try
{
db.SaveChanges();
return true;
}
catch (Exception ex)
{
return false;
}
#endregion
}
else
{
return false;
}
}
catch (Exception ex)
{
return false;
}
}
}
public Agreement selectAgreement(Agreement obj)
{
RealReportContext db = new RealReportContext();
try
{
IQueryable<Agreement> AgreementList = from agreement in db.Agreements
where agreement.Agreement_ID == obj.Agreement_ID
select agreement;
return (AgreementList.ToList())[0];
}
catch (Exception ex)
{
return null;
}
}
public bool insertAgreement(Agreement obj)
{
using (RealReportContext db = new RealReportContext())
{
try
{
db.Agreements.Add(obj);
db.SaveChanges();
return true;
}
catch (Exception ex)
{
return false;
}
}
}
public Boolean updateAgreement(Agreement obj)
{
try
{
IAgreementSvc svc = (IAgreementSvc)this.getService(typeof(IAgreementSvc).Name);
if (obj.isDataEntered())
{
return svc.updateAgreement(obj);
}
else
{
throw new BusinessValidationException(CustomErrors.REQUIRED_FIELD);
}
}
catch (ServiceLoadException ex)
{
throw ex;
}
}
public bool updateAgreement(Agreement obj)
{
using (RealReportContext db = new RealReportContext())
{
try
{
IQueryable<Agreement> AgreementList = from agreement in db.Agreements
where agreement.Agreement_ID == obj.Agreement_ID
select agreement;
if ((AgreementList.ToArray()).Length > 0)
{
foreach (Agreement agreement in AgreementList)
{
agreement.Agreement_Name = obj.Agreement_Name;
}
#region Database Submission with Rollback
try
{
db.SaveChanges();
return true;
}
catch (Exception ex)
{
return false;
}
#endregion
}
else
{
return false;
}
}
catch (Exception ex)
{
return false;
}
}
}
