public Boolean AddScholarshipDiscount(ScholarshipDiscountBDO discount,int scholarshipCode, ref string message)
{
message = "Scholarship Discount Added Successfully";
Boolean ret = true;
ScholarshipDiscount sd = new ScholarshipDiscount();
try {
ConvertScholarshipDiscountBDOToScholarshipDiscount(discount, sd);
using (var DCEnt = new DCFIEntities())
{
DCEnt.ScholarshipDiscounts.Add(sd);
DCEnt.Entry(sd).State = System.Data.Entity.EntityState.Added;
int num = DCEnt.SaveChanges();
if (num != 1)
{
ret = false;
message = "Adding of Scholarship Discount failed";
}
}
}
catch (DbEntityValidationException dbEx)
{
foreach (var validationErrors in dbEx.EntityValidationErrors)
{
foreach (var validationError in validationErrors.ValidationErrors)
{
Trace.TraceInformation("Property: {0} Error: {1}",
validationError.PropertyName,
validationError.ErrorMessage);
}
}
}
return ret;
}
public ScholarshipDiscountBDO GetScholarship(int discountId)
{
ScholarshipDiscount sd = new ScholarshipDiscount();
ScholarshipDiscountBDO sBDO = new ScholarshipDiscountBDO();
try {
using (var DCEnt = new DCFIEntities())
{
sd = (from s in DCEnt.ScholarshipDiscounts
where s.ScholarshipDiscountId==discountId
select s).FirstOrDefault();
}
ConvertScholarshipDiscountToScholarshipDiscountBDO(sd, sBDO);
}
catch (DbEntityValidationException dbEx)
{
foreach (var validationErrors in dbEx.EntityValidationErrors)
{
foreach (var validationError in validationErrors.ValidationErrors)
{
Trace.TraceInformation("Property: {0} Error: {1}",
validationError.PropertyName,
validationError.ErrorMessage);
}
}
}
return sBDO;
}
public List<ScholarshipDiscountBDO> GetAllScholarships()
{
List<ScholarshipDiscount> sList = new List<ScholarshipDiscount>();
List<ScholarshipDiscountBDO> sBDOList = new List<ScholarshipDiscountBDO>();
try {
using (var DCEnt = new DCFIEntities())
{
var allScholarships = (DCEnt.ScholarshipDiscounts);
sList = allScholarships.ToList();
}
foreach (ScholarshipDiscount s in sList)
{
ScholarshipDiscountBDO sBDO = new ScholarshipDiscountBDO();
ConvertScholarshipDiscountToScholarshipDiscountBDO(s, sBDO);
sBDOList.Add(sBDO);
}
}
catch (DbEntityValidationException dbEx)
{
foreach (var validationErrors in dbEx.EntityValidationErrors)
{
foreach (var validationError in validationErrors.ValidationErrors)
{
Trace.TraceInformation("Property: {0} Error: {1}",
validationError.PropertyName,
validationError.ErrorMessage);
}
}
}
return sBDOList;
}
public void ConvertAssessToAssessBDO(StudentAssessment a, StudentAssessmentBDO ab)
{
FeeDAO fd = new FeeDAO();
FeeBDO fb = new FeeBDO();
ScholarshipDAO sd = new ScholarshipDAO();
ScholarshipDiscountBDO sb = new ScholarshipDiscountBDO();
if (a.DiscountId.HasValue)
{
int d = (int)a.DiscountId;
sb = sd.GetScholarship(d);
ab.DiscountId = (int)a.DiscountId;
}
ab.StudentAssessmentId = a.StudentAssessmentId;
ab.StudentSY = a.StudentSY;
ab.FeeID = a.FeeID;
ab.Fee = fd.GetFee((int)ab.FeeID);
ab.ScholarshipDiscount = sb;
}
public Boolean CreateScholarship(ref ScholarshipDiscountBDO sBDO, ref string message)
{
message = "Scholarship Added Successfully";
bool ret = true;
// Scholarship s = new Scholarship();
// ConvertScholarshipBDOToScholarship(sBDO, s);
// using (var DCEnt = new DCFIEntities())
// {
// DCEnt.Scholarships.Add(s);
// DCEnt.Entry(s).State = System.Data.Entity.EntityState.Added;
// int num = DCEnt.SaveChanges();
// sBDO.ScholarshipCode = s.ScholarshipCode;
// if (num != 1)
// {
// ret = false;
// message = "Adding of Scholarship failed";
// }
// }
return ret;
}
public Boolean AddScholarshipDiscount(ScholarshipDiscountBDO discount, string scholarshipCode, ref string message)
{
message = "Scholarship Discount Added Successfully";
Boolean ret = true;
ScholarshipDiscount sd = new ScholarshipDiscount();
ConvertScholarshipDiscountBDOToScholarshipDiscount(discount, sd, scholarshipCode);
using (var DCEnt = new DCFIEntities())
{
DCEnt.ScholarshipDiscounts.Attach(sd);
DCEnt.Entry(sd).State = System.Data.Entity.EntityState.Added;
int num = DCEnt.SaveChanges();
if (num != 1)
{
ret = false;
message = "Adding of Scholarship Discount failed";
}
return ret;
}
}
private void TranslateScholarshipDiscountToScholarshipDiscountBDO(ScholarshipDiscount sc, ScholarshipDiscountBDO sbdo)
{
//FeeService fs = new FeeService();
//Fee f = new Fee();
//f = fs.GetFee(sc.FeeID);
sbdo.Deactivated = sc.Deactivated;
sbdo.Discount = (float)sc.Discount;
sbdo.ScholarshipDiscountId = sc.ScholarshipDiscountId;
//sbdo.Fee = f;
}
private void ConvertScholarshipDiscountToScholarshipDiscountBDO(ScholarshipDiscount d, ScholarshipDiscountBDO sd, string scholarshipCode)
{
FeeBDO f = new FeeBDO();
ConvertFeeToFeeBDO(d.Fee, f);
sd.Deactivated = d.Deactivated;
sd.Discount = d.Discount;
sd.FeeCode = d.FeeCode;
sd.ScholarshipFeeCode = d.ScholarshipFeeCode;
sd.Fee = f;
}
public void ConvertScholarshipDiscountBDOToScholarshipDiscount(ScholarshipDiscountBDO d, ScholarshipDiscount sd)
{
sd.Deactivated = d.Deactivated;
sd.Discount = d.Discount;
sd.Scholarship = d.Scholarship;
sd.Description = d.Description;
sd.ScholarshipDiscountId = d.ScholarshipDiscountId;
}
public void TranslateScholarshipToScholarshipBDO(ScholarshipDiscount s, ScholarshipDiscountBDO sBDO)
{
//sBDO.ScholarshipCode = s.ScholarshipCode;
//sBDO.Condition = s.Condition;
sBDO.Deactivated = s.Deactivated;
sBDO.Description = s.Description;
// sBDO.Privilege = s.Privilege;
}
// Done
public bool UpdateScholarshipDiscount(ref ScholarshipDiscount scholarshipDiscount, ref string message)
{
ScholarshipDiscountBDO sdBDO = new ScholarshipDiscountBDO();
TranslateScholarshipDiscountToScholarshipDiscountBDO(scholarshipDiscount, sdBDO);
return sLogic.UpdateScholarshipDiscount(ref sdBDO, ref message);
}
public List<ScholarshipDiscountBDO> ToScholarhsipDiscountBDOList(List<ScholarshipDiscount> sdbdo)
{
List<ScholarshipDiscountBDO> scholarshipDiscounts = new List<ScholarshipDiscountBDO>();
foreach (ScholarshipDiscount SD in sdbdo)
{
ScholarshipDiscountBDO s = new ScholarshipDiscountBDO();
TranslateScholarshipDiscountToScholarshipDiscountBDO(SD, s);
scholarshipDiscounts.Add(s);
}
return scholarshipDiscounts;
}
public Boolean UpdateScholarshipDiscount(ref ScholarshipDiscountBDO sdBDO, ref string message)
{
return sDAO.UpdateScholarshipDiscount(ref sdBDO, ref message);
}
public Boolean CreateScholarship(ref ScholarshipDiscountBDO sbdo, ref string message)
{
return sDAO.CreateScholarship(ref sbdo, ref message);
}
public Boolean AddScholarshipDiscount(ScholarshipDiscountBDO sdBDO, int scholarshipCode, ref string message)
{
return sDAO.AddScholarshipDiscount(sdBDO, scholarshipCode, ref message);
}
public void ConvertScholarshipBDOToScholarship(ScholarshipDiscountBDO sbdo, ScholarshipDiscount s)
{
// s.Condition = sbdo.Condition;
s.Deactivated = sbdo.Deactivated;
s.Description = sbdo.Description;
//s.Privilege = sbdo.Privilege;
//s.ScholarshipCode = sbdo.ScholarshipCode;
// s.ScholarshipDiscounts = ToScholarshipDiscountList(sbdo.ScholarshipDiscounts);
}
// DCEnt.Scholarships.Remove(sInDB);
// sInDB.Condition = sBDO.Condition;
// sInDB.Deactivated = sBDO.Deactivated;
// sInDB.Description = sBDO.Description;
// sInDB.Privilege = sBDO.Privilege;
// sInDB.ScholarshipCode = sBDO.ScholarshipCode;
// DCEnt.Scholarships.Attach(sInDB);
// DCEnt.Entry(sInDB).State = System.Data.Entity.EntityState.Modified;
// int num = DCEnt.SaveChanges();
// if (num != 1)
// {
// ret = false;
// message = "No scholarship is updated.";
// }
//}
//return ret;
public Boolean UpdateScholarshipDiscount(ref ScholarshipDiscountBDO sBDO, ref string message)
{
message = "Scholarship discount updated successfully.";
Boolean ret = true;
try {
using (var DCEnt = new DCFIEntities())
{
var scholarshipCode = sBDO.ScholarshipDiscountId;
ScholarshipDiscount sInDB = (from s in DCEnt.ScholarshipDiscounts
where s.ScholarshipDiscountId== scholarshipCode
select s).FirstOrDefault();
if (sInDB == null)
{
throw new Exception("No Scholarship discount with ScholarshipCode " + sBDO.ScholarshipDiscountId);
}
DCEnt.ScholarshipDiscounts.Remove(sInDB);
// sInDB.FeeID= sBDO.FeeID;
sInDB.Deactivated = sBDO.Deactivated;
sInDB.Discount = sBDO.Discount;
sInDB.ScholarshipDiscountId = sBDO.ScholarshipDiscountId;
DCEnt.ScholarshipDiscounts.Attach(sInDB);
DCEnt.Entry(sInDB).State = System.Data.Entity.EntityState.Modified;
int num = DCEnt.SaveChanges();
if (num != 1)
{
ret = false;
message = "No scholarship discount is updated.";
}
}
}
catch (DbEntityValidationException dbEx)
{
foreach (var validationErrors in dbEx.EntityValidationErrors)
{
foreach (var validationError in validationErrors.ValidationErrors)
{
Trace.TraceInformation("Property: {0} Error: {1}",
validationError.PropertyName,
validationError.ErrorMessage);
}
}
}
return ret;
}
public Boolean UpdateScholarship(ref ScholarshipDiscountBDO sBDO, ref string message)
{
message = "Scholarship updated successfully.";
Boolean ret = true;
//Scholarship sc = new Scholarship();
//ConvertScholarshipBDOToScholarship(sBDO, sc);
//Scholarship scholarshipInDB = new Scholarship();
//using (var DCEnt = new DCFIEntities())
//{
// var scholarshipCode = sBDO.ScholarshipCode;
// Scholarship sInDB = (from s in DCEnt.Scholarships
// where s.ScholarshipCode == scholarshipCode
// select s).FirstOrDefault();
// if (sInDB == null)
// {
// throw new Exception("No Scholarship with ScholarshipCode " + sBDO.ScholarshipCode);
// }
// // 1st Part
// if (scholarshipInDB.ScholarshipDiscounts.Count == 0)
// {
// foreach (ScholarshipDiscount sd in sc.ScholarshipDiscounts)
// {
// scholarshipInDB.ScholarshipDiscounts.Add(sd);
// }
// }
// else if (scholarshipInDB.ScholarshipDiscounts.Count < sc.ScholarshipDiscounts.Count)
// {
// //compare 2 lists check the non existing to the other
// IEnumerable<ScholarshipDiscount> sdToAdd = sc.ScholarshipDiscounts.Except(scholarshipInDB.ScholarshipDiscounts);
// if (sdToAdd != null)
// {
// foreach (ScholarshipDiscount child in sdToAdd)
// {
// scholarshipInDB.ScholarshipDiscounts.Add(child);
// }
// }
// IEnumerable<ScholarshipDiscount> sdToRemove = scholarshipInDB.ScholarshipDiscounts.Except(sc.ScholarshipDiscounts);
// if (sdToRemove != null)
// {
// foreach (ScholarshipDiscount child in sdToRemove)
// {
// scholarshipInDB.ScholarshipDiscounts.Add(child);
// }
// }
// }
// else if (scholarshipInDB.ScholarshipDiscounts.Count > sc.ScholarshipDiscounts.Count)
// {
// //compare 2 lists check the non existing to the other
// IEnumerable<ScholarshipDiscount> sdToAdd = sc.ScholarshipDiscounts.Except(scholarshipInDB.ScholarshipDiscounts);
// if (sdToAdd != null)
// {
// foreach (ScholarshipDiscount child in sdToAdd)
// {
// scholarshipInDB.ScholarshipDiscounts.Add(child);
// }
// }
// // TBC
// IEnumerable<ScholarshipDiscount> sdToRemove = scholarshipInDB.ScholarshipDiscounts.Except(sc.ScholarshipDiscounts);
// if (sdToRemove != null)
// {
// foreach (ScholarshipDiscount child in sdToRemove)
// {
// scholarshipInDB.ScholarshipDiscounts.Add(child);
// }
// }
// }
// else if (scholarshipInDB.ScholarshipDiscounts.Count == sc.ScholarshipDiscounts.Count)
// {
// //compare 2 lists check the non existing to the other
// IEnumerable<ScholarshipDiscount> sdToAdd = sc.ScholarshipDiscounts.Except(scholarshipInDB.ScholarshipDiscounts);
// if (sdToAdd != null)
// {
// foreach (ScholarshipDiscount child in sdToAdd)
// {
// scholarshipInDB.ScholarshipDiscounts.Add(child);
// }
// }
// IEnumerable<ScholarshipDiscount> sdToRemove = scholarshipInDB.ScholarshipDiscounts.Except(sc.ScholarshipDiscounts);
// if (sdToRemove != null)
// {
// foreach (ScholarshipDiscount child in sdToRemove)
// {
// scholarshipInDB.ScholarshipDiscounts.Add(child);
// }
// }
// }
//}
//using (var DC = new DCFIEntities())
//{
// scholarshipInDB = sc;
// DC.Entry(scholarshipInDB).State = System.Data.Entity.EntityState.Modified;
// foreach (ScholarshipDiscount sd in scholarshipInDB.ScholarshipDiscounts)
// DC.Entry(sd).State = sd.ScholarshipDiscountId == 0 ? System.Data.Entity.EntityState.Added : System.Data.Entity.EntityState.Modified;
// int number = DC.SaveChanges();
// if (number > 0)
// {
// // ret = false;
// message = "No Scholarship is updated.";
// }
//}
return ret;
}
public List<ScholarshipDiscountBDO> GetAllScholarshipDiscountsFromScholarship(int scholarshipCode)
{
List<ScholarshipDiscount> scholarshipDiscounts = null;
List<ScholarshipDiscountBDO> sbdoList = new List<ScholarshipDiscountBDO>();
try {
using (var DCEnt = new DCFIEntities())
{
scholarshipDiscounts = (from sd in DCEnt.ScholarshipDiscounts
where sd.ScholarshipDiscountId == scholarshipCode
select sd).ToList<ScholarshipDiscount>();
}
foreach (ScholarshipDiscount sd in scholarshipDiscounts)
{
ScholarshipDiscountBDO scholDisBDO = new ScholarshipDiscountBDO();
ConvertScholarshipDiscountToScholarshipDiscountBDO(sd, scholDisBDO);
sbdoList.Add(scholDisBDO);
}
}
catch (DbEntityValidationException dbEx)
{
foreach (var validationErrors in dbEx.EntityValidationErrors)
{
foreach (var validationError in validationErrors.ValidationErrors)
{
Trace.TraceInformation("Property: {0} Error: {1}",
validationError.PropertyName,
validationError.ErrorMessage);
}
}
}
return sbdoList;
}
private void TranslateScholarshipDiscountBDOToScholarshipDiscount(ScholarshipDiscountBDO sc, ScholarshipDiscount sbdo)
{
sbdo.Deactivated = sc.Deactivated;
sbdo.Discount = sc.Discount;
sbdo.ScholarshipDiscountId = sc.ScholarshipDiscountId;
}
public bool AddScholarshipDiscount(ref ScholarshipDiscount scholarshipDiscount, int scholarshipCode, ref string message)
{
ScholarshipDiscountBDO sdbdo = new ScholarshipDiscountBDO();
TranslateScholarshipDiscountToScholarshipDiscountBDO(scholarshipDiscount, sdbdo);
return sLogic.AddScholarshipDiscount(sdbdo, scholarshipCode, ref message);
}
private void TranslateScholarshipDiscountToScholarshipDiscountBDO(ScholarshipDiscount sc, ScholarshipDiscountBDO sbdo)
{
sbdo.Deactivated = sc.Deactivated;
sbdo.Discount = sc.Discount;
sbdo.FeeCode = sc.FeeCode;
sbdo.ScholarshipCode = sc.ScholarshipCode;
sbdo.ScholarshipFeeCode = sc.ScholarshipFeeCode;
}
public bool CreateScholarship(ref ScholarshipDiscount scholarship, ref string message)
{
ScholarshipDiscountBDO sbdo = new ScholarshipDiscountBDO();
TranslateScholarshipToScholarshipBDO(scholarship, sbdo);
return sLogic.CreateScholarship(ref sbdo, ref message);
}
public List<ScholarshipDiscountBDO> GetAllScholarshipDiscountsFromScholarship(string scholarshipCode)
{
List<ScholarshipDiscount> scholarshipDiscounts = null;
List<ScholarshipDiscountBDO> sbdoList = new List<ScholarshipDiscountBDO>();
using (var DCEnt = new DCFIEntities())
{
scholarshipDiscounts = (from sd in DCEnt.ScholarshipDiscounts
where sd.ScholarshipCode == scholarshipCode
select sd).ToList<ScholarshipDiscount>();
}
foreach (ScholarshipDiscount sd in scholarshipDiscounts)
{
ScholarshipDiscountBDO scholDisBDO = new ScholarshipDiscountBDO();
ConvertScholarshipDiscountToScholarshipDiscountBDO(sd, scholDisBDO, scholarshipCode);
sbdoList.Add(scholDisBDO);
}
return sbdoList;
}
private void TranslateScholarshipBDOToScholarship(ScholarshipDiscountBDO sc, ScholarshipDiscount sbdo)
{
sbdo.ScholarshipDiscountId = sc.ScholarshipDiscountId;
sbdo.Scholarship = sc.Scholarship;
sbdo.Discount = sc.Discount;
sbdo.Deactivated = sc.Deactivated;
sbdo.Description = sc.Description;
}
public List<ScholarshipDiscountBDO> GetAllDiscounts(string scholarshipCode)
{
List<ScholarshipDiscountBDO> sdList = new List<ScholarshipDiscountBDO>();
List<ScholarshipDiscount> discounts = new List<ScholarshipDiscount>();
using (var DCEnt = new DCFIEntities())
{
discounts = (from s in DCEnt.ScholarshipDiscounts
where s.ScholarshipCode == scholarshipCode
select s).ToList<ScholarshipDiscount>();
}
foreach (ScholarshipDiscount sd in discounts)
{
ScholarshipDiscountBDO sdBDO = new ScholarshipDiscountBDO();
ConvertScholarshipDiscountToScholarshipDiscountBDO(sd, sdBDO, scholarshipCode);
sdList.Add(sdBDO);
}
return sdList;
}
// DCEnt.Scholarships.Remove(sInDB);
// sInDB.Condition = sBDO.Condition;
// sInDB.Deactivated = sBDO.Deactivated;
// sInDB.Description = sBDO.Description;
// sInDB.Privilege = sBDO.Privilege;
// sInDB.ScholarshipCode = sBDO.ScholarshipCode;
// DCEnt.Scholarships.Attach(sInDB);
// DCEnt.Entry(sInDB).State = System.Data.Entity.EntityState.Modified;
// int num = DCEnt.SaveChanges();
// if (num != 1)
// {
// ret = false;
// message = "No scholarship is updated.";
// }
//}
//return ret;
public Boolean UpdateScholarshipDiscount(ref ScholarshipDiscountBDO sBDO, ref string message)
{
message = "Scholarship discount updated successfully.";
Boolean ret = true;
using (var DCEnt = new DCFIEntities())
{
var scholarshipCode = sBDO.ScholarshipCode;
ScholarshipDiscount sInDB = (from s in DCEnt.ScholarshipDiscounts
where s.ScholarshipCode == scholarshipCode
select s).FirstOrDefault();
if (sInDB == null)
{
throw new Exception("No Scholarship discount with ScholarshipCode " + sBDO.ScholarshipCode);
}
DCEnt.ScholarshipDiscounts.Remove(sInDB);
sInDB.FeeCode = sBDO.FeeCode;
sInDB.Deactivated = sBDO.Deactivated;
sInDB.Discount = sBDO.Discount;
sInDB.ScholarshipCode = sBDO.ScholarshipCode;
DCEnt.ScholarshipDiscounts.Attach(sInDB);
DCEnt.Entry(sInDB).State = System.Data.Entity.EntityState.Modified;
int num = DCEnt.SaveChanges();
if (num != 1)
{
ret = false;
message = "No scholarship discount is updated.";
}
}
return ret;
}
public void ConvertScholarshipDiscountToScholarshipDiscountBDO(ScholarshipDiscount d, ScholarshipDiscountBDO sd)
{
sd.Deactivated = d.Deactivated;
sd.Discount = (float)d.Discount;
sd.Description = d.Description;
sd.Scholarship = d.Scholarship;
sd.ScholarshipDiscountId = d.ScholarshipDiscountId;
}