public override int GetHashCode()
{
return(PaidCopay.GetHashCode() ^
PaidCoinsurance.GetHashCode() ^
PaidTowardDeductible.GetHashCode() ^
PaidByPayer.GetHashCode() ^
PaidByCoordinationBenefits.GetHashCode() ^
TotalOutOfPocket.GetHashCode() ^
TotalPaid.GetHashCode() ^
PayerPlanPeriodId.GetHashCode() ^
CurrencyConceptId.GetHashCode());
}
public override int GetHashCode()
{
return(PaidCopay.GetHashCode() ^
PaidCoinsurance.GetHashCode() ^
PaidTowardDeductible.GetHashCode() ^
PaidByPayer.GetHashCode() ^
PaidByCoordinationBenefits.GetHashCode() ^
TotalOutOfPocket.GetHashCode() ^
TotalPaid.GetHashCode() ^
IngredientCost.GetHashCode() ^
DispensingFee.GetHashCode() ^
AverageWholesalePrice.GetHashCode() ^
PayerPlanPeriodId.GetHashCode() ^
CurrencyConceptId.GetHashCode());
}
private void TotalPaid_Validating(object sender, CancelEventArgs e)
{
int val1 = 0;
int val2 = 0;
int val3 = 0;
int.TryParse(TotalFees.Text, out val1);
int.TryParse(Fine.Text, out val2);
int.TryParse(TotalPaid.Text, out val3);
if (val3 > val1 + val2)
{
MessageBox.Show("Total Paid can not be more than Total Fees + Fine", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
TotalPaid.Focus();
}
}
private void Update_record_Click(object sender, EventArgs e)
{
if (int.Parse(TotalPaid.Text) > int.Parse(Amount.Text))
{
MessageBox.Show("total paid can not be more than scholarship amount", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
TotalPaid.Text = "";
TotalPaid.Focus();
return;
}
try{
con = new SqlConnection(cs.DBConn);
con.Open();
string cb = "update scholarshippayment set Scholarshipid=@d2,amount=@d5,ScholarNo=@d6,PaymentDate=@d10,PaymentMode=@d11,PaymentModeDetails=@d12,TotalPaid=@d13,DuePayment=@d14 where scholarshippaymentid=@d1";
cmd = new SqlCommand(cb);
cmd.Connection = con;
cmd.Parameters.Add(new SqlParameter("@d1", System.Data.SqlDbType.NChar, 20, "ScholarshipPaymentID"));
cmd.Parameters.Add(new SqlParameter("@d2", System.Data.SqlDbType.Int, 10, "ScholarshipID"));
cmd.Parameters.Add(new SqlParameter("@d5", System.Data.SqlDbType.Int, 10, "Amount"));
cmd.Parameters.Add(new SqlParameter("@d6", System.Data.SqlDbType.NChar, 15, "ScholarNo"));
cmd.Parameters.Add(new SqlParameter("@d10", System.Data.SqlDbType.NChar, 30, "PaymentDate"));
cmd.Parameters.Add(new SqlParameter("@d11", System.Data.SqlDbType.NChar, 20, "PaymentMode"));
cmd.Parameters.Add(new SqlParameter("@d12", System.Data.SqlDbType.VarChar, 200, "PaymentModeDetails"));
cmd.Parameters.Add(new SqlParameter("@d13", System.Data.SqlDbType.Int, 10, "TotalPaid"));
cmd.Parameters.Add(new SqlParameter("@d14", System.Data.SqlDbType.Int, 10, "DueFees"));
cmd.Parameters["@d1"].Value = ScholarshipPaymentID.Text.Trim();
cmd.Parameters["@d2"].Value = ScholarshipID.Text.Trim();
cmd.Parameters["@d5"].Value = Amount.Text.Trim();
cmd.Parameters["@d6"].Value = ScholarNo.Text.Trim();
cmd.Parameters["@d10"].Value = (PaymentDate.Text);
cmd.Parameters["@d11"].Value = (ModeOfPayment.Text);
cmd.Parameters["@d12"].Value = (PaymentModeDetails.Text);
cmd.Parameters["@d13"].Value = (TotalPaid.Text);
cmd.Parameters["@d14"].Value = (DuePayment.Text);
cmd.ExecuteNonQuery();
MessageBox.Show("Successfully updated", "Record", MessageBoxButtons.OK, MessageBoxIcon.Information);
Update_record.Enabled = false;
con.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public override int GetHashCode()
{
return(PaidCopay.GetHashCode() ^
PaidCoinsurance.GetHashCode() ^
PaidTowardDeductible.GetHashCode() ^
PaidByPayer.GetHashCode() ^
PaidByCoordinationBenefits.GetHashCode() ^
TotalOutOfPocket.GetHashCode() ^
TotalPaid.GetHashCode() ^
PayerPlanPeriodId.GetHashCode() ^
DrgConceptId.GetHashCode() ^
RevenueCodeConceptId.GetHashCode() ^
(DrgSourceValue != null ? DrgSourceValue.GetHashCode() : 0) ^
(RevenueCodeSourceValue != null ? RevenueCodeSourceValue.GetHashCode() : 0) ^
CurrencyConceptId.GetHashCode());
}
protected void btnSearch_Click(object sender, EventArgs e)
{
OpBal = 0;
BillAmt = 0;
BillTax = 0;
PaidAmt = 0;
PaidTax = 0;
DueAmt = 0;
TaxDueAmt = 0;
TotalBill = 0;
TotalPaid = 0;
TotalDue = 0;
BusinessLayer.Common.SemFeesGeneration ObjSemFees = new BusinessLayer.Common.SemFeesGeneration();
Entity.Common.SemFeesGeneration SemFees = new Entity.Common.SemFeesGeneration();
if (txtFromDate.Text == "")
{
SemFees.FromDate = null;
}
else
{
SemFees.FromDate = Convert.ToDateTime(txtFromDate.Text);
}
if (txtToDate.Text == "")
{
SemFees.ToDate = null;
}
else
{
SemFees.ToDate = Convert.ToDateTime(txtToDate.Text);
}
SemFees.MembershipCategoryId = int.Parse(ddlMembershipCategory.SelectedValue.Trim());
SemFees.BlockId = int.Parse(ddlBlock.SelectedValue.Trim());
SemFees.DistrictId = int.Parse(ddlDistrict.SelectedValue.Trim());
SemFees.StateId = int.Parse(ddlState.SelectedValue.Trim());
SemFees.Month = ""; // (ddlSubscriptionMonth.SelectedIndex == 0) ? string.Empty : ddlSubscriptionMonth.SelectedValue.Trim();
SemFees.Year = 0; // (ddlSubscriptionYear.SelectedIndex == 0) ? 0 : int.Parse(ddlSubscriptionYear.SelectedValue.Trim());
SemFees.FeesHeadId = int.Parse(ddlFeesHead.SelectedValue.Trim());
DataTable dt = ObjSemFees.GetConsolidated_StudentOutstandingReport(SemFees);
if (dt != null)
{
dgvBill.DataSource = dt;
dgvBill.DataBind();
}
if (dt.Rows.Count > 0)
{
btnDownload.Visible = true;
((Literal)dgvBill.FooterRow.FindControl("ltrTotOpBalAmt")).Text = "<b>" + OpBal.ToString("#0.00") + "</b>";
((Literal)dgvBill.FooterRow.FindControl("ltrTotBillAmt")).Text = "<b>" + BillAmt.ToString("#0.00") + "</b>";
((Literal)dgvBill.FooterRow.FindControl("ltrTotTaxBillAmt")).Text = "<b>" + BillTax.ToString("#0.00") + "</b>";
((Literal)dgvBill.FooterRow.FindControl("ltrTotPaidAmt")).Text = "<b>" + PaidAmt.ToString("#0.00") + "</b>";
((Literal)dgvBill.FooterRow.FindControl("ltrTotTaxPaidAmt")).Text = "<b>" + PaidTax.ToString("#0.00") + "</b>";
((Literal)dgvBill.FooterRow.FindControl("ltrTotDueAmt")).Text = "<b>" + DueAmt.ToString("#0.00") + "</b>";
((Literal)dgvBill.FooterRow.FindControl("ltrTotTaxDueAmt")).Text = "<b>" + TaxDueAmt.ToString("#0.00") + "</b>";
((Literal)dgvBill.FooterRow.FindControl("ltrTotalBill")).Text = "<b>" + TotalBill.ToString("#0.00") + "</b>";
((Literal)dgvBill.FooterRow.FindControl("ltrTotalPaid")).Text = "<b>" + TotalPaid.ToString("#0.00") + "</b>";
((Literal)dgvBill.FooterRow.FindControl("ltrTotalDue")).Text = "<b>" + TotalDue.ToString("#0.00") + "</b>";
}
else
{
btnDownload.Visible = false;
}
}
private void btnSave_Click(object sender, EventArgs e)
{
try
{
if (ScholarshipID.Text == "")
{
MessageBox.Show("Please select Scholarship ID", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
ScholarshipID.Focus();
return;
}
if (ScholarNo.Text == "")
{
MessageBox.Show("Please select Scholar No.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
ScholarNo.Focus();
return;
}
if (ModeOfPayment.Text == "")
{
MessageBox.Show("Please select mode of payment", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
ModeOfPayment.Focus();
return;
}
if (TotalPaid.Text == "")
{
MessageBox.Show("Please enter total paid", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
TotalPaid.Focus();
return;
}
if (int.Parse(TotalPaid.Text) > int.Parse(Amount.Text))
{
MessageBox.Show("total paid can not be more than scholarship amount", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
TotalPaid.Text = "";
TotalPaid.Focus();
return;
}
auto();
con = new SqlConnection(cs);
con.Open();
string ct = "select ScholarshipPaymentID from ScholarshipPayment where ScholarshipPaymentID=@find";
cmd = new SqlCommand(ct);
cmd.Connection = con;
cmd.Parameters.Add(new SqlParameter("@find", System.Data.SqlDbType.NChar, 20, "ScholarshipPaymentID"));
cmd.Parameters["@find"].Value = ScholarshipPaymentID.Text;
rdr = cmd.ExecuteReader();
if (rdr.Read())
{
MessageBox.Show("Scholarship Payment ID Already Exists", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
ScholarshipPaymentID.Text = "";
if ((rdr != null))
{
rdr.Close();
}
return;
}
con = new SqlConnection(cs);
con.Open();
string cb = "insert into ScholarshipPayment(ScholarshipPaymentID,Scholarshipid,Scholarshipname,amount,ScholarNo,StudentName,Course,Branch,PaymentDate,PaymentMode,PaymentModeDetails,TotalPaid,DuePayment) VALUES (@d1,@d2,@d3,@d5,@d6,@d7,@d8,@d9,@d10,@d11,@d12,@d13,@d14)";
cmd = new SqlCommand(cb);
cmd.Connection = con;
cmd.Parameters.Add(new SqlParameter("@d1", System.Data.SqlDbType.NChar, 20, "ScholarshipPaymentID"));
cmd.Parameters.Add(new SqlParameter("@d2", System.Data.SqlDbType.NChar, 20, "ScholarshipID"));
cmd.Parameters.Add(new SqlParameter("@d3", System.Data.SqlDbType.NChar, 30, "Scholarshipname"));
cmd.Parameters.Add(new SqlParameter("@d5", System.Data.SqlDbType.NChar, 10, "Amount"));
cmd.Parameters.Add(new SqlParameter("@d6", System.Data.SqlDbType.NChar, 15, "ScholarNo"));
cmd.Parameters.Add(new SqlParameter("@d7", System.Data.SqlDbType.NChar, 30, "StudentName"));
cmd.Parameters.Add(new SqlParameter("@d8", System.Data.SqlDbType.NChar, 20, "Course"));
cmd.Parameters.Add(new SqlParameter("@d9", System.Data.SqlDbType.NChar, 30, "Branch"));
cmd.Parameters.Add(new SqlParameter("@d10", System.Data.SqlDbType.NChar, 30, "PaymentDate"));
cmd.Parameters.Add(new SqlParameter("@d11", System.Data.SqlDbType.NChar, 20, "PaymentMode"));
cmd.Parameters.Add(new SqlParameter("@d12", System.Data.SqlDbType.VarChar, 200, "PaymentModeDetails"));
cmd.Parameters.Add(new SqlParameter("@d13", System.Data.SqlDbType.NChar, 10, "TotalPaid"));
cmd.Parameters.Add(new SqlParameter("@d14", System.Data.SqlDbType.NChar, 10, "DueFees"));
cmd.Parameters["@d1"].Value = ScholarshipPaymentID.Text.Trim();
cmd.Parameters["@d2"].Value = ScholarshipID.Text.Trim();
cmd.Parameters["@d3"].Value = ScholarshipName.Text.Trim();
cmd.Parameters["@d5"].Value = Amount.Text.Trim();
cmd.Parameters["@d6"].Value = ScholarNo.Text.Trim();
cmd.Parameters["@d7"].Value = StudentName.Text.Trim();
cmd.Parameters["@d8"].Value = Course.Text.Trim();
cmd.Parameters["@d9"].Value = Branch.Text.Trim();
cmd.Parameters["@d10"].Value = (PaymentDate.Text);
cmd.Parameters["@d11"].Value = (ModeOfPayment.Text);
cmd.Parameters["@d12"].Value = (PaymentModeDetails.Text);
cmd.Parameters["@d13"].Value = (TotalPaid.Text);
cmd.Parameters["@d14"].Value = (DuePayment.Text);
cmd.ExecuteNonQuery();
MessageBox.Show("Successfully saved", "Record", MessageBoxButtons.OK, MessageBoxIcon.Information);
btnSave.Enabled = false;
con.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void btnSave_Click(object sender, EventArgs e)
{
try
{
if (ScholarNo.Text == "")
{
MessageBox.Show("Please select Scholar No.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
ScholarNo.Focus();
return;
}
if (FeeID.Text == "")
{
MessageBox.Show("Please select Fee ID", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
FeeID.Focus();
return;
}
if (ModeOfPayment.Text == "")
{
MessageBox.Show("Please select mode of payment", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
ModeOfPayment.Focus();
return;
}
if (TotalPaid.Text == "")
{
MessageBox.Show("Please enter total paid", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
TotalPaid.Focus();
return;
}
con = new SqlConnection(cs.DBConn);
con.Open();
string ct = "select FeeID,ScholarNo from FeePayment where FeeID= '" + FeeID.Text + "' and ScholarNo= '" + ScholarNo.Text + "'";
cmd = new SqlCommand(ct);
cmd.Connection = con;
rdr = cmd.ExecuteReader();
if (rdr.Read())
{
MessageBox.Show("Student already paid fees for this semester", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
Reset();
if ((rdr != null))
{
rdr.Close();
}
return;
}
auto();
con = new SqlConnection(cs.DBConn);
con.Open();
string cb = "insert into feepayment(FeePaymentID,ScholarNo,FeeID,FDCourse,FDBranch,Semester,TutionFees,LibraryFees,UniversityDevelopmentFees,UniversityStudentWelfareFees,CautionMoney,OtherFees,TotalFees,DateOfPayment,ModeOfPayment,PaymentModeDetails,TotalPaid,Fine,DueFees) VALUES (@d1,@d2,@d6,@d7,@d8,@d9,@d10,@d11,@d12,@d13,@d14,@d15,@d16,@d17,@d18,@d19,@d20,@d21,@d22)";
cmd = new SqlCommand(cb);
cmd.Connection = con;
cmd.Parameters.Add(new SqlParameter("@d1", System.Data.SqlDbType.NChar, 20, "FeePaymentID"));
cmd.Parameters.Add(new SqlParameter("@d2", System.Data.SqlDbType.NChar, 15, "ScholarNo"));
cmd.Parameters.Add(new SqlParameter("@d6", System.Data.SqlDbType.NChar, 20, "FeeId"));
cmd.Parameters.Add(new SqlParameter("@d7", System.Data.SqlDbType.NChar, 20, "FDCourse"));
cmd.Parameters.Add(new SqlParameter("@d8", System.Data.SqlDbType.NChar, 30, "FDBranch"));
cmd.Parameters.Add(new SqlParameter("@d9", System.Data.SqlDbType.NChar, 10, "Semester"));
cmd.Parameters.Add(new SqlParameter("@d10", System.Data.SqlDbType.Int, 10, "TutionFees"));
cmd.Parameters.Add(new SqlParameter("@d11", System.Data.SqlDbType.Int, 10, "LibraryFees"));
cmd.Parameters.Add(new SqlParameter("@d12", System.Data.SqlDbType.Int, 10, "UniversityDevelopmentFees"));
cmd.Parameters.Add(new SqlParameter("@d13", System.Data.SqlDbType.Int, 15, "UniversityStudentWelfareFees"));
cmd.Parameters.Add(new SqlParameter("@d14", System.Data.SqlDbType.Int, 10, "CautionMoney"));
cmd.Parameters.Add(new SqlParameter("@d15", System.Data.SqlDbType.Int, 10, "OtherFees"));
cmd.Parameters.Add(new SqlParameter("@d16", System.Data.SqlDbType.Int, 10, "TotalFees"));
cmd.Parameters.Add(new SqlParameter("@d17", System.Data.SqlDbType.NChar, 30, "DateOfPayment"));
cmd.Parameters.Add(new SqlParameter("@d18", System.Data.SqlDbType.NChar, 20, "ModeOfPayment"));
cmd.Parameters.Add(new SqlParameter("@d19", System.Data.SqlDbType.VarChar, 200, "PaymentModeDetails"));
cmd.Parameters.Add(new SqlParameter("@d20", System.Data.SqlDbType.Int, 10, "TotalPaid"));
cmd.Parameters.Add(new SqlParameter("@d21", System.Data.SqlDbType.Int, 10, "Fine"));
cmd.Parameters.Add(new SqlParameter("@d22", System.Data.SqlDbType.Int, 10, "DueFees"));
cmd.Parameters["@d1"].Value = FeePaymentID.Text.Trim();
cmd.Parameters["@d2"].Value = ScholarNo.Text.Trim();
cmd.Parameters["@d6"].Value = FeeID.Text.Trim();
cmd.Parameters["@d7"].Value = FDCourse.Text.Trim();
cmd.Parameters["@d8"].Value = FDBranch.Text.Trim();
cmd.Parameters["@d9"].Value = Semester.Text.Trim();
cmd.Parameters["@d10"].Value = Convert.ToInt32(TutionFees.Text);
cmd.Parameters["@d11"].Value = Convert.ToInt32(LibraryFees.Text);
cmd.Parameters["@d12"].Value = Convert.ToInt32(UDFees.Text);
cmd.Parameters["@d13"].Value = Convert.ToInt32(USFees.Text);
if (Semester.Text == "1st")
{
cmd.Parameters["@d14"].Value = Convert.ToInt32(CautionMoney.Text);
}
else
{
cmd.Parameters["@d14"].Value = 0;
}
cmd.Parameters["@d15"].Value = Convert.ToInt32(OtherFees.Text);
cmd.Parameters["@d16"].Value = Convert.ToInt32(TotalFees.Text);
cmd.Parameters["@d17"].Value = (PaymentDate.Text);
cmd.Parameters["@d18"].Value = (ModeOfPayment.Text);
cmd.Parameters["@d19"].Value = (PaymentModeDetails.Text);
cmd.Parameters["@d20"].Value = Convert.ToInt32(TotalPaid.Text);
if (Fine.Text == "")
{
cmd.Parameters["@d21"].Value = 0;
}
else
{
cmd.Parameters["@d21"].Value = Convert.ToInt32(Fine.Text);
}
cmd.Parameters["@d22"].Value = Convert.ToInt32(DueFees.Text);
cmd.ExecuteNonQuery();
MessageBox.Show("Successfully saved", "Fees Payment Record", MessageBoxButtons.OK, MessageBoxIcon.Information);
btnSave.Enabled = false;
Print.Enabled = true;
con.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void btnSave_Click(object sender, EventArgs e)
{
try
{
if (ScholarNo.Text == "")
{
MessageBox.Show("Please select Scholar No.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
ScholarNo.Focus();
return;
}
if (ModeOfPayment.Text == "")
{
MessageBox.Show("Please select mode of payment", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
ModeOfPayment.Focus();
return;
}
if (TotalPaid.Text == "")
{
MessageBox.Show("Please enter total paid", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
TotalPaid.Focus();
return;
}
auto();
con = new SqlConnection(cs.DBConn);
con.Open();
string cb = "insert into BusFeePayment(FeePaymentID,ScholarNo,BusCharges,DateOfPayment,ModeOfPayment,PaymentModeDetails,TotalPaid,Fine,DueFees) VALUES (@d1,@d2,@d3,@d4,@d5,@d6,@d7,@d8,@d9)";
cmd = new SqlCommand(cb);
cmd.Connection = con;
cmd.Parameters.Add(new SqlParameter("@d1", System.Data.SqlDbType.NChar, 20, "FeePaymentID"));
cmd.Parameters.Add(new SqlParameter("@d2", System.Data.SqlDbType.NChar, 15, "ScholarNo"));
cmd.Parameters.Add(new SqlParameter("@d3", System.Data.SqlDbType.Int, 10, "BusCharges"));
cmd.Parameters.Add(new SqlParameter("@d4", System.Data.SqlDbType.NChar, 30, "DateOfPayment"));
cmd.Parameters.Add(new SqlParameter("@d5", System.Data.SqlDbType.NChar, 20, "ModeOfPayment"));
cmd.Parameters.Add(new SqlParameter("@d6", System.Data.SqlDbType.VarChar, 200, "PaymentModeDetails"));
cmd.Parameters.Add(new SqlParameter("@d7", System.Data.SqlDbType.Int, 10, "TotalPaid"));
cmd.Parameters.Add(new SqlParameter("@d8", System.Data.SqlDbType.Int, 10, "Fine"));
cmd.Parameters.Add(new SqlParameter("@d9", System.Data.SqlDbType.Int, 10, "DueFees"));
cmd.Parameters["@d1"].Value = FeePaymentID.Text.Trim();
cmd.Parameters["@d2"].Value = ScholarNo.Text.Trim();
cmd.Parameters["@d3"].Value = Convert.ToInt32(txtBusCharges.Text);
cmd.Parameters["@d4"].Value = (PaymentDate.Text);
cmd.Parameters["@d5"].Value = (ModeOfPayment.Text);
cmd.Parameters["@d6"].Value = (PaymentModeDetails.Text);
cmd.Parameters["@d7"].Value = Convert.ToInt32(TotalPaid.Text);
if (Fine.Text == "")
{
cmd.Parameters["@d8"].Value = 0;
}
else
{
cmd.Parameters["@d8"].Value = Convert.ToInt32(Fine.Text);
}
cmd.Parameters["@d9"].Value = Convert.ToInt32(DueFees.Text);
cmd.ExecuteNonQuery();
MessageBox.Show("Successfully saved", "Record", MessageBoxButtons.OK, MessageBoxIcon.Information);
btnSave.Enabled = false;
Print.Enabled = true;
con.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
