public tblassessment GetAssessment(int studentId)
{
tblassessment assessment = (from p in svmContext.tblassessment
join q in svmContext.tblstudent
on p.StudentId equals q.StudentId
//join r in svmContext.tbltuition
// on p.EducationalLevel equals r.DimEnrollmentId
// join s in svmContext.tblmisc
//on p.EducationalLevel equals s.DimMiscId
where p.StudentId == studentId
select p).FirstOrDefault();
return(assessment);
}
public void InsertStudent(int studentId, int sectionId, DateTime?validUntil, int educationalLevelId)
{
tblassessment tblAssessment = new tblassessment();
tblAssessment.StudentId = studentId;
tblAssessment.Status = 1; //for on assessment
tblAssessment.Section = 0;
tblAssessment.EducationalLevel = 0;
tblAssessment.PaymentTerm = 0;
tblAssessment.ValidUntil = null;
svmContext.tblassessment.Add(tblAssessment);
svmContext.SaveChanges();
}
public void UpdateTblAssessment(int studentId, int sectionId, int educationLevelId, int paymenTerm,
double fullAmount, double downpayment, double deferredAmount, double discountAmount
, bool isAlumni, double siblingDiscount, double referralDiscount, bool isTransfer,
double fullMisc, double deferredMisc, double originalTuitionFee)
{
tblassessment updateRecord = GetAssessment(studentId);
updateRecord.Section = sectionId;
updateRecord.Status = 2; //enrolled
updateRecord.EducationalLevel = educationLevelId;
updateRecord.FullAmount = fullAmount;
updateRecord.Downpayment = downpayment;
updateRecord.PaymentPerDue = deferredAmount;
updateRecord.Discount = discountAmount;
updateRecord.isAlumni = isAlumni;
updateRecord.SiblingDiscount = siblingDiscount;
updateRecord.ReferralDiscount = referralDiscount;
updateRecord.isTransferee = isTransfer;
updateRecord.FullMisc = fullMisc;
updateRecord.DeferredMisc = deferredMisc;
updateRecord.OriginalAmount = originalTuitionFee;
svmContext.SaveChanges();
}
private void FrmAssessment_Load(object sender, EventArgs e)
{
//eager load discounts
lstDiscount = _assessmentService.GetDiscount();
alumniDiscount = lstDiscount.Where(x => x.DiscountTypeDesc == "Alumni").FirstOrDefault().DiscountVal;
var lstSibling = lstDiscount.Where(x => x.DiscountTypeDesc == "Family Assistance").ToList();
var lstReferral = lstDiscount.Where(x => x.DiscountTypeDesc == "Referral").ToList();
siblingDiscountType = lstSibling[0].DiscountTypeId;
referralDiscountType = lstReferral[0].DiscountTypeId;
tblstudent student = _studentService.GetStudent(Global.selectedStudent);
Global.selectedId = Global.selectedStudent;
txtStudentName.Text = student.FirstName + " " + student.MiddleName + " " + student.LastName;
txtStudentNo.Text = student.StudentNo;
pbStudent.Image = Image.FromFile(student.path);
tblassessment assessment = _assessmentService.GetAssessment(Global.selectedStudent);
txtStudentName.ReadOnly = true;
txtStudentNo.ReadOnly = true;
txtStatus.ReadOnly = true;
txtDiscount.Text = assessment.Discount.ToString();
cmbSection.DataSource = _assessmentService.GetSections(assessment.EducationalLevel);
cmbSection.ValueMember = "SectionId";
cmbSection.DisplayMember = "SectionName";
cmbSection.DropDownStyle = System.Windows.Forms.ComboBoxStyle.DropDown;
cmbSection.AutoCompleteMode = AutoCompleteMode.SuggestAppend;
cmbSection.AutoCompleteSource = AutoCompleteSource.ListItems;
cmbEducationLevel.DataSource = _studentService.GetEducationLevel();
cmbEducationLevel.ValueMember = "LevelId";
cmbEducationLevel.DisplayMember = "Level";
cmbEducationLevel.DropDownStyle = System.Windows.Forms.ComboBoxStyle.DropDown;
cmbEducationLevel.AutoCompleteMode = AutoCompleteMode.SuggestAppend;
cmbEducationLevel.AutoCompleteSource = AutoCompleteSource.ListItems;
cmbEducationLevel.ValueMember = "LevelId";
cmbEducationLevel.DisplayMember = "Level";
cmbEducationLevel.DropDownStyle = System.Windows.Forms.ComboBoxStyle.DropDown;
cmbEducationLevel.AutoCompleteMode = AutoCompleteMode.SuggestAppend;
cmbEducationLevel.AutoCompleteSource = AutoCompleteSource.ListItems;
cmbPaymentTerm.DataSource = _paymentService.GetPaymentTerms();
cmbPaymentTerm.ValueMember = "PaymentTermId";
cmbPaymentTerm.DisplayMember = "PaymentDesc";
cmbPaymentTerm.DropDownStyle = System.Windows.Forms.ComboBoxStyle.DropDown;
cmbPaymentTerm.SelectedValue = assessment.PaymentTerm;
cmbPaymentTerm.AutoCompleteMode = AutoCompleteMode.SuggestAppend;
cmbPaymentTerm.AutoCompleteSource = AutoCompleteSource.ListItems;
if (assessment.Status == 2)//if enrolled (status 2) means this is editing
{
cmbSection.SelectedValue = assessment.Section;
cmbEducationLevel.SelectedValue = assessment.EducationalLevel;
txtStatus.Text = "Enrolled";
FillValues();
}
else
{
cmbSection.SelectedIndex = -1;
cmbPaymentTerm.SelectedIndex = 1;
cmbEducationLevel.SelectedIndex = -1;
txtStatus.Text = "On Assessment";
// txtStatus.Text = assessment.Status == 1 ? "On Assessment" : assessment.Status == 2 ? "Enrolled" : "";
}
lastReferralAmt = assessment.ReferralDiscount;
lastSiblingAmt = assessment.SiblingDiscount;
//fill siblings and referral grid
FillReferralsGrid();
FillSiblingsGrid();
txtTotal.Text = assessment.FullAmount.ToString();
}
