protected void btnAdd_Click(object sender, EventArgs e)
{
if (StudentCodeVarification())
{
foreach (GridViewRow gr in gvFeesAdd.Rows)
{
TextBox txtSubmissionDate = (TextBox)gr.FindControl("txtSubmissionDate");
TextBox txtAmount = (TextBox)gr.FindControl("txtAmount");
HiddenField hfFeesID = (HiddenField)gr.FindControl("hfFeesID");
STD_Fees sTD_Fees = new STD_Fees();
sTD_Fees.FeesName = txtFeesName.Text;
sTD_Fees.Amount = decimal.Parse(txtAmount.Text);
sTD_Fees.FeesTypeID = 1; //installment
sTD_Fees.SubmissionDate = DateTime.Parse(txtSubmissionDate.Text);
sTD_Fees.SubmitedDate = "";
sTD_Fees.StudentID = hfStudentID.Value;
sTD_Fees.CourseID = int.Parse(ddlCourseID.SelectedValue);
sTD_Fees.AddedBy = Profile.card_id;
sTD_Fees.AddedDate = DateTime.Now;
sTD_Fees.UpdatedBy = Profile.card_id;
sTD_Fees.UpdateDate = DateTime.Now;
sTD_Fees.RowStatusID = int.Parse("1");
sTD_Fees.Remarks = txtRemarks.Text;
sTD_Fees.IsPaid = false;
int resutl = STD_FeesManager.InsertSTD_Fees(sTD_Fees);
}
btnAdd.Visible = false;
showSTD_FeesDataByStudentIDnCourseID();
divAddNewInstallment.Visible = false;
divShowInstallment.Visible = true;
}
}
protected void btnAdd_Click(object sender, EventArgs e)
{
STD_Fees sTD_Fees = new STD_Fees ();
// sTD_Fees.FeesID= int.Parse(ddlFeesID.SelectedValue);
sTD_Fees.FeesName = "";//txtFeesName.Text;
sTD_Fees.Amount= decimal.Parse(txtAmount.Text);
sTD_Fees.FeesTypeID = int.Parse(Request.QueryString["FeesTypeID"]);
sTD_Fees.SubmissionDate= DateTime.Now;
sTD_Fees.SubmitedDate = DateTime.Now.ToString();
sTD_Fees.StudentID= ddlStudentID.SelectedValue;
sTD_Fees.CourseID= int.Parse(ddlCourseID.SelectedValue);
sTD_Fees.AddedBy= Profile.card_id;
sTD_Fees.AddedDate= DateTime.Now;
sTD_Fees.UpdatedBy= Profile.card_id;
sTD_Fees.UpdateDate= DateTime.Now;
sTD_Fees.RowStatusID= 1;
sTD_Fees.Remarks= txtRemarks.Text;
sTD_Fees.IsPaid= true;
int resutl =STD_FeesManager.InsertSTD_Fees(sTD_Fees);
if (chkNextSubmission.Checked)
{
sTD_Fees.SubmissionDate = DateTime.Parse(txtNextSubmissionDate.Text);
sTD_Fees.SubmitedDate = "";
sTD_Fees.IsPaid = false;
resutl = STD_FeesManager.InsertSTD_Fees(sTD_Fees);
}
//Response.Redirect("AdminDisplaySTD_Fees.aspx");
}
protected void btnAddInstallment_Click(object sender, EventArgs e)
{
STD_Fees fee = new STD_Fees();
fee.FeesID = int.Parse(txtNoOfInstallment.Text) + 1;
txtNoOfInstallment.Text = fee.FeesID.ToString();
fee.Amount = decimal.Parse(txtAmountEdit.Text) ;
fee.UnpaidAmount = fee.Amount;
fee.Remarks = "0";
fee.SubmissionDate = DateTime.Parse(txtSubmissionDateEdit.Text);
fee.IsPaid = true;
List<STD_Fees> fees = new List<STD_Fees>();
fees = (List<STD_Fees>)Session["fees"];
fees.Add(fee);
gvFeesAdd.DataSource = fees;
gvFeesAdd.DataBind();
}
protected void btnGridGenerator_Click(object sender, EventArgs e)
{
try
{
List<STD_Fees> fees = new List<STD_Fees>();
fees = new List<STD_Fees>();
int j = 0;
for (int i = 0; i < int.Parse(txtNoOfInstallment.Text); i++)
{
STD_Fees fee = new STD_Fees();
fee.FeesID = i;
fee.SubmissionDate = txtInstallmentDuration.Text != "" ? DateTime.Now.AddDays((i * int.Parse(txtInstallmentDuration.Text))) : DateTime.Now;
if (txtDiscount.Text != "" && j == 0 && decimal.Parse(txtInstallmentAmount.Text) > decimal.Parse(txtDiscount.Text))
{
fee.Amount = decimal.Parse(txtInstallmentAmount.Text) - (decimal.Parse(txtInstallmentAmount.Text) * decimal.Parse(txtDiscount.Text)) / 100;
j++;
}
else
{
fee.Amount = decimal.Parse(txtInstallmentAmount.Text);
}
fee.IsPaid = false;
fee.IsEnabled = false;
fees.Add(fee);
}
Session["fees"] = fees;
gvFeesAdd.DataSource = fees;
gvFeesAdd.DataBind();
btnAdd.Visible = true;
divAddNewInstallment.Visible = true;
}
catch (Exception ex)
{
}
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
STD_Fees sTD_Fees = new STD_Fees ();
sTD_Fees.FeesID= int.Parse(Request.QueryString["ID"].ToString());
sTD_Fees.FeesName= txtFeesName.Text;
sTD_Fees.Amount= decimal.Parse(txtAmount.Text);
sTD_Fees.FeesTypeID= int.Parse(ddlFeesTypeID.SelectedValue);
sTD_Fees.SubmissionDate= DateTime.Parse(txtSubmissionDate.Text);
sTD_Fees.SubmitedDate= txtSubmitedDate.Text;
sTD_Fees.StudentID= ddlStudentID.SelectedValue;
sTD_Fees.CourseID= int.Parse(ddlCourseID.SelectedValue);
sTD_Fees.AddedBy= Profile.card_id;
sTD_Fees.AddedDate= DateTime.Now;
sTD_Fees.UpdatedBy= Profile.card_id;
sTD_Fees.UpdateDate= DateTime.Now;
sTD_Fees.RowStatusID= int.Parse(ddlRowStatusID.SelectedValue);
sTD_Fees.Remarks= txtRemarks.Text;
sTD_Fees.IsPaid= bool.Parse( radIsPaid.SelectedValue);
bool resutl =STD_FeesManager.UpdateSTD_Fees(sTD_Fees);
Response.Redirect("AdminDisplaySTD_Fees.aspx");
}
public static int InsertSTD_Fees(STD_Fees sTD_Fees)
{
SqlSTD_FeesProvider sqlSTD_FeesProvider = new SqlSTD_FeesProvider();
return sqlSTD_FeesProvider.InsertSTD_Fees(sTD_Fees);
}
public static STD_Fees GetSTD_RowStatusByRowStatusID(int RowStatusID)
{
STD_Fees sTD_Fees = new STD_Fees();
SqlSTD_FeesProvider sqlSTD_FeesProvider = new SqlSTD_FeesProvider();
sTD_Fees = sqlSTD_FeesProvider.GetSTD_FeesByRowStatusID(RowStatusID);
return sTD_Fees;
}
public bool UpdateSTD_Fees(STD_Fees sTD_Fees)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("UpdateSTD_Fees", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@FeesID", SqlDbType.Int).Value = sTD_Fees.FeesID;
cmd.Parameters.Add("@FeesName", SqlDbType.NVarChar).Value = sTD_Fees.FeesName;
cmd.Parameters.Add("@Amount", SqlDbType.Decimal).Value = sTD_Fees.Amount;
cmd.Parameters.Add("@FeesTypeID", SqlDbType.Int).Value = sTD_Fees.FeesTypeID;
cmd.Parameters.Add("@SubmissionDate", SqlDbType.DateTime).Value = sTD_Fees.SubmissionDate;
cmd.Parameters.Add("@SubmitedDate", SqlDbType.NVarChar).Value = sTD_Fees.SubmitedDate;
cmd.Parameters.Add("@StudentID", SqlDbType.NVarChar).Value = sTD_Fees.StudentID;
cmd.Parameters.Add("@CourseID", SqlDbType.Int).Value = sTD_Fees.CourseID;
cmd.Parameters.Add("@UpdatedBy", SqlDbType.NVarChar).Value = sTD_Fees.UpdatedBy;
cmd.Parameters.Add("@UpdateDate", SqlDbType.DateTime).Value = sTD_Fees.UpdateDate;
cmd.Parameters.Add("@RowStatusID", SqlDbType.Int).Value = sTD_Fees.RowStatusID;
cmd.Parameters.Add("@Remarks", SqlDbType.NText).Value = sTD_Fees.Remarks;
cmd.Parameters.Add("@IsPaid", SqlDbType.Bit).Value = sTD_Fees.IsPaid;
connection.Open();
int result = cmd.ExecuteNonQuery();
return result == 1;
}
}
private void showSTD_FeesData()
{
STD_Fees sTD_Fees = new STD_Fees ();
sTD_Fees = STD_FeesManager.GetSTD_FeesByFeesID(Int32.Parse(Request.QueryString["ID"]));
//txtFeesName.Text =sTD_Fees.FeesName.ToString();
txtAmount.Text =sTD_Fees.Amount.ToString();
//ddlFeesTypeID.SelectedValue =sTD_Fees.FeesTypeID.ToString();
//txtSubmissionDate.Text =sTD_Fees.SubmissionDate.ToString();
//txtSubmitedDate.Text =sTD_Fees.SubmitedDate.ToString();
ddlStudentID.SelectedValue =sTD_Fees.StudentID.ToString();
ddlCourseID.SelectedValue =sTD_Fees.CourseID.ToString();
//ddlRowStatusID.SelectedValue =sTD_Fees.RowStatusID.ToString();
txtRemarks.Text =sTD_Fees.Remarks.ToString();
//radIsPaid.SelectedValue =sTD_Fees.IsPaid.ToString();
}
protected void lbPartiallyPaid_Click(object sender, EventArgs e)
{
Button linkButton = new Button();
linkButton = (Button)sender;
int id;
id = Convert.ToInt32(linkButton.CommandArgument);
//update the exiting 1
decimal amountRemaining = 0;
STD_Fees sTD_FeesUpdate = new STD_Fees();
STD_Fees sTD_FeesNew = new STD_Fees();
sTD_FeesUpdate = STD_FeesManager.GetSTD_FeesByFeesID(id);
amountRemaining = sTD_FeesUpdate.Amount;
sTD_FeesUpdate.IsPaid = true;
sTD_FeesUpdate.SubmitedDate = DateTime.Today.ToString();
sTD_FeesUpdate.Amount = getPartialPaymentByFeesID(id);
amountRemaining -= sTD_FeesUpdate.Amount;
sTD_FeesUpdate.UpdatedBy = Profile.card_id;
sTD_FeesUpdate.UpdateDate = DateTime.Now;
sTD_FeesUpdate.RowStatusID = int.Parse("1");
sTD_FeesUpdate.Remarks = "Partially payment";
bool resutl = STD_FeesManager.UpdateSTD_Fees(sTD_FeesUpdate);
//Add a new row
sTD_FeesNew = sTD_FeesUpdate;
sTD_FeesNew.Amount = amountRemaining;
sTD_FeesNew.SubmissionDate = getRemainingDateByFeesID(id);
sTD_FeesNew.SubmitedDate = "";
sTD_FeesNew.AddedBy = Profile.card_id;
sTD_FeesNew.AddedDate = DateTime.Now;
sTD_FeesNew.Remarks = "Partially payment done but someting remaining";
sTD_FeesNew.IsPaid = false;
STD_FeesManager.InsertSTD_Fees(sTD_FeesNew);
showSTD_FeesDataByStudentIDnCourseID();
}
protected void btnAdd_Click(object sender, EventArgs e)
{
if (ddlCourseIDReceived.SelectedIndex == 0)
{
ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "Message", "alert('Plase Select the Program from top')", true);
return;
}
if (hfStudentID.Value != "" && ddlAccountID.SelectedValue!="0")
{
STD_FeesMaster sTD_FeesMaster = new STD_FeesMaster();
sTD_FeesMaster = insertFeesMaster(int.Parse(ddlAccountID.SelectedValue));
if (ddlAccountID.SelectedValue == "31" || ddlAccountID.SelectedValue == "57")//installment fees and Paper wise fee
{
hfIsAdmissionFees.Value = "1";
}
if (ddlAccountID.SelectedValue == "31")//installment fees
{
foreach (GridViewRow gr in gvFeesAdd.Rows)
{
TextBox txtSubmissionDate = (TextBox)gr.FindControl("txtSubmissionDate");
TextBox txtAmount = (TextBox)gr.FindControl("txtAmount");
HiddenField hfFeesID = (HiddenField)gr.FindControl("hfFeesID");
STD_Fees sTD_Fees = new STD_Fees();
sTD_Fees.FeesName = sTD_FeesMaster.FeesMasterID.ToString();//it will be fees masterID
sTD_Fees.Amount = decimal.Parse(txtAmount.Text);
sTD_Fees.FeesTypeID = 1; //installment
sTD_Fees.SubmissionDate = DateTime.Parse(txtSubmissionDate.Text);
sTD_Fees.SubmitedDate = "";
sTD_Fees.StudentID = hfStudentID.Value;
sTD_Fees.CourseID = int.Parse(ddlCourseIDReceived.SelectedValue);
sTD_Fees.AddedBy = Profile.card_id;
sTD_Fees.AddedDate = DateTime.Now;
sTD_Fees.UpdatedBy = Profile.card_id;
sTD_Fees.UpdateDate = DateTime.Now;
sTD_Fees.RowStatusID = int.Parse("1");
sTD_Fees.Remarks = "0";
if (decimal.Parse(txtAmount.Text) != decimal.Parse("0"))
{ sTD_Fees.IsPaid = false; }
else
sTD_Fees.IsPaid = true;
int resutl = STD_FeesManager.InsertSTD_Fees(sTD_Fees);
}
}
else
{
////add in the FeesMaster
//STD_FeesMaster sTD_FeesMaster = new STD_FeesMaster();
//// sTD_FeesMaster.FeesMasterID= int.Parse(ddlFeesMasterID.SelectedValue);
//sTD_FeesMaster.FeesMasterName = "";
//sTD_FeesMaster.TotalPayment = decimal.Parse(txtTotalAmount.Text);
//sTD_FeesMaster.Discount = decimal.Parse(txtDiscount.Text);
//sTD_FeesMaster.TotalPaymentNeedtoPay = decimal.Parse(txtTotalAmountNeedToPay.Text);
//sTD_FeesMaster.FeesTypeID = int.Parse(ddlAccountID.SelectedValue);
//sTD_FeesMaster.SubmissionDate = DateTime.Today;
//sTD_FeesMaster.SubmitedDate = "";
//sTD_FeesMaster.StudentID = hfStudentID.Value;
//sTD_FeesMaster.CourseID = int.Parse(ddlCourseIDReceived.SelectedValue);
//sTD_FeesMaster.Remarks = txtRemarks.Text;
//sTD_FeesMaster.IsPaid = false;
//sTD_FeesMaster.PaymentStatusID = int.Parse("1");
//sTD_FeesMaster.ExtraField1 = "0";
//sTD_FeesMaster.ExtraField2 = txtTotalAmountNeedToPay.Text;
//sTD_FeesMaster.ExtraField3 = "";
//sTD_FeesMaster.ExtraField4 = "";
//sTD_FeesMaster.ExtraField5 = "";
//sTD_FeesMaster.AddedBy = Profile.card_id;
//sTD_FeesMaster.AddedDate = DateTime.Now;
//sTD_FeesMaster.UpdatedBy = Profile.card_id;
//sTD_FeesMaster.UpdateDate = DateTime.Now;
//sTD_FeesMaster.RowStatusID = int.Parse("1");
//sTD_FeesMaster.FeesMasterID = STD_FeesMasterManager.InsertSTD_FeesMaster(sTD_FeesMaster);
STD_Fees sTD_Fees = new STD_Fees();
sTD_Fees.FeesName = sTD_FeesMaster.FeesMasterID.ToString();//it will be fees masterID
sTD_Fees.Amount = decimal.Parse(txtTotalAmountNeedToPay.Text);
sTD_Fees.FeesTypeID = 1; //installment
sTD_Fees.SubmissionDate = DateTime.Today;
sTD_Fees.SubmitedDate = "";
sTD_Fees.StudentID = hfStudentID.Value;
sTD_Fees.CourseID = int.Parse(ddlCourseIDReceived.SelectedValue);
sTD_Fees.AddedBy = Profile.card_id;
sTD_Fees.AddedDate = DateTime.Now;
sTD_Fees.UpdatedBy = Profile.card_id;
sTD_Fees.UpdateDate = DateTime.Now;
sTD_Fees.RowStatusID = int.Parse("1");
sTD_Fees.Remarks = "0";
sTD_Fees.IsPaid = false;
sTD_Fees.FeesID = STD_FeesManager.InsertSTD_Fees(sTD_Fees);
}
}
//btnAdd.Visible = false;
showFeesMaster();
showSTD_FeesDataByStudentIDnCourseID();
divAddNewInstallment.Visible = false;
divShowInstallment.Visible = true;
}
protected void btnGridGenerator_Click(object sender, EventArgs e)
{
try
{
//calculateTotal();
List<STD_Fees> fees = new List<STD_Fees>();
fees = new List<STD_Fees>();
decimal discount = decimal.Parse(txtDiscount.Text);
int j = 0;
lblDiscountMessage.Text = "";
//txtInstallmentAmount.Text = ((decimal.Parse(txtTotalAmountNeedToPay.Text) - decimal.Parse(txtInitialPaymentAmount.Text)) / decimal.Parse(txtNoOfInstallment.Text)).ToString();
for (int i = 0; i <= int.Parse(txtNoOfInstallment.Text); i++)
{
STD_Fees fee = new STD_Fees();
fee.FeesID = i;
if (i == 0)
{
fee.SubmissionDate = DateTime.Today;
fee.Amount = decimal.Parse(txtInitialPaymentAmount.Text);
}
else
if (i == 1)
{
fee.SubmissionDate = txtInstallmentDuration.Text != "" ? DateTime.Now.AddMonths(((i) * int.Parse(txtInstallmentDuration.Text))) : DateTime.Now;
fee.Amount = decimal.Parse(txtTotalAmountNeedToPay.Text) - (decimal.Parse(txtInstallmentAmount.Text) * (decimal.Parse(txtNoOfInstallment.Text) - 1)) - decimal.Parse(txtInitialPaymentAmount.Text);
}
else
{
fee.Amount = decimal.Parse(txtInstallmentAmount.Text);
fee.SubmissionDate = txtInstallmentDuration.Text != "" ? DateTime.Now.AddMonths(((i) * int.Parse(txtInstallmentDuration.Text))) : DateTime.Now;
}
//if (txtDiscount.Text != "" && j == 0 && decimal.Parse(txtInstallmentAmount.Text) > decimal.Parse(txtDiscount.Text))
//{
// fee.Amount = decimal.Parse(txtInstallmentAmount.Text) - (decimal.Parse(txtInstallmentAmount.Text) * decimal.Parse(txtDiscount.Text)) / 100;
// j++;
//}
//else
//{
/*
if (discount < decimal.Parse(txtInstallmentAmount.Text))
{
fee.Amount = decimal.Parse(txtInstallmentAmount.Text) - discount;
if (discount != 0)
lblDiscountMessage.Text += "From the installment # " + (i + 1).ToString() + " we have diducted the discount</br>";
discount = 0;
}
else
{
discount -= decimal.Parse(txtInstallmentAmount.Text);
lblDiscountMessage.Text += "installment # " + (i + 1).ToString() + " has not added because of the discount is bigger than the installment value. </br>";
i--;
txtNoOfInstallment.Text = (int.Parse(txtNoOfInstallment.Text) - 1).ToString();
continue;
}
*/
//fee.Amount = decimal.Parse(txtInstallmentAmount.Text);
//}
fee.IsPaid = false;
fee.IsEnabled = false;
fees.Add(fee);
}
Session["fees"] = fees;
gvFeesAdd.DataSource = fees;
gvFeesAdd.DataBind();
//btnAdd.Visible = true;
divAddNewInstallment.Visible = true;
}
catch (Exception ex)
{
}
}
public static bool UpdateSTD_Fees(STD_Fees sTD_Fees)
{
SqlSTD_FeesProvider sqlSTD_FeesProvider = new SqlSTD_FeesProvider();
return sqlSTD_FeesProvider.UpdateSTD_Fees(sTD_Fees);
}
protected void btnGridGenerator_Click(object sender, EventArgs e)
{
try
{
//calculateTotal();
List<STD_Fees> fees = new List<STD_Fees>();
fees = new List<STD_Fees>();
decimal discount = decimal.Parse(txtDiscount.Text);
int j = 0;
lblDiscountMessage.Text = "";
//txtInstallmentAmount.Text = ((decimal.Parse(txtTotalAmountNeedToPay.Text) - decimal.Parse(txtInitialPaymentAmount.Text)) / decimal.Parse(txtNoOfInstallment.Text)).ToString();
DataSet dsFeesByStudentIDnCourseID = STD_FeesManager.GetSTD_FeesListByFeesMasterID(hfFeesMasterIDEdit.Value);
if (dsFeesByStudentIDnCourseID != null)
{
fees = new List<STD_Fees>();
decimal due = 0;
decimal unpaid = 0;
txtNoOfInstallment.Text = dsFeesByStudentIDnCourseID.Tables[0].Rows.Count.ToString();
foreach (DataRow drFeesByStudentIDnCourseID in dsFeesByStudentIDnCourseID.Tables[0].Rows)
{
STD_Fees sTD_Fees = new STD_Fees();
sTD_Fees.FeesID = int.Parse(drFeesByStudentIDnCourseID["FeesID"].ToString());
sTD_Fees.FeesName = drFeesByStudentIDnCourseID["FeesName"].ToString();
sTD_Fees.Amount = decimal.Parse(drFeesByStudentIDnCourseID["Amount"].ToString());
sTD_Fees.FeesTypeID = int.Parse(drFeesByStudentIDnCourseID["FeesTypeID"].ToString());
sTD_Fees.SubmissionDate = DateTime.Parse(drFeesByStudentIDnCourseID["SubmissionDate"].ToString());
sTD_Fees.SubmitedDate = drFeesByStudentIDnCourseID["SubmitedDate"].ToString();
sTD_Fees.StudentID = Request.QueryString["StudentID"];
sTD_Fees.CourseID = int.Parse(Request.QueryString["CourseID"]);
sTD_Fees.AddedBy = drFeesByStudentIDnCourseID["AddedBy"].ToString();
sTD_Fees.AddedDate = DateTime.Parse(drFeesByStudentIDnCourseID["AddedDate"].ToString());
sTD_Fees.UpdatedBy = Profile.card_id;
sTD_Fees.UpdateDate = DateTime.Now;
sTD_Fees.RowStatusID = int.Parse(drFeesByStudentIDnCourseID["RowStatusID"].ToString()); ;
sTD_Fees.Remarks = drFeesByStudentIDnCourseID["Remarks"].ToString();
sTD_Fees.IsPaid = !bool.Parse(drFeesByStudentIDnCourseID["IsPaid"].ToString());
sTD_Fees.UnpaidAmount = sTD_Fees.Amount - decimal.Parse(sTD_Fees.Remarks);
if (!sTD_Fees.IsPaid)
{
if (sTD_Fees.SubmissionDate > DateTime.Today)
{
sTD_Fees.PaymentStatus = "<b style='color:Blue;'>UnPaid</b>";
unpaid += sTD_Fees.UnpaidAmount;
}
else
{
sTD_Fees.PaymentStatus = "<b style='color:Red;'>Due</b>";
due += sTD_Fees.UnpaidAmount;
}
}
else
{
if (sTD_Fees.Amount == decimal.Parse(sTD_Fees.Remarks))
{
sTD_Fees.PaymentStatus = "<b style='color:Green;'>Paid</b>";
}
else
{
if (sTD_Fees.SubmissionDate > DateTime.Today)
{
sTD_Fees.PaymentStatus = "<b style='color:Blue;'>Partially Unpaid</b>";
unpaid += sTD_Fees.UnpaidAmount;
}
else
{
sTD_Fees.PaymentStatus = "<b style='color:Red;'>Partially Due</b>";
due += sTD_Fees.UnpaidAmount;
}
}
}
//sTD_Fees.PaymentStatus = sTD_Fees.IsPaid ? "<b style='color:Green;'>Paid</b>" : "<b style='color:Red;'>Unpaid</b>";
sTD_Fees.IsEnabled = !sTD_Fees.IsPaid;
fees.Add(sTD_Fees);
}
Session["fees"] = fees;
}
Session["fees"] = fees;
gvFeesAdd.DataSource = fees;
gvFeesAdd.DataBind();
//btnAdd.Visible = true;
divAddNewInstallment.Visible = true;
}
catch (Exception ex)
{
}
}
protected void btnPayAdvance_Click(object sender, EventArgs e)
{
try
{
decimal paymentAmount = Convert.ToDecimal(txtPaymentAmount.Text);
foreach (GridViewRow row in gvFeesShow.Rows)
{
bool isPaid = Convert.ToBoolean(((CheckBox)row.FindControl("chkIspaid")).Checked);
if (!isPaid)
{
int feesID = Convert.ToInt32(((HiddenField)row.FindControl("hfFeesID")).Value);
STD_Fees currentFee = STD_FeesManager.GetSTD_FeesByFeesID(feesID);
if (paymentAmount >= currentFee.Amount)
{
#region Fully Payment
paymentAmount -= currentFee.Amount;
currentFee.IsPaid = true;
currentFee.SubmitedDate = DateTime.Today.ToString();
currentFee.UpdatedBy = Profile.card_id;
currentFee.UpdateDate = DateTime.Now;
currentFee.RowStatusID = int.Parse("1");
currentFee.Remarks = "Fully paid";
bool resutl = STD_FeesManager.UpdateSTD_Fees(currentFee);
#endregion
}
else if (paymentAmount > 0)
{
#region Partial Payment
decimal amountRemaining = currentFee.Amount - paymentAmount;
currentFee.IsPaid = true;
currentFee.SubmitedDate = DateTime.Today.ToString();
currentFee.Amount = paymentAmount;
currentFee.UpdatedBy = Profile.card_id;
currentFee.UpdateDate = DateTime.Now;
currentFee.RowStatusID = int.Parse("1");
currentFee.Remarks = "Partially Paid";
bool resutl = STD_FeesManager.UpdateSTD_Fees(currentFee);
//Add a new row
STD_Fees newFee = new STD_Fees();
newFee = currentFee;
newFee.Amount = amountRemaining;
newFee.SubmissionDate = currentFee.SubmissionDate.AddMonths(1);// 1 Month Later, Default
newFee.SubmitedDate = "";
newFee.AddedBy = Profile.card_id;
newFee.AddedDate = DateTime.Now;
newFee.Remarks = "Partially payment done but Something remaining";
newFee.IsPaid = false;
STD_FeesManager.InsertSTD_Fees(newFee);
#endregion
paymentAmount = 0;
break;
}
}
}
txtPaymentAmount.Text = "";
showSTD_FeesDataByStudentIDnCourseID();
}
catch (Exception ex)
{
}
}
private void showSTD_FeesDataByStudentIDnCourseID()
{
try
{
string studentID = Request.QueryString["StudentID"] == null ? hfStudentID.Value : Request.QueryString["StudentID"];
string courseID = Request.QueryString["CourseID"] == null ? ddlCourseID.SelectedValue : Request.QueryString["CourseID"];
if (txtStudentCode.Text == "")
{
txtStudentCode.Text = STD_StudentManager.GetSTD_StudentByStudentID(studentID).StudentCode;
txtStudentCodeSearch.Text = txtStudentCode.Text;
}
DataSet dsFeesByStudentIDnCourseID = STD_FeesManager.GetSTD_StudentByStudentID(studentID, int.Parse(courseID));
if (dsFeesByStudentIDnCourseID != null)
{
if (dsFeesByStudentIDnCourseID.Tables[0].Rows.Count == 0)
{
lblMessageForList.Text = "No Installment has fixed before for that Student ID and Course";
}
List<STD_Fees> fees = new List<STD_Fees>();
fees = new List<STD_Fees>();
foreach (DataRow drFeesByStudentIDnCourseID in dsFeesByStudentIDnCourseID.Tables[0].Rows)
{
STD_Fees sTD_Fees = new STD_Fees();
sTD_Fees.FeesID = int.Parse(drFeesByStudentIDnCourseID["FeesID"].ToString());
sTD_Fees.FeesName = drFeesByStudentIDnCourseID["FeesName"].ToString();
sTD_Fees.Amount = decimal.Parse(drFeesByStudentIDnCourseID["Amount"].ToString());
sTD_Fees.FeesTypeID = int.Parse(drFeesByStudentIDnCourseID["FeesTypeID"].ToString());
sTD_Fees.SubmissionDate = DateTime.Parse(drFeesByStudentIDnCourseID["SubmissionDate"].ToString());
sTD_Fees.SubmitedDate = drFeesByStudentIDnCourseID["SubmitedDate"].ToString();
sTD_Fees.StudentID = studentID;
sTD_Fees.CourseID = int.Parse(courseID);
sTD_Fees.AddedBy = drFeesByStudentIDnCourseID["AddedBy"].ToString();
sTD_Fees.AddedDate = DateTime.Parse(drFeesByStudentIDnCourseID["AddedDate"].ToString());
sTD_Fees.UpdatedBy = Profile.card_id;
sTD_Fees.UpdateDate = DateTime.Now;
sTD_Fees.RowStatusID = int.Parse(drFeesByStudentIDnCourseID["RowStatusID"].ToString()); ;
sTD_Fees.Remarks = drFeesByStudentIDnCourseID["Remarks"].ToString();
sTD_Fees.IsPaid = bool.Parse(drFeesByStudentIDnCourseID["IsPaid"].ToString());
sTD_Fees.IsEnabled = !sTD_Fees.IsPaid;
fees.Add(sTD_Fees);
}
Session["fees"] = fees;
gvFeesShow.DataSource = fees;
gvFeesShow.DataBind();
}
else
{
lblMessageForList.Text = "No Installment has fixed before for that Student ID and Course";
}
//ddlFeesTypeID.SelectedValue = fees[0].FeesTypeID.ToString();
}
catch (Exception ex)
{
lblMessageForList.Text = "No Installment has fixed before for that Student ID and Course";
}
}
protected void btnDeleteJournal_Click(object sender, EventArgs e)
{
foreach (ListItem item in ddlTablesNeedToDelete.Items)
{
switch (item.Text.Split(':')[0])
{
case "ACC_Check":
ACC_CheckManager.DeleteACC_Check(int.Parse(item.Text.Split(':')[1]));
break;
case "ACC_CUCCheck":
ACC_CUCCheckManager.DeleteACC_CUCCheck(int.Parse(item.Text.Split(':')[1]));
break;
case "ACC_EmployPayRoleSalary":
ACC_EmployPayRoleSalary payRoleSalary= ACC_EmployPayRoleSalaryManager.GetEmployPayRoleSalaryByID(int.Parse(item.Text.Split(':')[1]));
payRoleSalary.PaidSalaryAmount -= decimal.Parse(lblTotalAmount.Text);
payRoleSalary.UnpaidSalaryAmount += decimal.Parse(lblTotalAmount.Text);
ACC_EmployPayRoleSalaryManager.UpdateEmployPayRoleSalary(payRoleSalary);
break;
case "STD_FeesMaster":
STD_FeesMaster feesMaster= STD_FeesMasterManager.GetSTD_FeesMasterByFeesMasterID(int.Parse(item.Text.Split(':')[1]));
feesMaster.ExtraField1 = (decimal.Parse(feesMaster.ExtraField1) - decimal.Parse(lblTotalAmount.Text)).ToString("0.00");
feesMaster.ExtraField2 = (decimal.Parse(feesMaster.ExtraField2) + decimal.Parse(lblTotalAmount.Text)).ToString("0.00");
feesMaster.UpdateDate = DateTime.Now;
feesMaster.UpdatedBy = Profile.card_id;
STD_FeesMasterManager.UpdateSTD_FeesMasterForJournalDelete(feesMaster);
List<STD_Fees> fees = new List<STD_Fees>();
DataSet dsFeesByStudentIDnCourseID = STD_FeesManager.GetSTD_FeesListByFeesMasterID(item.Text.Split(':')[1]);
if (dsFeesByStudentIDnCourseID != null)
{
fees = new List<STD_Fees>();
foreach (DataRow drFeesByStudentIDnCourseID in dsFeesByStudentIDnCourseID.Tables[0].Rows)
{
STD_Fees sTD_Fees = new STD_Fees();
sTD_Fees.FeesID = int.Parse(drFeesByStudentIDnCourseID["FeesID"].ToString());
sTD_Fees.FeesName = drFeesByStudentIDnCourseID["FeesName"].ToString();
sTD_Fees.Amount = decimal.Parse(drFeesByStudentIDnCourseID["Amount"].ToString());
sTD_Fees.FeesTypeID = int.Parse(drFeesByStudentIDnCourseID["FeesTypeID"].ToString());
sTD_Fees.SubmissionDate = DateTime.Parse(drFeesByStudentIDnCourseID["SubmissionDate"].ToString());
sTD_Fees.SubmitedDate = drFeesByStudentIDnCourseID["SubmitedDate"].ToString();
sTD_Fees.StudentID = drFeesByStudentIDnCourseID["StudentID"].ToString();
sTD_Fees.CourseID = int.Parse(drFeesByStudentIDnCourseID["CourseID"].ToString());
sTD_Fees.AddedBy = drFeesByStudentIDnCourseID["AddedBy"].ToString();
sTD_Fees.AddedDate = DateTime.Parse(drFeesByStudentIDnCourseID["AddedDate"].ToString());
sTD_Fees.UpdatedBy = Profile.card_id;
sTD_Fees.UpdateDate = DateTime.Now;
sTD_Fees.RowStatusID = int.Parse(drFeesByStudentIDnCourseID["RowStatusID"].ToString()); ;
sTD_Fees.Remarks = drFeesByStudentIDnCourseID["Remarks"].ToString();
sTD_Fees.IsPaid = bool.Parse(drFeesByStudentIDnCourseID["IsPaid"].ToString());
sTD_Fees.UnpaidAmount = sTD_Fees.Amount - decimal.Parse(sTD_Fees.Remarks);
fees.Add(sTD_Fees);
}
}
decimal journalAMount= decimal.Parse(lblTotalAmount.Text);
for (int i = fees.Count -1; i >= 0 ; i--)
{
if (fees[i].IsPaid)
{
if (decimal.Parse(fees[i].Remarks) > 0)
{
if (decimal.Parse(fees[i].Remarks) > journalAMount)
{
fees[i].Remarks = (decimal.Parse(fees[i].Remarks) - journalAMount).ToString("0.00");
STD_FeesManager.UpdateSTD_Fees(fees[i]);
journalAMount = 0;
break;
}
else if (decimal.Parse(fees[i].Remarks) == journalAMount)
{
fees[i].Remarks = "0.00";
fees[i].IsPaid = false;
STD_FeesManager.UpdateSTD_Fees(fees[i]);
journalAMount = 0;
break;
}
else
{
journalAMount -= decimal.Parse(fees[i].Remarks);
fees[i].Remarks = "0.00";
fees[i].IsPaid = false;
STD_FeesManager.UpdateSTD_Fees(fees[i]);
}
}
}
}
break;
default:
break;
}
}
//Journal Need to delete
ACC_JournalMasterManager.DeleteACC_JournalMaster(int.Parse(Request.QueryString["JournalMasterID"]));
btnDeleteJournal.Visible = false;
txtDate.ReadOnly = true;
btnUpdateJournal.Visible = false;
//Need to send Email to Super Admin
//JournalTableForDelete nee to delete
}
protected void btnJournalEntry_Click(object sender, EventArgs e)
{
int fulltimesalryJournalID = 0;
int FeesMasterJournalID = 0;
List<ACC_Journal> doubleEntry = new List<ACC_Journal>();
doubleEntry = (List<ACC_Journal>)Session["doubleEntry"];
List<ACC_Check> checks = new List<ACC_Check>();
if (Session["checks"] != null) checks = (List<ACC_Check>)Session["checks"];
List<ACC_CUCCheck> cucChecks = new List<ACC_CUCCheck>();
if (Session["cucCheck"] != null) cucChecks = (List<ACC_CUCCheck>)Session["cucCheck"];
ACC_JournalMaster aCC_JournalMaster = new ACC_JournalMaster();
aCC_JournalMaster.JournalMasterName = "";
aCC_JournalMaster.AddedBy = Profile.card_id;
aCC_JournalMaster.AddedDate = DateTime.Now;
aCC_JournalMaster.UpdatedBy = Profile.card_id;
aCC_JournalMaster.UpdateDate = DateTime.Now;
aCC_JournalMaster.RowStatusID = 1;
aCC_JournalMaster.JournalMasterID = ACC_JournalMasterManager.InsertACC_JournalMaster(aCC_JournalMaster);
if (doubleEntry != null)
{
foreach (ACC_Journal eachJournal in doubleEntry)
{
int temp = eachJournal.HeadID;
string checkno = eachJournal.JournalVoucherNo;
eachJournal.JournalVoucherNo = Request.QueryString["IsAdmissionFees"] != null ? Request.QueryString["IsAdmissionFees"] : "";
eachJournal.JournalMasterID = aCC_JournalMaster.JournalMasterID;
eachJournal.JournalID = ACC_JournalManager.InsertACC_Journal(eachJournal);
if (eachJournal.AccountID == 17)//fulltime salary
{
fulltimesalryJournalID = eachJournal.JournalID;
}
if (eachJournal.SubBasicAccountID == 20)//student Fees
{
FeesMasterJournalID = eachJournal.JournalID;
}
if (checkno != "")
{
foreach (ACC_Check check in checks)
{
if (checkno == check.CheckNo)
{
//teamporary we have used the login that
//we will keep in the JournalVoucherNo the checkno
//then
//in the insert script we will update the JournalVoucherNo with the CheckID
check.ExtraField3 = eachJournal.JournalID.ToString();
ACC_CheckManager.InsertACC_Check(check);
}
}
}
else
{
foreach (ACC_CUCCheck cucCheck in cucChecks)
{
if (temp == cucCheck.PaytoHeadID)
{
//cucCheck.PaytoHeadID = eachJournal.JournalID;
cucCheck.JournalID = eachJournal.JournalID;
ACC_CUCCheckManager.InsertACC_CUCCheck(cucCheck);
}
}
}
}
}
if (Session["cucCheck"] != null) Session.Remove("cucCheck");
if (Session["doubleEntry"] != null) Session.Remove("doubleEntry");
if (Session["checks"] != null) Session.Remove("checks");
try
{
if (Request.QueryString["CheckID"] != null)
{
ACC_Check aCC_Check = new ACC_Check();
aCC_Check = ACC_CheckManager.GetACC_CheckByCheckID(int.Parse(Request.QueryString["CheckID"]));
aCC_Check.UpdatedBy = Profile.card_id;
aCC_Check.UpdateDate = DateTime.Now;
aCC_Check.RowStatusID = 11;
bool resutl = ACC_CheckManager.UpdateACC_Check(aCC_Check);
}
}
catch (Exception ex)
{
}
try
{
if (Request.QueryString["EmployPayRoleSalaryID"] != null)
{
ACC_EmployPayRoleSalary employPayroleSalary = new ACC_EmployPayRoleSalary();
if (Session["employPayRoleSalary"] != null)
{
employPayroleSalary = (ACC_EmployPayRoleSalary)Session["employPayRoleSalary"];
employPayroleSalary.ExtraField6 += ", " + aCC_JournalMaster.JournalMasterID.ToString();
employPayroleSalary.ExtraField7 = fulltimesalryJournalID.ToString();
}
Session.Remove("employPayRoleSalary");
bool result = ACC_EmployPayRoleSalaryManager.UpdateEmployPayRoleSalary(employPayroleSalary);
}
}
catch (Exception ex)
{ }
try
{
if (Request.QueryString["FeesID"] != null)
{
STD_Fees sTD_FeesUpdate = new STD_Fees();
sTD_FeesUpdate = STD_FeesManager.GetSTD_FeesByFeesID(int.Parse(Request.QueryString["FeesID"]));
sTD_FeesUpdate.IsPaid = true;
sTD_FeesUpdate.SubmitedDate = DateTime.Today.ToString();
sTD_FeesUpdate.UpdatedBy = Profile.card_id;
sTD_FeesUpdate.UpdateDate = DateTime.Now;
sTD_FeesUpdate.RowStatusID = int.Parse("1");
sTD_FeesUpdate.Remarks = Request.QueryString["Remarks"];
bool resutl = STD_FeesManager.UpdateSTD_Fees(sTD_FeesUpdate);
STD_FeesMaster feesMaster = new STD_FeesMaster();
feesMaster = STD_FeesMasterManager.GetSTD_FeesMasterByFeesMasterID(int.Parse(sTD_FeesUpdate.FeesName));
feesMaster.ExtraField1 = (decimal.Parse(feesMaster.ExtraField1) + sTD_FeesUpdate.Amount).ToString();//total paid Amount
feesMaster.ExtraField1 = (decimal.Parse(feesMaster.ExtraField2) - sTD_FeesUpdate.Amount).ToString();//total unpaid Amount
resutl = STD_FeesMasterManager.UpdateSTD_FeesMaster(feesMaster);
}
}
catch (Exception ex)
{ }
STD_FeesMaster feesMasterTemp = new STD_FeesMaster();
try
{
if (Request.QueryString["newFeesID"] != null)
{
if (Session["feesListUpdate"] != null)
{
List<STD_Fees> feesListUpdate = new List<STD_Fees>();
feesListUpdate = (List<STD_Fees>)Session["feesListUpdate"];
foreach (STD_Fees item in feesListUpdate)
{
item.IsPaid = true;
STD_FeesManager.UpdateSTD_Fees(item);
}
Session.Remove("feesListUpdate");
}
if (Session["feesMaster"] != null)
{
feesMasterTemp = (STD_FeesMaster)Session["feesMaster"];
feesMasterTemp.ExtraField4 = FeesMasterJournalID.ToString();
STD_FeesMasterManager.UpdateSTD_FeesMaster(feesMasterTemp);
Session.Remove("feesMaster");
}
if (Request.QueryString["newFeesID"] != "0")
{
STD_Fees sTD_FeesUpdate = new STD_Fees();
sTD_FeesUpdate = STD_FeesManager.GetSTD_FeesByFeesID(int.Parse(Request.QueryString["newFeesID"]));
sTD_FeesUpdate.RowStatusID = int.Parse("1");
bool resutl = STD_FeesManager.UpdateSTD_Fees(sTD_FeesUpdate);
}
}
}
catch (Exception ex)
{ }
if (Request.QueryString["Refund"] != null)
{
if (STD_FeesMasterManager.RefundSTD_FeesMaster(hfStudentID.Value))
{
lblMessage.Text += "Student Refund Successfull<br/>";
}
}
lblMessage.Text += "Journal Entry Successful. <a href='VoucherPage.aspx?JournalMasterID=" + aCC_JournalMaster.JournalMasterID.ToString() + "&EmployeeID=" + ddlAccountingUserMoney.SelectedValue + "&Amount=" + lblDebit.Text + "' target='_blank'>Click here to Print</a>";
if (Request.QueryString["AccountID"] != null)
{
//if (int.Parse(Request.QueryString["AccountID"]) >= 29 && int.Parse(Request.QueryString["AccountID"]) <= 37)
if (int.Parse(Request.QueryString["SubBasicAccountID"]) ==20)
{
lblMessage.Text += "</br><a target='_blank' href='FeesInstallment.aspx?StudentCode=" + Request.QueryString["StudentCode"] + "'>Back to Student Fees Search page</a></br><a href='MoneyReceipt.aspx?StudentID=" + hfStudentID.Value + "&Amount=" + lblDebit.Text + "&Remark=" + (chkAddInMoneyReceipt.Checked ? txtRemarks.Text : "") + "&FeesMasterID=" + feesMasterTemp.FeesMasterID.ToString() + "&JournalMasterID=" + aCC_JournalMaster.JournalMasterID.ToString() + "&IsAdmissionFees=" + Request.QueryString["IsAdmissionFees"] + "' target='_blank'>Click here to Print the receipt</a>";
//lblMessage.Text += "</br><a target='_blank' href='FeesInstallment.aspx?StudentCode=" + Request.QueryString["StudentCode"] + "'>Back to Student Fees Search page</a></br><a href='../Accounting/MoneyReceipt.aspx?StudentID=" + hfStudentID.Value + "&Amount=" + lblDebit.Text + "&Remark=" + Request.QueryString["Remark"] + "&FeesMasterID=" + feesMasterTemp.FeesMasterID.ToString() + "&JournalMasterID=" + aCC_JournalMaster.JournalMasterID.ToString() + "' target='_blank'>Click here to Print the receipt</a>";
}
else
if (int.Parse(Request.QueryString["AccountID"]) >= 17 && int.Parse(Request.QueryString["AccountID"]) <= 19)
{
lblMessage.Text += "</br><a target='_blank' href='AccountEmployPayRoleSalary.aspx?EmployeeID=" + Request.QueryString["EmployeeID"] + "'>Back to Sallary posting page</a></br><a href='VoucherPage.aspx?JournalMasterID=" + aCC_JournalMaster.JournalMasterID.ToString() + "&EmployeeID=" + ddlAccountingUser.SelectedValue + "&Amount=" + lblDebit.Text + "&Payto=" + ddlAccountingUser.SelectedItem.Text + "&Purpose=" + Request.QueryString["Purpose"] + "' target='_blank'>Click here to Print the receipt</a>";
}
}
lblMessage.ForeColor = System.Drawing.Color.Green;
btnJournalEntry.Visible = false;
}
//protected void gvFeesShow_OnRowDataBound(object sender, GridViewRowEventArgs e)
//{
// decimal PaidTotal = 0, UnpaidTotal = 0;
// if (e.Row.RowType == DataControlRowType.DataRow)
// {
// TextBox txtAmount = (TextBox)e.Row.FindControl("txtListAmount");
// CheckBox chkIspaid = (CheckBox)e.Row.FindControl("chkIspaid");
// if (chkIspaid.Checked)
// {
// PaidTotal = Convert.ToDecimal(Session["PaidTotal"]) + decimal.Parse(txtAmount.Text);
// Session["PaidTotal"] = PaidTotal;
// }
// else
// {
// UnpaidTotal = Convert.ToDecimal(Session["UnpaidTotal"]) + decimal.Parse(txtAmount.Text);
// Session["UnpaidTotal"] = UnpaidTotal;
// }
// }
// if (e.Row.RowType == DataControlRowType.Footer)
// {
// Label lblPaidAmount = (Label)e.Row.FindControl("lblPaidAmount");
// Label lblUnpaidAmount = (Label)e.Row.FindControl("lblUnpaidAmount");
// lblPaidAmount.Text = Session["PaidTotal"] != null ? Session["PaidTotal"].ToString() : "";
// lblUnpaidAmount.Text = Session["UnpaidTotal"] != null ? Session["UnpaidTotal"].ToString() : "";
// Session["PaidTotal"] = null;
// Session["UnpaidTotal"] = null;
// }
//}
protected void lbDeleteFees_Click(object sender, EventArgs e)
{
try
{
int i = 0;
List<STD_Fees> fees = new List<STD_Fees>();
foreach (GridViewRow row in gvFeesAdd.Rows)
{
TextBox txtAmount = (TextBox)row.FindControl("txtAmount");
TextBox txtunpaidAmountEdit = (TextBox)row.FindControl("txtUnpaid");
TextBox txtPaidAmountEdit = (TextBox)row.FindControl("txtPaidAmount");
TextBox txtSubmissionDate = (TextBox)row.FindControl("txtSubmissionDate");
HiddenField hfIsPaid = (HiddenField)row.FindControl("hfIsPaid");
HiddenField hfFeesID = (HiddenField)row.FindControl("hfFeesID");
STD_Fees fee = new STD_Fees();
fee.FeesID = int.Parse(hfFeesID.Value);
fee.SubmissionDate = DateTime.Parse(txtSubmissionDate.Text);
fee.Remarks = txtPaidAmountEdit.Text;
fee.UnpaidAmount = decimal.Parse(txtunpaidAmountEdit.Text);
fee.Amount = decimal.Parse(fee.Remarks) + fee.UnpaidAmount;
if (fee.UnpaidAmount == 0)
{
fee.IsPaid = false;
}
else
{
fee.IsPaid = true;
}
fee.IsEnabled = false;
fees.Add(fee);
i++;
}
ImageButton linkButton = new ImageButton();
linkButton = (ImageButton)sender;
foreach (STD_Fees item in fees)
{
if (item.FeesID == Convert.ToInt32(linkButton.CommandArgument))
{
fees.Remove(item);
break;
}
}
//fees.RemoveAt();
//for (int i = 0; i < fees.Count; i++)
//{
// fees[i].FeesID = i;
//}
Session["fees"] = fees;
gvFeesAdd.DataSource = fees;
gvFeesAdd.DataBind();
txtAmount_OnTextChanged(this, new EventArgs());
}
catch (Exception ex)
{ }
}
private STD_FeesMaster insertFeesMaster(int accountID,string studentID)
{
//add in the FeesMaster
STD_FeesMaster sTD_FeesMaster = new STD_FeesMaster();
// sTD_FeesMaster.FeesMasterID= int.Parse(ddlFeesMasterID.SelectedValue);
DataSet ds = STD_FeesMasterManager.GetSTD_FeesMasterByStudentIDnCourseIDnFeesTypeID(studentID, int.Parse(ddlCourseID.SelectedValue), accountID);
if (ds.Tables[0].Rows.Count != 0)
{
sTD_FeesMaster.FeesMasterID = int.Parse(ds.Tables[0].Rows[0]["FeesMasterID"].ToString());
sTD_FeesMaster.FeesMasterName = (ds.Tables[0].Rows[0]["FeesMasterName"].ToString());
sTD_FeesMaster.TotalPayment = decimal.Parse(ds.Tables[0].Rows[0]["TotalPayment"].ToString());
sTD_FeesMaster.Discount = decimal.Parse(ds.Tables[0].Rows[0]["Discount"].ToString());
sTD_FeesMaster.TotalPaymentNeedtoPay = decimal.Parse(ds.Tables[0].Rows[0]["TotalPaymentNeedtoPay"].ToString());
sTD_FeesMaster.FeesTypeID = int.Parse(ds.Tables[0].Rows[0]["FeesTypeID"].ToString());
sTD_FeesMaster.SubmissionDate = DateTime.Parse(ds.Tables[0].Rows[0]["SubmissionDate"].ToString());
sTD_FeesMaster.SubmitedDate = (ds.Tables[0].Rows[0]["SubmitedDate"].ToString());
sTD_FeesMaster.StudentID = (ds.Tables[0].Rows[0]["StudentID"].ToString());
sTD_FeesMaster.CourseID = int.Parse(ds.Tables[0].Rows[0]["CourseID"].ToString());
sTD_FeesMaster.Remarks = (ds.Tables[0].Rows[0]["Remarks"].ToString());
sTD_FeesMaster.IsPaid = bool.Parse(ds.Tables[0].Rows[0]["IsPaid"].ToString());
sTD_FeesMaster.PaymentStatusID = int.Parse(ds.Tables[0].Rows[0]["PaymentStatusID"].ToString());
sTD_FeesMaster.ExtraField1 = (ds.Tables[0].Rows[0]["ExtraField1"].ToString());
sTD_FeesMaster.ExtraField2 = (ds.Tables[0].Rows[0]["ExtraField2"].ToString());
sTD_FeesMaster.ExtraField3 = (ds.Tables[0].Rows[0]["ExtraField3"].ToString());
sTD_FeesMaster.ExtraField4 = (ds.Tables[0].Rows[0]["ExtraField4"].ToString());
sTD_FeesMaster.ExtraField5 = (ds.Tables[0].Rows[0]["ExtraField5"].ToString());
sTD_FeesMaster.AddedBy = (ds.Tables[0].Rows[0]["AddedBy"].ToString());
sTD_FeesMaster.AddedDate = DateTime.Parse(ds.Tables[0].Rows[0]["AddedDate"].ToString());
sTD_FeesMaster.UpdatedBy = (ds.Tables[0].Rows[0]["UpdatedBy"].ToString());
sTD_FeesMaster.UpdateDate = DateTime.Parse(ds.Tables[0].Rows[0]["UpdateDate"].ToString());
sTD_FeesMaster.RowStatusID = int.Parse(ds.Tables[0].Rows[0]["RowStatusID"].ToString());
//updated data
//sTD_FeesMaster.FeesMasterName = "";
//sTD_FeesMaster.TotalPayment += decimal.Parse(txtSemesterFee.Text);
sTD_FeesMaster.ExtraField5 = txtSemesterFee.Text;
//sTD_FeesMaster.Discount +=0;
//sTD_FeesMaster.TotalPaymentNeedtoPay += decimal.Parse(txtSemesterFee.Text);
//sTD_FeesMaster.IsPaid = false;
//sTD_FeesMaster.PaymentStatusID = int.Parse("1");
//sTD_FeesMaster.ExtraField2 = (decimal.Parse(sTD_FeesMaster.ExtraField2) + decimal.Parse(txtSemesterFee.Text)).ToString();
sTD_FeesMaster.UpdatedBy = Profile.card_id;
sTD_FeesMaster.UpdateDate = DateTime.Now;
sTD_FeesMaster.RowStatusID = int.Parse("1");
STD_FeesMasterManager.UpdateSTD_FeesMaster(sTD_FeesMaster);
}
else
{
sTD_FeesMaster.FeesMasterName = "";
sTD_FeesMaster.TotalPayment = decimal.Parse(txtSemesterFee.Text);
sTD_FeesMaster.Discount = 0;
sTD_FeesMaster.TotalPaymentNeedtoPay = decimal.Parse(txtSemesterFee.Text);
sTD_FeesMaster.FeesTypeID = accountID;
sTD_FeesMaster.SubmissionDate = DateTime.Today;
sTD_FeesMaster.SubmitedDate = "";
sTD_FeesMaster.StudentID = studentID;
sTD_FeesMaster.CourseID = int.Parse(ddlCourseID.SelectedValue);
sTD_FeesMaster.Remarks = "";
sTD_FeesMaster.IsPaid = false;
sTD_FeesMaster.PaymentStatusID = int.Parse("1");
sTD_FeesMaster.ExtraField1 = "0";
sTD_FeesMaster.ExtraField2 =txtSemesterFee.Text;
sTD_FeesMaster.ExtraField3 = "";
sTD_FeesMaster.ExtraField4 = "";
sTD_FeesMaster.ExtraField5 = txtSemesterFee.Text;
sTD_FeesMaster.AddedBy = Profile.card_id;
sTD_FeesMaster.AddedDate = DateTime.Now;
sTD_FeesMaster.UpdatedBy = Profile.card_id;
sTD_FeesMaster.UpdateDate = DateTime.Now;
sTD_FeesMaster.RowStatusID = int.Parse("1");
sTD_FeesMaster.FeesMasterID = STD_FeesMasterManager.InsertSTD_FeesMaster(sTD_FeesMaster);
STD_Fees sTD_Fees = new STD_Fees();
sTD_Fees.FeesName = sTD_FeesMaster.FeesMasterID.ToString();//it will be fees masterID
sTD_Fees.Amount = decimal.Parse(txtSemesterFee.Text);
sTD_Fees.FeesTypeID = 1; //installment
sTD_Fees.SubmissionDate = DateTime.Today;
sTD_Fees.SubmitedDate = "";
sTD_Fees.StudentID = studentID;
sTD_Fees.CourseID = int.Parse(ddlCourseID.SelectedValue);
sTD_Fees.AddedBy = Profile.card_id;
sTD_Fees.AddedDate = DateTime.Now;
sTD_Fees.UpdatedBy = Profile.card_id;
sTD_Fees.UpdateDate = DateTime.Now;
sTD_Fees.RowStatusID = int.Parse("1");
sTD_Fees.Remarks = "0";
sTD_Fees.IsPaid = false;
sTD_Fees.FeesID = STD_FeesManager.InsertSTD_Fees(sTD_Fees);
}
return sTD_FeesMaster;
}
protected void btnAdd_Click(object sender, EventArgs e)
{
if (ddlCourseIDReceived.SelectedIndex == 0)
{
ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "Message", "alert('Plase Select the Program from top')", true);
return;
}
if (hfStudentID.Value != "" && ddlAccountID.SelectedValue!="0")
{
STD_FeesMaster sTD_FeesMaster = new STD_FeesMaster();
sTD_FeesMaster.FeesMasterID = int.Parse(Request.QueryString["FeesMasterID"]);
sTD_FeesMaster.CourseID = int.Parse(ddlCourseIDReceived.SelectedValue);
sTD_FeesMaster.TotalPayment = decimal.Parse(txtTotalAmount.Text);
sTD_FeesMaster.TotalPaymentNeedtoPay = decimal.Parse(txtTotalAmountNeedToPay.Text);
sTD_FeesMaster.ExtraField1 = txtPaidAmount.Text;
sTD_FeesMaster.ExtraField2 = txtUnpaidAmount.Text;
sTD_FeesMaster.UpdateDate = DateTime.Now;
sTD_FeesMaster.UpdatedBy = Profile.card_id;
STD_FeesMasterManager.UpdateSTD_FeesMasterFeesAdjustment(sTD_FeesMaster);
if (ddlAccountID.SelectedValue == "31" || ddlAccountID.SelectedValue == "57")//installment fees and Paper wise fee
{
hfIsAdmissionFees.Value = "1";
}
STD_FeesManager.DeleteSTD_FeesByFeesMasterID(int.Parse(Request.QueryString["FeesMasterID"]));
//if (ddlAccountID.SelectedValue == "31")//installment fees
//{
foreach (GridViewRow gr in gvFeesAdd.Rows)
{
TextBox txtSubmissionDate = (TextBox)gr.FindControl("txtSubmissionDate");
TextBox txtAmount = (TextBox)gr.FindControl("txtAmount");
//TextBox txtAmount = (TextBox)gr.FindControl("txtAmount");
TextBox txtunpaidAmountEdit = (TextBox)gr.FindControl("txtUnpaid");
TextBox txtPaidAmountEdit = (TextBox)gr.FindControl("txtPaidAmount");
//TextBox txtSubmissionDate = (TextBox)gr.FindControl("txtSubmissionDate");
HiddenField hfIsPaid = (HiddenField)gr.FindControl("hfIsPaid");
HiddenField hfFeesID = (HiddenField)gr.FindControl("hfFeesID");
//HiddenField hfFeesID = (HiddenField)gr.FindControl("hfFeesID");
STD_Fees sTD_Fees = new STD_Fees();
sTD_Fees.FeesName = Request.QueryString["FeesMasterID"];//it will be fees masterID
sTD_Fees.Amount = decimal.Parse(txtAmount.Text);
sTD_Fees.FeesTypeID = int.Parse(Request.QueryString["FeesTypeID"]); //installment
sTD_Fees.SubmissionDate = DateTime.Parse(txtSubmissionDate.Text);
sTD_Fees.SubmitedDate = "";
sTD_Fees.StudentID = hfStudentID.Value;
sTD_Fees.CourseID = int.Parse(ddlCourseIDReceived.SelectedValue);
sTD_Fees.AddedBy = Profile.card_id;
sTD_Fees.AddedDate = DateTime.Now;
sTD_Fees.UpdatedBy = Profile.card_id;
sTD_Fees.UpdateDate = DateTime.Now;
sTD_Fees.RowStatusID = int.Parse("1");
sTD_Fees.Remarks = txtPaidAmountEdit.Text;
sTD_Fees.IsPaid = !bool.Parse(hfIsPaid.Value);
int resutl = STD_FeesManager.InsertSTD_Fees(sTD_Fees);
}
}
Response.Redirect("FeesInstallment.aspx?StudentID=" + Request.QueryString["StudentID"]);
}
protected void gvSTD_FeesMaster_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
GridView gvFeesShow = (GridView)e.Row.FindControl("gvFeesShow");
GridView gvFeesShowForInstallment = (GridView)e.Row.FindControl("gvFeesShowForInstallment");
/*
<asp:HiddenField ID="hfCourseID" runat="server" Value='<%#Eval("CourseID") %>'/>
<asp:HiddenField ID="hfFeesMasterID" runat="server" Value='<%#Eval("FeesMasterName") %>'/>
<asp:HiddenField ID="hfStudentID" runat="server" Value='<%#Eval("StudentID") %>'/>
*/
HiddenField hfCourseID = (HiddenField)e.Row.FindControl("hfCourseID");
HiddenField hfFeesTypeID = (HiddenField)e.Row.FindControl("hfFeesTypeID");
HiddenField hfFeesMasterID = (HiddenField)e.Row.FindControl("hfFeesMasterID");
HiddenField hfStudentID = (HiddenField)e.Row.FindControl("hfStudentID");
Label lblMessage = (Label)e.Row.FindControl("lblMessage");
Label lblDueAmount = (Label)e.Row.FindControl("lblDueAmount");
Label lblUnpaidAmount = (Label)e.Row.FindControl("lblUnpaidAmount");
string studentID = hfStudentID.Value;
string courseID = hfCourseID.Value;
//lblMessageForList.Text = "No Installment has fixed before for that Student ID and Course";
DataSet dsFeesByStudentIDnCourseID = STD_FeesManager.GetSTD_FeesListByFeesMasterID(hfFeesMasterID.Value);
if (dsFeesByStudentIDnCourseID != null)
{
//if (dsFeesByStudentIDnCourseID.Tables[0].Rows.Count == 0)
//{
// lblMessageForList.Visible = true;
//}
List<STD_Fees> fees = new List<STD_Fees>();
fees = new List<STD_Fees>();
decimal due = 0;
decimal unpaid = 0;
foreach (DataRow drFeesByStudentIDnCourseID in dsFeesByStudentIDnCourseID.Tables[0].Rows)
{
STD_Fees sTD_Fees = new STD_Fees();
sTD_Fees.FeesID = int.Parse(drFeesByStudentIDnCourseID["FeesID"].ToString());
sTD_Fees.FeesName = drFeesByStudentIDnCourseID["FeesName"].ToString();
sTD_Fees.Amount = decimal.Parse(drFeesByStudentIDnCourseID["Amount"].ToString());
sTD_Fees.FeesTypeID = int.Parse(drFeesByStudentIDnCourseID["FeesTypeID"].ToString());
sTD_Fees.SubmissionDate = DateTime.Parse(drFeesByStudentIDnCourseID["SubmissionDate"].ToString());
sTD_Fees.SubmitedDate = drFeesByStudentIDnCourseID["SubmitedDate"].ToString();
sTD_Fees.StudentID = studentID;
sTD_Fees.CourseID = int.Parse(courseID);
sTD_Fees.AddedBy = drFeesByStudentIDnCourseID["AddedBy"].ToString();
sTD_Fees.AddedDate = DateTime.Parse(drFeesByStudentIDnCourseID["AddedDate"].ToString());
sTD_Fees.UpdatedBy = Profile.card_id;
sTD_Fees.UpdateDate = DateTime.Now;
sTD_Fees.RowStatusID = int.Parse(drFeesByStudentIDnCourseID["RowStatusID"].ToString()); ;
sTD_Fees.Remarks = drFeesByStudentIDnCourseID["Remarks"].ToString();
sTD_Fees.IsPaid = bool.Parse(drFeesByStudentIDnCourseID["IsPaid"].ToString());
sTD_Fees.UnpaidAmount = sTD_Fees.Amount - decimal.Parse(sTD_Fees.Remarks);
if (!sTD_Fees.IsPaid)
{
if (sTD_Fees.SubmissionDate > DateTime.Today)
{
sTD_Fees.PaymentStatus = "<b style='color:Blue;'>UnPaid</b>";
unpaid += sTD_Fees.UnpaidAmount;
}
else
{
sTD_Fees.PaymentStatus = "<b style='color:Red;'>Due</b>";
due += sTD_Fees.UnpaidAmount;
}
}
else
{
if (sTD_Fees.Amount == decimal.Parse(sTD_Fees.Remarks))
{
sTD_Fees.PaymentStatus = "<b style='color:Green;'>Paid</b>";
}
else
{
if (sTD_Fees.SubmissionDate > DateTime.Today)
{
sTD_Fees.PaymentStatus = "<b style='color:Blue;'>Partially Unpaid</b>";
unpaid += sTD_Fees.UnpaidAmount;
}
else
{
sTD_Fees.PaymentStatus = "<b style='color:Red;'>Partially Due</b>";
due += sTD_Fees.UnpaidAmount;
}
}
}
//sTD_Fees.PaymentStatus = sTD_Fees.IsPaid ? "<b style='color:Green;'>Paid</b>" : "<b style='color:Red;'>Unpaid</b>";
sTD_Fees.IsEnabled = !sTD_Fees.IsPaid;
fees.Add(sTD_Fees);
}
lblUnpaidAmount.Text = unpaid.ToString().Contains('.')? unpaid.ToString().Substring(0, unpaid.ToString().IndexOf('.') + 3):unpaid.ToString();
lblDueAmount.Text = due.ToString().Contains('.')? due.ToString().Substring(0, due.ToString().IndexOf('.') + 3):due.ToString();
Session["fees"] = fees;
if (hfFeesTypeID.Value != "31")
{
gvFeesShow.DataSource = fees;
gvFeesShow.DataBind();
gvFeesShow.Visible = true;
gvFeesShowForInstallment.Visible = false;
lblMessage.Visible = false;
}
else
{
gvFeesShowForInstallment.DataSource = fees;
gvFeesShowForInstallment.DataBind();
gvFeesShow.Visible = false;
gvFeesShowForInstallment.Visible = true;
lblMessage.Visible = true;
}
}
//else
//{
// lblMessageForList.Text = "No Installment has fixed before for that Student ID and Course";
//}
}
}
protected void txtAmount_OnTextChanged(object sender, EventArgs e)
{
int i = 0;
List<STD_Fees> fees = new List<STD_Fees>();
foreach (GridViewRow row in gvFeesAdd.Rows)
{
TextBox txtAmount = (TextBox)row.FindControl("txtAmount");
TextBox txtunpaidAmountEdit = (TextBox)row.FindControl("txtUnpaid");
TextBox txtPaidAmountEdit = (TextBox)row.FindControl("txtPaidAmount");
TextBox txtSubmissionDate = (TextBox)row.FindControl("txtSubmissionDate");
HiddenField hfIsPaid = (HiddenField)row.FindControl("hfIsPaid");
HiddenField hfFeesID = (HiddenField)row.FindControl("hfFeesID");
STD_Fees fee = new STD_Fees();
fee.FeesID = int.Parse(hfFeesID.Value);
fee.SubmissionDate = DateTime.Parse(txtSubmissionDate.Text);
fee.Remarks = txtPaidAmountEdit.Text;
fee.UnpaidAmount = decimal.Parse(txtunpaidAmountEdit.Text);
fee.Amount = decimal.Parse(fee.Remarks) + fee.UnpaidAmount ;
if (fee.UnpaidAmount == 0)
{
fee.IsPaid = false;
}
else
{
fee.IsPaid = true;
}
fee.IsEnabled = false;
fees.Add(fee);
i++;
}
Session["fees"] = fees;
gvFeesAdd.DataSource = fees;
gvFeesAdd.DataBind();
txtUnpaidAmount.Text = (decimal.Parse(txtTotalAmountNeedToPay.Text) - decimal.Parse(txtPaidAmount.Text) - decimal.Parse(txtExtraPaidAmount.Text)).ToString();
}
protected void lbPaid_Click(object sender, EventArgs e)
{
if (hfStudentID.Value!="")
{
Button linkButton = new Button();
linkButton = (Button)sender;
int id;
id = Convert.ToInt32(linkButton.CommandArgument);
//pay it in the fees table
STD_Fees sTD_FeesUpdate = new STD_Fees();
sTD_FeesUpdate = STD_FeesManager.GetSTD_FeesByFeesID(id);
sTD_FeesUpdate.IsPaid = true;
sTD_FeesUpdate.SubmitedDate = DateTime.Today.ToString();
sTD_FeesUpdate.UpdatedBy = Profile.card_id;
sTD_FeesUpdate.UpdateDate = DateTime.Now;
sTD_FeesUpdate.RowStatusID = int.Parse("1");
sTD_FeesUpdate.Remarks = "Fully paid";
//bool resutl = STD_FeesManager.UpdateSTD_Fees(sTD_FeesUpdate);
//for accounting we need to process
showSTD_FeesDataByStudentIDnCourseID();
Response.Redirect("~/Accounting/JournalDoubleEntryCommon.aspx?FeesID=" + sTD_FeesUpdate.FeesID.ToString() + "&Remarks=" + sTD_FeesUpdate.Remarks + "&DrOrCr=Cr&SubBasicAccountID=20&AccountID=31&UserTypeID=1&StudentCode=" + txtStudentCode.Text + "&UserTypeIDMoney=2&Amount=" + sTD_FeesUpdate.Amount);
}
else
{
lblTest.Text = "StudentCode is not exist.";
}
}
//public static void sTD_FeesPaggination(System.Web.UI.WebControls.Repeater rptPager, int recordCount, int currentPage, int PageSize)
//{
// double dblPageCount = (double)((decimal)recordCount / decimal.Parse(PageSize.ToString()));
// int pageCount = (int)Math.Ceiling(dblPageCount);
// List<ListItem> pages = new List<ListItem>();
// if (pageCount > 0)
// {
// pages.Add(new ListItem("First", "1", currentPage > 1));
// for (int i = 1; i <= pageCount; i++)
// {
// pages.Add(new ListItem(i.ToString(), i.ToString(), i != currentPage));
// }
// pages.Add(new ListItem("Last", pageCount.ToString(), currentPage < pageCount));
// }
// rptPager.DataSource = pages;
// rptPager.DataBind();
//}
//public static DataSet GetAllSTD_FeesList_NotPaid()
//{
// DataSet sTD_Fees = new DataSet();
// SqlSTD_FeesProvider sqlSTD_FeesProvider = new SqlSTD_FeesProvider();
// sTD_Fees = sqlSTD_FeesProvider.GetAllSTD_FeesList_NotPaid();
// return sTD_Fees;
//}
public static STD_Fees GetSTD_CourseByCourseID(int CourseID)
{
STD_Fees sTD_Fees = new STD_Fees();
SqlSTD_FeesProvider sqlSTD_FeesProvider = new SqlSTD_FeesProvider();
sTD_Fees = sqlSTD_FeesProvider.GetSTD_FeesByCourseID(CourseID);
return sTD_Fees;
}
protected void txtAmount_OnTextChanged(object sender, EventArgs e)
{
int i = 0;
List<STD_Fees> fees = new List<STD_Fees>();
foreach (GridViewRow row in gvFeesAdd.Rows)
{
TextBox txtAmount = (TextBox)row.FindControl("txtAmount");
TextBox txtSubmissionDate = (TextBox)row.FindControl("txtSubmissionDate");
STD_Fees fee = new STD_Fees();
fee.FeesID = i;
fee.SubmissionDate = DateTime.Parse(txtSubmissionDate.Text);
fee.Amount = decimal.Parse(txtAmount.Text);
fee.IsPaid = false;
fee.IsEnabled = false;
fees.Add(fee);
i++;
}
Session["fees"] = fees;
gvFeesAdd.DataSource = fees;
gvFeesAdd.DataBind();
}
public static STD_Fees GetSTD_FeesStudentByStudentID(string StudentID)
{
STD_Fees sTD_Fees = new STD_Fees();
SqlSTD_FeesProvider sqlSTD_FeesProvider = new SqlSTD_FeesProvider();
sTD_Fees = sqlSTD_FeesProvider.GetSTD_FeesByStudentID(StudentID);
return sTD_Fees;
}
public static STD_Fees GetSTD_FeesTypeByFeesTypeID(int FeesTypeID)
{
STD_Fees sTD_Fees = new STD_Fees();
SqlSTD_FeesProvider sqlSTD_FeesProvider = new SqlSTD_FeesProvider();
sTD_Fees = sqlSTD_FeesProvider.GetSTD_FeesByFeesTypeID(FeesTypeID);
return sTD_Fees;
}
public STD_Fees GetSTD_FeesFromReader(IDataReader reader)
{
try
{
STD_Fees sTD_Fees = new STD_Fees
(
DataAccessObject.IsNULL<int>(reader["FeesID"]),
DataAccessObject.IsNULL<string>(reader["FeesName"]),
DataAccessObject.IsNULL<decimal>(reader["Amount"]),
DataAccessObject.IsNULL<int>(reader["FeesTypeID"]),
DataAccessObject.IsNULL<DateTime>(reader["SubmissionDate"]),
DataAccessObject.IsNULL<string>(reader["SubmitedDate"]),
DataAccessObject.IsNULL<string>(reader["StudentID"].ToString()),
DataAccessObject.IsNULL<int>(reader["CourseID"]),
DataAccessObject.IsNULL<string>(reader["AddedBy"].ToString()),
DataAccessObject.IsNULL<DateTime>(reader["AddedDate"]),
DataAccessObject.IsNULL<string>(reader["UpdatedBy"].ToString()),
DataAccessObject.IsNULL<DateTime>(reader["UpdateDate"]),
DataAccessObject.IsNULL<int>(reader["RowStatusID"]),
DataAccessObject.IsNULL<string>(reader["Remarks"]),
DataAccessObject.IsNULL<bool>(reader["IsPaid"])
);
return sTD_Fees;
}
catch(Exception ex)
{
return null;
}
}
