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 Boolean AddScholarshipDiscounts(List <ScholarshipDiscountBDO> discounts, int scholarshipCode, ref string message) { message = "Scholarship Discounts Added Successfully"; Boolean ret = true; try { foreach (ScholarshipDiscountBDO d in discounts) { ScholarshipDiscount sd = new ScholarshipDiscount(); ConvertScholarshipDiscountBDOToScholarshipDiscount(d, sd); using (var DCEnt = new DCFIEntities()) { DCEnt.ScholarshipDiscounts.Attach(sd); int num = DCEnt.SaveChanges(); if (num != 1) { ret = false; } } } } 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 Boolean AddScholarshipDiscounts(List<ScholarshipDiscountBDO> discounts, int scholarshipCode, ref string message) { message = "Scholarship Discounts Added Successfully"; Boolean ret = true; try { foreach (ScholarshipDiscountBDO d in discounts) { ScholarshipDiscount sd = new ScholarshipDiscount(); ConvertScholarshipDiscountBDOToScholarshipDiscount(d, sd); using (var DCEnt = new DCFIEntities()) { DCEnt.ScholarshipDiscounts.Attach(sd); int num = DCEnt.SaveChanges(); if (num != 1) ret = false; } } } 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 Boolean DeleteScholarshipDiscount(string sdCode, string scholarshipCode) { //message = "User Deleted successfully."; Boolean ret = true; using (var DCEnt = new DCFIEntities()) { ScholarshipDiscount sdInDB = (from sd in DCEnt.ScholarshipDiscounts where sd.ScholarshipCode == scholarshipCode && sd.ScholarshipFeeCode == sdCode select sd).FirstOrDefault(); if (sdInDB == null) { throw new Exception("No Scholarship Discount with ID " + sdCode); } DCEnt.ScholarshipDiscounts.Remove(sdInDB); DCEnt.Entry(sdInDB).State = System.Data.Entity.EntityState.Deleted; int num = DCEnt.SaveChanges(); if (num != 1) { ret = false; //message = "Deletion of User Failed."; } } return(ret); }
// 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; }
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); }
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; }
// 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 List <ScholarshipDiscount> ToScholarshipDiscountList(List <ScholarshipDiscountBDO> scholarhsipDiscounts) { List <ScholarshipDiscount> sdList = new List <ScholarshipDiscount>(); foreach (ScholarshipDiscountBDO sdbdo in scholarhsipDiscounts) { ScholarshipDiscount s = new ScholarshipDiscount(); s.Deactivated = sdbdo.Deactivated; s.Discount = sdbdo.Discount; //ss.Fee = sdbdo.Fee; // s.FeeID = sdbdo.FeeID; // s.ScholarshipCode = sdbdo.ScholarshipCode; s.ScholarshipDiscountId = sdbdo.ScholarshipDiscountId; sdList.Add(s); } return(sdList); }
public Boolean AddScholarshipDiscounts(List<ScholarshipDiscountBDO> discounts, string scholarshipCode, ref string message) { message = "Scholarship Discounts Added Successfully"; Boolean ret = true; foreach (ScholarshipDiscountBDO d in discounts) { ScholarshipDiscount sd = new ScholarshipDiscount(); ConvertScholarshipDiscountBDOToScholarshipDiscount(d, sd, scholarshipCode); using (var DCEnt = new DCFIEntities()) { DCEnt.ScholarshipDiscounts.Attach(sd); int num = DCEnt.SaveChanges(); if (num != 1) ret = false; } } return ret; }
public Boolean DeleteScholarshipDiscount(int sdCode) { //message = "User Deleted successfully."; Boolean ret = true; try { using (var DCEnt = new DCFIEntities()) { ScholarshipDiscount sdInDB = (from sd in DCEnt.ScholarshipDiscounts where sd.ScholarshipDiscountId == sdCode select sd).FirstOrDefault(); if (sdInDB == null) { throw new Exception("No Scholarship Discount with ID " + sdCode); } DCEnt.ScholarshipDiscounts.Remove(sdInDB); DCEnt.Entry(sdInDB).State = System.Data.Entity.EntityState.Deleted; int num = DCEnt.SaveChanges(); if (num != 1) { ret = false; //message = "Deletion of User 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 Boolean AddScholarshipDiscounts(List <ScholarshipDiscountBDO> discounts, string scholarshipCode, ref string message) { message = "Scholarship Discounts Added Successfully"; Boolean ret = true; foreach (ScholarshipDiscountBDO d in discounts) { ScholarshipDiscount sd = new ScholarshipDiscount(); ConvertScholarshipDiscountBDOToScholarshipDiscount(d, sd, scholarshipCode); using (var DCEnt = new DCFIEntities()) { DCEnt.ScholarshipDiscounts.Attach(sd); int num = DCEnt.SaveChanges(); if (num != 1) { ret = false; } } } 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; } }
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); } }
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 List<ScholarshipDiscount> ToScholarshipDiscountList(List<ScholarshipDiscountBDO> scholarhsipDiscounts) { List<ScholarshipDiscount> sdList = new List<ScholarshipDiscount>(); foreach (ScholarshipDiscountBDO sdbdo in scholarhsipDiscounts) { ScholarshipDiscount s = new ScholarshipDiscount(); s.Deactivated = sdbdo.Deactivated; s.Discount = sdbdo.Discount; //ss.Fee = sdbdo.Fee; // s.FeeID = sdbdo.FeeID; // s.ScholarshipCode = sdbdo.ScholarshipCode; s.ScholarshipDiscountId = sdbdo.ScholarshipDiscountId; sdList.Add(s); } return sdList; }
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; }