public static STD_FeesMaster GetSTD_FeesMasterByFeesMasterID(int FeesMasterID)
{
STD_FeesMaster sTD_FeesMaster = new STD_FeesMaster();
SqlSTD_FeesMasterProvider sqlSTD_FeesMasterProvider = new SqlSTD_FeesMasterProvider();
sTD_FeesMaster = sqlSTD_FeesMasterProvider.GetSTD_FeesMasterByFeesMasterID(FeesMasterID);
return sTD_FeesMaster;
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
STD_FeesMaster sTD_FeesMaster = new STD_FeesMaster ();
sTD_FeesMaster.FeesMasterID= int.Parse(Request.QueryString["ID"].ToString());
sTD_FeesMaster.FeesMasterName= txtFeesMasterName.Text;
sTD_FeesMaster.TotalPayment= decimal.Parse(txtTotalPayment.Text);
sTD_FeesMaster.Discount= decimal.Parse(txtDiscount.Text);
sTD_FeesMaster.TotalPaymentNeedtoPay= decimal.Parse(txtTotalPaymentNeedtoPay.Text);
sTD_FeesMaster.FeesTypeID= int.Parse(ddlFeesTypeID.SelectedValue);
sTD_FeesMaster.SubmissionDate= DateTime.Parse(txtSubmissionDate.Text);
sTD_FeesMaster.SubmitedDate= txtSubmitedDate.Text;
sTD_FeesMaster.StudentID= ddlStudentID.SelectedValue;
sTD_FeesMaster.CourseID= int.Parse(ddlCourseID.SelectedValue);
sTD_FeesMaster.Remarks= txtRemarks.Text;
sTD_FeesMaster.IsPaid= bool.Parse( radIsPaid.SelectedValue);
sTD_FeesMaster.PaymentStatusID= int.Parse(ddlPaymentStatusID.SelectedValue);
sTD_FeesMaster.ExtraField1= txtExtraField1.Text;
sTD_FeesMaster.ExtraField2= txtExtraField2.Text;
sTD_FeesMaster.ExtraField3= txtExtraField3.Text;
sTD_FeesMaster.ExtraField4= txtExtraField4.Text;
sTD_FeesMaster.ExtraField5= txtExtraField5.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(ddlRowStatusID.SelectedValue);
bool resutl =STD_FeesMasterManager.UpdateSTD_FeesMaster(sTD_FeesMaster);
Response.Redirect("AdminDisplaySTD_FeesMaster.aspx");
}
public static STD_FeesMaster GetSTD_CourseByCourseID(int CourseID)
{
STD_FeesMaster sTD_FeesMaster = new STD_FeesMaster();
SqlSTD_FeesMasterProvider sqlSTD_FeesMasterProvider = new SqlSTD_FeesMasterProvider();
sTD_FeesMaster = sqlSTD_FeesMasterProvider.GetSTD_FeesMasterByCourseID(CourseID);
return sTD_FeesMaster;
}
public static bool UpdateSTD_FeesMasterForJournalDelete(STD_FeesMaster sTD_FeesMaster)
{
SqlSTD_FeesMasterProvider sqlSTD_FeesMasterProvider = new SqlSTD_FeesMasterProvider();
return sqlSTD_FeesMasterProvider.UpdateSTD_FeesMasterForJournalDelete(sTD_FeesMaster);
}
public static bool UpdateSTD_FeesMasterFeesAdjustment(STD_FeesMaster sTD_FeesMaster)
{
SqlSTD_FeesMasterProvider sqlSTD_FeesMasterProvider = new SqlSTD_FeesMasterProvider();
return sqlSTD_FeesMasterProvider.UpdateSTD_FeesMasterFeesAdjustment(sTD_FeesMaster);
}
public bool UpdateSTD_FeesMaster(STD_FeesMaster sTD_FeesMaster)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("UpdateSTD_FeesMaster", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@FeesMasterID", SqlDbType.Int).Value = sTD_FeesMaster.FeesMasterID;
cmd.Parameters.Add("@FeesMasterName", SqlDbType.NVarChar).Value = sTD_FeesMaster.FeesMasterName;
cmd.Parameters.Add("@TotalPayment", SqlDbType.Decimal).Value = sTD_FeesMaster.TotalPayment;
cmd.Parameters.Add("@Discount", SqlDbType.Decimal).Value = sTD_FeesMaster.Discount;
cmd.Parameters.Add("@TotalPaymentNeedtoPay", SqlDbType.Decimal).Value = sTD_FeesMaster.TotalPaymentNeedtoPay;
cmd.Parameters.Add("@FeesTypeID", SqlDbType.Int).Value = sTD_FeesMaster.FeesTypeID;
cmd.Parameters.Add("@SubmissionDate", SqlDbType.DateTime).Value = sTD_FeesMaster.SubmissionDate;
cmd.Parameters.Add("@SubmitedDate", SqlDbType.NVarChar).Value = sTD_FeesMaster.SubmitedDate;
cmd.Parameters.Add("@StudentID", SqlDbType.NVarChar).Value = sTD_FeesMaster.StudentID;
cmd.Parameters.Add("@CourseID", SqlDbType.Int).Value = sTD_FeesMaster.CourseID;
cmd.Parameters.Add("@Remarks", SqlDbType.NText).Value = sTD_FeesMaster.Remarks;
cmd.Parameters.Add("@IsPaid", SqlDbType.Bit).Value = sTD_FeesMaster.IsPaid;
cmd.Parameters.Add("@PaymentStatusID", SqlDbType.Int).Value = sTD_FeesMaster.PaymentStatusID;
cmd.Parameters.Add("@ExtraField1", SqlDbType.NVarChar).Value = sTD_FeesMaster.ExtraField1;
cmd.Parameters.Add("@ExtraField2", SqlDbType.NVarChar).Value = sTD_FeesMaster.ExtraField2;
cmd.Parameters.Add("@ExtraField3", SqlDbType.NVarChar).Value = sTD_FeesMaster.ExtraField3;
cmd.Parameters.Add("@ExtraField4", SqlDbType.NVarChar).Value = sTD_FeesMaster.ExtraField4;
cmd.Parameters.Add("@ExtraField5", SqlDbType.NVarChar).Value = sTD_FeesMaster.ExtraField5;
cmd.Parameters.Add("@UpdatedBy", SqlDbType.NVarChar).Value = sTD_FeesMaster.UpdatedBy;
cmd.Parameters.Add("@UpdateDate", SqlDbType.DateTime).Value = sTD_FeesMaster.UpdateDate;
cmd.Parameters.Add("@RowStatusID", SqlDbType.Int).Value = sTD_FeesMaster.RowStatusID;
connection.Open();
int result = cmd.ExecuteNonQuery();
return result == 1;
}
}
protected void btnPayAdvance_Click(object sender, EventArgs e)
{
btnPayAdvance.Visible = false;
string remark=ddlAccountID.SelectedItem.Text+"( Fees ";
STD_FeesMaster feesMaster = new STD_FeesMaster();
feesMaster= STD_FeesMasterManager.GetSTD_FeesMasterByFeesMasterID(int.Parse(ddlFeesMaster.SelectedValue));
if (decimal.Parse(txtPaymentAmount.Text) > decimal.Parse(feesMaster.ExtraField2))
{
ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "Message", "alert('The amount can not be the dua amount..')", true);
return;
}
try
{
decimal paymentAmount = Convert.ToDecimal(txtPaymentAmount.Text);
foreach (GridViewRow grMaster in gvSTD_FeesMaster.Rows)
{
GridView gvFeesShow = (GridView)grMaster.FindControl(feesMaster.FeesTypeID == 31 ? "gvFeesShowForInstallment" : "gvFeesShow");
int FeesMasterID= Convert.ToInt32(((HiddenField)grMaster.FindControl("hfFeesMasterID")).Value);
if (feesMaster.FeesMasterID == FeesMasterID)
{
decimal payemntAmountB4Processing = paymentAmount;
List<STD_Fees> feesListUpdate = new List<STD_Fees>();
int newlyAddedFeeID = 0;
foreach (GridViewRow row in gvFeesShow.Rows)
{
bool isPaid = Convert.ToBoolean(((CheckBox)row.FindControl("chkIspaid")).Checked);
decimal unpaidAmount = decimal.Parse(((Label)row.FindControl("lblUnpaidAmount")).Text);
remark+="# "+((Label)row.FindControl("lblInstallmentNo")).Text+", ";
if(unpaidAmount !=0)
{
int feesID = Convert.ToInt32(((HiddenField)row.FindControl("hfFeesID")).Value);
STD_Fees currentFee = STD_FeesManager.GetSTD_FeesByFeesID(feesID);
if (paymentAmount >= unpaidAmount)
{
#region Fully Payment
paymentAmount -= (currentFee.Amount - decimal.Parse(currentFee.Remarks));
currentFee.IsPaid = true;
currentFee.SubmitedDate = DateTime.Today.ToString();
currentFee.UpdatedBy = Profile.card_id;
currentFee.UpdateDate = DateTime.Now;
currentFee.RowStatusID = int.Parse("1");
currentFee.Remarks = (decimal.Parse(currentFee.Remarks) + unpaidAmount).ToString();
feesListUpdate.Add(currentFee);
//bool resutl = STD_FeesManager.UpdateSTD_Fees(currentFee);
#endregion
}
else if (paymentAmount > 0)
{
#region Partial Payment
decimal amountRemaining = (currentFee.Amount - decimal.Parse(currentFee.Remarks)) - 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");//Temporary Updated In DB
currentFee.Remarks = (decimal.Parse(currentFee.Remarks)+ paymentAmount).ToString() ;
feesListUpdate.Add(currentFee);
//bool resutl = STD_FeesManager.UpdateSTD_Fees(currentFee);
////Add a new row
//STD_Fees newFee = new STD_Fees();
//newFee.FeesName = FeesMasterID.ToString();
//newFee.FeesTypeID= int.Parse( ddlAccountID.SelectedValue);
//newFee.StudentID = currentFee.StudentID;
//newFee.CourseID = currentFee.CourseID;
//newFee.UpdatedBy = Profile.card_id;
//newFee.UpdateDate = DateTime.Now;
//newFee.Amount = amountRemaining;
//newFee.SubmissionDate = currentFee.SubmissionDate;
//newFee.SubmitedDate = "";
//newFee.AddedBy = Profile.card_id;
//newFee.AddedDate = DateTime.Now;
//newFee.RowStatusID = int.Parse("10");//Temporary Updated In DB
//newFee.Remarks = "Partially payment done but Something remaining";
//newFee.IsPaid = false;
//newlyAddedFeeID = STD_FeesManager.InsertSTD_Fees(newFee);
#endregion
paymentAmount = 0;
break;
}
}
}
Session["feesListUpdate"] = feesListUpdate;
decimal payemntAmountAfterProcessing = paymentAmount;
//STD_FeesMaster feesMaster = STD_FeesMasterManager.GetSTD_FeesMasterByFeesMasterID(FeesMasterID);
//paid amount
feesMaster.ExtraField1 = (decimal.Parse(feesMaster.ExtraField1) + (payemntAmountB4Processing - payemntAmountAfterProcessing)).ToString();
//unpaid amount
feesMaster.ExtraField2 = (decimal.Parse(feesMaster.ExtraField2) - (payemntAmountB4Processing - payemntAmountAfterProcessing)).ToString();
if (decimal.Parse(feesMaster.ExtraField2) == 0)
{
feesMaster.IsPaid = true;
}
Session["feesMaster"] = feesMaster;
//STD_FeesMasterManager.UpdateSTD_FeesMaster(feesMaster);
ddlFeesTypeID.SelectedValue = ddlFeesMaster.SelectedValue;
//Response.Redirect("~/Accounting/JournalDoubleEntryCommon.aspx?newFeesID=" + newlyAddedFeeID.ToString() + "&DrOrCr=Cr&SubBasicAccountID=20&AccountID=" + ddlFeesTypeID.SelectedItem.Text + "&UserTypeID=1&StudentCode=" + txtStudentCode.Text + "&AccountIDMoney=1&UserTypeIDMoney=2&Amount=" + txtPaymentAmount.Text + "&Remarks=" + (txtRemarkForReceipt.Text != "" ? txtRemarkForReceipt.Text : remark) + "&IsAdmissionFees=" + hfIsAdmissionFees.Value);
if (ddlFeesTypeID.SelectedItem.Text == "31")//only for the installment fees
{
Response.Redirect("http://www.cucbd.net/Accounting/JournalDoubleEntryCommon.aspx?newFeesID=" + newlyAddedFeeID.ToString() + "&DrOrCr=Cr&SubBasicAccountID=20&AccountID=" + ddlFeesTypeID.SelectedItem.Text + "&UserTypeID=1&StudentCode=" + txtStudentCode.Text + "&AccountIDMoney=1&UserTypeIDMoney=2&Amount=" + txtPaymentAmount.Text + "&Remarks=" + feesMaster.ExtraField3 + "&IsAdmissionFees=" + hfIsAdmissionFees.Value);
}
else
{
Response.Redirect("http://www.cucbd.net/Accounting/JournalDoubleEntryCommon.aspx?newFeesID=" + newlyAddedFeeID.ToString() + "&DrOrCr=Cr&SubBasicAccountID=20&AccountID=" + ddlFeesTypeID.SelectedItem.Text + "&UserTypeID=1&StudentCode=" + txtStudentCode.Text + "&AccountIDMoney=1&UserTypeIDMoney=2&Amount=" + txtPaymentAmount.Text + "&Remarks=" + (txtRemarkForReceipt.Text != "" ? txtRemarkForReceipt.Text : remark) + "&IsAdmissionFees=" + hfIsAdmissionFees.Value);
}
}
}
txtPaymentAmount.Text = "";
showSTD_FeesDataByStudentIDnCourseID();
}
catch (Exception ex)
{
}
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
try
{
STD_Student sTD_Student = STD_StudentManager.GetSTD_StudentByStudentID(Request.QueryString["studentID"]);
//STD_Student temp_Stuent = new STD_Student();
sTD_Student.StudentID = sTD_Student.StudentID;
sTD_Student.StudentName = txtStudentName.Text;
if (Session["imagePath"] != null)
{
try
{
string dirUrl = "~/Uploads/StudentImages";
string dirPath = Server.MapPath(dirUrl);
if (!Directory.Exists(dirPath))
{
Directory.CreateDirectory(dirPath);
}
string picPath = Session["imagePath"].ToString();
Session.Remove("imagePath");
string[] st = picPath.ToString().Split('.');
string st_pic = st[1];
string fileName = sTD_Student.StudentID + "." + st_pic;
string fileUrl = dirUrl + "/" + fileName;
System.Drawing.Image stImage = System.Drawing.Image.FromFile(picPath);
stImage.Save(Server.MapPath(fileUrl));
sTD_Student.PPSizePhoto = fileUrl;
}
catch (Exception ex)
{
}
}
else
{
if (uplFile.PostedFile != null && uplFile.PostedFile.ContentLength > 0)
{
try
{
string dirUrl = "~/Uploads/StudentImages";
string dirPath = Server.MapPath(dirUrl);
if (!Directory.Exists(dirPath))
{
Directory.CreateDirectory(dirPath);
}
string fileName = Path.GetFileName(uplFile.PostedFile.FileName);
string fileUrl = dirUrl + "/" + sTD_Student.StudentID + "_" + Path.GetFileName(uplFile.PostedFile.FileName);
string filePath = Server.MapPath(fileUrl);
uplFile.PostedFile.SaveAs(filePath);
System.Drawing.Image originalImage = System.Drawing.Image.FromFile(filePath);
System.Drawing.Image resizedImage = resizeImageWithGivenValue(originalImage, 150, 150);
resizedImage.Save(dirPath + "/" + "Display_" + sTD_Student.StudentID + fileName, ImageFormat.Jpeg);
sTD_Student.PPSizePhoto = dirUrl + "/" + "Display_" + sTD_Student.StudentID + fileName;
}
catch (Exception ex)
{
}
}
}
sTD_Student.StudentCode = txtStudentCode.Text;
sTD_Student.PresentAddress = txtPresentAddress.Text;
sTD_Student.PermanentAddress = txtPermanentAddress.Text;
sTD_Student.Telephone = txtTelephone.Text;
sTD_Student.Mobile = txtMobile.Text;
sTD_Student.Email = txtEmail.Text;
sTD_Student.DateofBirth = DateTime.Parse(txtDateofBirth.Text);
sTD_Student.PassportNo = txtPassportNo.Text;
sTD_Student.Gender = txtGender.Text;
sTD_Student.MaritualStatusID = int.Parse(ddlMaritualStatusID.SelectedValue);
sTD_Student.ReligionID = int.Parse(ddlReligionID.SelectedValue);
sTD_Student.SpouseQualification = ddlCourseID.SelectedValue;
sTD_Student.EnglishQualification = txtEnglishQualification.Text;
sTD_Student.IsRegisterWithACCA = radIsRegisterWithACCA.SelectedValue == "" ? false : Convert.ToBoolean(radIsRegisterWithACCA.SelectedValue);
sTD_Student.RegistrationDate = txtRegistrationDate.Text != "" ? DateTime.Parse(txtRegistrationDate.Text) : DateTime.Parse("1/1/1753");
sTD_Student.RegistrationNo = txtRegistrationNo.Text;
sTD_Student.AddedBy = Profile.card_id;
sTD_Student.AddedDate = DateTime.Now;
sTD_Student.ModifiedBy = Profile.card_id;
sTD_Student.ModifiedDate = DateTime.Now;
sTD_Student.BloodGroup = txtBloodGroup.Text;
sTD_Student.IELTS = txtIELTS.Text != "" ? decimal.Parse(txtIELTS.Text) : 0;
sTD_Student.TOFEL = txtTOFEL.Text != "" ? decimal.Parse(txtTOFEL.Text) : 0;
sTD_Student.BatchNo = Convert.ToInt32(ddlBatchID.SelectedValue);
bool resutl = STD_StudentManager.UpdateSTD_Student(sTD_Student);
//add to educational background to the db
//delete the old educational history
//COMN_EducatinalBackgroundManager.DeleteCOMN_EducatinalBackgroundByUserID(sTD_Student.StudentID);
if (Session["educationalBackground"] != null)
{
List<COMN_EducatinalBackground> educationalBackground = new List<COMN_EducatinalBackground>();
educationalBackground = (List<COMN_EducatinalBackground>)Session["educationalBackground"];
List<COMN_EducatinalBackground> educations = COMN_EducatinalBackgroundManager.GetCOMN_EducatinalBackgroundsByUserID(sTD_Student.StudentID);
foreach (COMN_EducatinalBackground education in educations)
{
COMN_EducatinalBackgroundManager.DeleteCOMN_EducatinalBackground(education.EducationalBacgroundID);
}
foreach (COMN_EducatinalBackground cOMN_EducatinalBackground in educationalBackground)
{
cOMN_EducatinalBackground.UserID = sTD_Student.StudentID;
COMN_EducatinalBackgroundManager.InsertCOMN_EducatinalBackground(cOMN_EducatinalBackground);
}
educationalBackground.RemoveRange(0, educationalBackground.Count);
}
//delete Job exprience
//STD_ContactManager.DeleteSTD_ContactByStudentID(sTD_Student.StudentID);
//delete Job exprience
//COMN_JobExperienceManager.DeleteCOMN_JobExperienceByUserID(sTD_Student.StudentID);
if (Session["jobexperience"] != null)
{
List<COMN_JobExperience> jobexperience = new List<COMN_JobExperience>();
jobexperience = (List<COMN_JobExperience>)Session["jobexperience"];
List<COMN_JobExperience> jobs = COMN_JobExperienceManager.GetCOMN_JobExperiencesByUserID(sTD_Student.StudentID);
foreach (COMN_JobExperience job in jobs)
{
COMN_JobExperienceManager.DeleteCOMN_JobExperience(job.JobExperienceID);
}
foreach (COMN_JobExperience cOMN_JobExperience in jobexperience)
{
cOMN_JobExperience.UserID = sTD_Student.StudentID;
COMN_JobExperienceManager.InsertCOMN_JobExperience(cOMN_JobExperience);
}
jobexperience.RemoveRange(0, jobexperience.Count);
}
//delete Job exprience
//STD_ContactManager.DeleteSTD_ContactByStudentID(sTD_Student.StudentID);
// Add job_experience
if (Session["contacts"] != null)
{
List<STD_Contact> contacts = new List<STD_Contact>();
contacts = (List<STD_Contact>)Session["contacts"];
List<STD_Contact> sTD_contacts = STD_ContactManager.GetSTD_ContactsByStudentID(sTD_Student.StudentID);
foreach (STD_Contact contact in sTD_contacts)
{
STD_ContactManager.DeleteSTD_Contact(contact.ContactID);
}
foreach (STD_Contact sTD_Contact in contacts)
{
sTD_Contact.StudentID = sTD_Student.StudentID;
STD_ContactManager.InsertSTD_Contact(sTD_Contact);
}
contacts.RemoveRange(0, contacts.Count);
}
#region Update the semester Fee and course
if (
hfLatestSemesterFeesAmount.Value != txtSemesterFee.Text
|| hfLatestSemesterFeesCourseID.Value != ddlCourseID.SelectedValue
)
{
if (decimal.Parse(txtSemesterFee.Text) != 0)
{
STD_FeesMaster sTD_FeesMaster = new STD_FeesMaster();
sTD_FeesMaster = insertFeesMaster(29, sTD_Student.StudentID); //Semester Fee = 29
}
}
#endregion
Response.Redirect("AdminDetailsSTD_Student.aspx?ID=" + Request.QueryString["studentID"]);
}
catch (Exception ex)
{
lblError.Text = ex.Message;
}
}
public static STD_FeesMaster GetSTD_PaymentStatusByPaymentStatusID(int PaymentStatusID)
{
STD_FeesMaster sTD_FeesMaster = new STD_FeesMaster();
SqlSTD_FeesMasterProvider sqlSTD_FeesMasterProvider = new SqlSTD_FeesMasterProvider();
sTD_FeesMaster = sqlSTD_FeesMasterProvider.GetSTD_FeesMasterByPaymentStatusID(PaymentStatusID);
return sTD_FeesMaster;
}
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;
}
private void showSTD_FeesMasterData()
{
STD_FeesMaster sTD_FeesMaster = new STD_FeesMaster ();
sTD_FeesMaster = STD_FeesMasterManager.GetSTD_FeesMasterByFeesMasterID(Int32.Parse(Request.QueryString["ID"]));
txtFeesMasterName.Text =sTD_FeesMaster.FeesMasterName.ToString();
txtTotalPayment.Text =sTD_FeesMaster.TotalPayment.ToString();
txtDiscount.Text =sTD_FeesMaster.Discount.ToString();
txtTotalPaymentNeedtoPay.Text =sTD_FeesMaster.TotalPaymentNeedtoPay.ToString();
ddlFeesTypeID.SelectedValue =sTD_FeesMaster.FeesTypeID.ToString();
txtSubmissionDate.Text =sTD_FeesMaster.SubmissionDate.ToString();
txtSubmitedDate.Text =sTD_FeesMaster.SubmitedDate.ToString();
ddlStudentID.SelectedValue =sTD_FeesMaster.StudentID.ToString();
ddlCourseID.SelectedValue =sTD_FeesMaster.CourseID.ToString();
txtRemarks.Text =sTD_FeesMaster.Remarks.ToString();
radIsPaid.SelectedValue =sTD_FeesMaster.IsPaid.ToString();
ddlPaymentStatusID.SelectedValue =sTD_FeesMaster.PaymentStatusID.ToString();
txtExtraField1.Text =sTD_FeesMaster.ExtraField1.ToString();
txtExtraField2.Text =sTD_FeesMaster.ExtraField2.ToString();
txtExtraField3.Text =sTD_FeesMaster.ExtraField3.ToString();
txtExtraField4.Text =sTD_FeesMaster.ExtraField4.ToString();
txtExtraField5.Text =sTD_FeesMaster.ExtraField5.ToString();
ddlRowStatusID.SelectedValue =sTD_FeesMaster.RowStatusID.ToString();
}
protected void btnFees_OnClick(object sender, EventArgs e)
{
List<Student> students = StudentManager.GetAllStudents();
foreach (Student student in students)
{
STD_FeesMaster feesMaster = new STD_FeesMaster();
//feesMaster.CourseID =int.Parse(student.P_id);
//feesMaster.Discount = decimal.Parse(student.Course_discount);
//feesMaster.TotalPayment = decimal.Parse(student.Total);
//feesMaster.TotalPaymentNeedtoPay = decimal.Parse(student.Total) - decimal.Parse(student.Course_discount);
//feesMaster.FeesTypeID = 31;
//feesMaster.FeesMasterName = "";
//feesMaster.AddedBy = "530038e1-cf38-4ddb-84a4-99b6974b4f9d";
//feesMaster.AddedDate = DateTime.Now;
STD_Student st = STD_StudentManager.GetHR_StudnetByStudentCode(student.S_id);
if (st == null)
lblError.Text =lblError.Text+ " " +student.S_id ;
//if (st != null)
// feesMaster.StudentID = st.StudentID;
//else
// continue;
//feesMaster.RowStatusID = 1;
//feesMaster.Remarks = "";
//feesMaster.SubmissionDate = DateTime.Now;
//feesMaster.SubmitedDate = "";
//feesMaster.UpdateDate = DateTime.Now;
//feesMaster.UpdatedBy = "530038e1-cf38-4ddb-84a4-99b6974b4f9d";
//feesMaster.PaymentStatusID = 1;
//feesMaster.ExtraField1 = student.TotalPayemt;
//feesMaster.ExtraField2 = (decimal.Parse(student.Total) - decimal.Parse(student.Course_discount) - decimal.Parse(feesMaster.ExtraField1)).ToString();
//if (feesMaster.ExtraField2 == "0")
// feesMaster.IsPaid = true;
//else
// feesMaster.IsPaid = false;
//feesMaster.ExtraField3 = "";
//feesMaster.ExtraField4 = "";
//feesMaster.ExtraField5 = "";
//int result = STD_FeesMasterManager.InsertSTD_FeesMaster(feesMaster);
}
//lblError.Text = "Fees Added Successfully.";
}
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"]);
}
public bool UpdateSTD_FeesMasterForJournalDelete(STD_FeesMaster sTD_FeesMaster)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("UpdateSTD_FeesMasterForJournalDelete", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@FeesMasterID", SqlDbType.Int).Value = sTD_FeesMaster.FeesMasterID;
cmd.Parameters.Add("@ExtraField1", SqlDbType.NVarChar).Value = sTD_FeesMaster.ExtraField1;
cmd.Parameters.Add("@ExtraField2", SqlDbType.NVarChar).Value = sTD_FeesMaster.ExtraField2;
cmd.Parameters.Add("@UpdatedBy", SqlDbType.NVarChar).Value = sTD_FeesMaster.UpdatedBy;
cmd.Parameters.Add("@UpdateDate", SqlDbType.DateTime).Value = sTD_FeesMaster.UpdateDate;
connection.Open();
int result = cmd.ExecuteNonQuery();
return result == 1;
}
}
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;
}
public static STD_FeesMaster GetSTD_RowStatusByRowStatusID(int RowStatusID)
{
STD_FeesMaster sTD_FeesMaster = new STD_FeesMaster();
SqlSTD_FeesMasterProvider sqlSTD_FeesMasterProvider = new SqlSTD_FeesMasterProvider();
sTD_FeesMaster = sqlSTD_FeesMasterProvider.GetSTD_FeesMasterByRowStatusID(RowStatusID);
return sTD_FeesMaster;
}
protected void btnAdd_Click(object sender, EventArgs e)
{
try
{
string studentCode = "";
DateTime date = DateTime.Now;
int year = date.Year;
string batchNo = "";
STD_Student student = STD_StudentManager.GetAllSTD_StudentsByBatchNo(ddlBatchID.SelectedValue != "" ? Convert.ToInt32(ddlBatchID.SelectedValue) : 0);
int sID = 0;
if (student != null)
{
sID = student.MaxID ;
}
else
{
sID = 1;
}
if (ddlBatchID.SelectedValue.Length > 3)
{
batchNo = ddlBatchID.SelectedValue.Substring(2, 3);
}
studentCode = year.ToString().Substring(2, 2) + batchNo + sID.ToString("000");
try
{
while (Membership.ValidateUser(studentCode, Membership.Provider.GetPassword(studentCode, "a")))
{
sID = sID + 1;
studentCode = year.ToString().Substring(2, 2) + batchNo + sID.ToString("000");
//break;
}
}
catch (Exception ex)
{
}
lblError.ForeColor = System.Drawing.Color.Red;
var employeerPhoto = string.Empty;
var studentID = "";
string email = "";
#region Create User
if (txtEmail.Text != "")
{
MembershipCreateStatus result;
try
{
txtStudentCode.Text = studentCode;//set the studentCode;
Membership.CreateUser(studentCode, "123456", txtEmail.Text, "a", "a", true, out result);
switch (result)
{
case MembershipCreateStatus.Success:
FormsAuthentication.SetAuthCookie(txtStudentCode.Text.ToString(), true);
var role = "STD";
MembershipUser myObject = Membership.GetUser(txtStudentCode.Text.Trim());
studentID = myObject.ProviderUserKey.ToString();
//Assign Role to the Student
if(!Roles.IsUserInRole("Student"))
Roles.AddUserToRole(myObject.UserName, "Student");
lblError.Text = "User successfully created!";
lblError.ForeColor = System.Drawing.Color.Green;
break;
case MembershipCreateStatus.InvalidUserName:
lblError.Text = "The username format was invalid. Please enter a different username.";
break;
case MembershipCreateStatus.InvalidPassword:
lblError.Text = "The password was invalid: A password cannot be an empty string and must also meet the pasword strength requirements of the configured provider. Please enter a new password.";
break;
case MembershipCreateStatus.InvalidEmail:
lblError.Text = "The email format was invalid. Please enter a different username.";
break;
case MembershipCreateStatus.InvalidQuestion:
lblError.Text = "The password question format was invalid. Please enter a different question.";
break;
case MembershipCreateStatus.InvalidAnswer:
lblError.Text = "The password answer format was invalid. Please enter a different answer.";
break;
case MembershipCreateStatus.DuplicateUserName:
lblError.Text = "The username is already in use. Please enter a new username.";
break;
case MembershipCreateStatus.DuplicateEmail:
lblError.Text = "The email address is already in use. Please enter a different email address.";
break;
default:
lblError.Text = "An error occurred while creating the user.";
break;
}
}
catch (Exception ex)
{
lblError.Text = ex.Message;
return;
}
}
else
{
MembershipCreateStatus result;
try
{
txtStudentCode.Text = studentCode;//set the studentCode;
email = studentCode.ToString() + "@cuc.com";
Membership.CreateUser(studentCode, "123456", email, "a", "a", true, out result);
switch (result)
{
case MembershipCreateStatus.Success:
FormsAuthentication.SetAuthCookie(txtStudentCode.Text.ToString(), true);
var role = "STD";
MembershipUser myObject = Membership.GetUser(txtStudentCode.Text.Trim());
studentID = myObject.ProviderUserKey.ToString();
if (!Roles.IsUserInRole("Student"))
Roles.AddUserToRole(myObject.UserName, "Student");
lblError.Text = "User successfully created!";
lblError.ForeColor = System.Drawing.Color.Green;
break;
case MembershipCreateStatus.InvalidUserName:
lblError.Text = "The username format was invalid. Please enter a different username.";
break;
case MembershipCreateStatus.InvalidPassword:
lblError.Text = "The password was invalid: A password cannot be an empty string and must also meet the pasword strength requirements of the configured provider. Please enter a new password.";
break;
case MembershipCreateStatus.InvalidEmail:
lblError.Text = "The email format was invalid. Please enter a different username.";
break;
case MembershipCreateStatus.InvalidQuestion:
lblError.Text = "The password question format was invalid. Please enter a different question.";
break;
case MembershipCreateStatus.InvalidAnswer:
lblError.Text = "The password answer format was invalid. Please enter a different answer.";
break;
case MembershipCreateStatus.DuplicateUserName:
lblError.Text = "The username is already in use. Please enter a new username.";
break;
case MembershipCreateStatus.DuplicateEmail:
lblError.Text = "The email address is already in use. Please enter a different email address.";
break;
default:
lblError.Text = "An error occurred while creating the user.";
break;
}
}
catch (Exception ex)
{
lblError.Text = ex.Message;
return;
}
}
//load The loggedin user
FormsAuthentication.SetAuthCookie(hfLoggedInUserID.Value, true);
MembershipUser myObjectLoggedInUser = Membership.GetUser(hfLoggedInUserID.Value);
#endregion
#region StudentInfo
try
{
STD_Student sTD_Student = new STD_Student();
sTD_Student.StudentID = studentID;
sTD_Student.StudentName = txtStudentName.Text.Trim();
//sTD_Student.PPSizePhoto= "Fileurl";
if (Session["imagePath"] != null)
{
try
{
string dirUrl = "~/Uploads/StudentImages";
string dirPath = Server.MapPath(dirUrl);
if (!Directory.Exists(dirPath))
{
Directory.CreateDirectory(dirPath);
}
string picPath = Session["imagePath"].ToString();
Session.Remove("imagePath");
string[] st = picPath.ToString().Split('.');
string st_pic = st[1];
string fileName = sTD_Student.StudentID + "." + st_pic;
string fileUrl = dirUrl + "/" + fileName;
System.Drawing.Image stImage = System.Drawing.Image.FromFile(picPath);
stImage.Save(Server.MapPath(fileUrl));
sTD_Student.PPSizePhoto = fileUrl;
}
catch (Exception ex)
{
lblError.Text = ex.Message;
}
}
else
{
if (uplFile.PostedFile != null && uplFile.PostedFile.ContentLength > 0)
{
try
{
string dirUrl = "~/Uploads/StudentImages";
string dirPath = Server.MapPath(dirUrl);
if (!Directory.Exists(dirPath))
{
Directory.CreateDirectory(dirPath);
}
string fileName = Path.GetFileName(uplFile.PostedFile.FileName);
string fileUrl = dirUrl + "/" + sTD_Student.StudentID + "_" + Path.GetFileName(uplFile.PostedFile.FileName);
string filePath = Server.MapPath(fileUrl);
uplFile.PostedFile.SaveAs(filePath);
System.Drawing.Image originalImage = System.Drawing.Image.FromFile(filePath);
System.Drawing.Image resizedImage = resizeImageWithGivenValue(originalImage, 150, 150);
resizedImage.Save(dirPath + "/" + "Display_" + sTD_Student.StudentID + fileName, ImageFormat.Jpeg);
sTD_Student.PPSizePhoto = dirUrl + "/" + "Display_" + sTD_Student.StudentID + fileName;
}
catch (Exception ex)
{
lblError.Text = ex.Message;
}
}
else
{
sTD_Student.PPSizePhoto = "~/Uploads/StudentImages/NoImage.jpg";
}
}
sTD_Student.StudentCode = txtStudentCode.Text;
sTD_Student.PresentAddress = txtPresentAddress.Text;
sTD_Student.PermanentAddress = txtPermanentAddress.Text;
sTD_Student.Telephone = txtTelephone.Text;
sTD_Student.Mobile = txtMobile.Text;
sTD_Student.Email = txtEmail.Text != "" ? txtEmail.Text : email;
sTD_Student.DateofBirth = DateTime.Parse(txtDateofBirth.Text);
sTD_Student.PassportNo = txtPassportNo.Text;
sTD_Student.Gender = txtGender.Text;
sTD_Student.MaritualStatusID = ddlMaritualStatusID.SelectedValue != "" ? int.Parse(ddlMaritualStatusID.SelectedValue) : 0;
sTD_Student.ReligionID = ddlReligionID.SelectedValue != "" ? int.Parse(ddlReligionID.SelectedValue) : 0;
sTD_Student.SpouseQualification = ddlCourseID.SelectedValue;
sTD_Student.EnglishQualification = txtEnglishQualification.Text;
sTD_Student.IsRegisterWithACCA = Convert.ToBoolean(radIsRegisterWithACCA.SelectedValue);
sTD_Student.RegistrationDate = txtRegistrationDate.Text != "" ? DateTime.Parse(txtRegistrationDate.Text) : DateTime.Parse("1/1/1753");
sTD_Student.RegistrationNo = txtRegistrationNo.Text;
sTD_Student.AddedBy = Profile.card_id;
sTD_Student.AddedDate = DateTime.Now;
sTD_Student.ModifiedBy = Profile.card_id;
sTD_Student.ModifiedDate = DateTime.Now;
sTD_Student.BloodGroup = txtBloodGroup.Text;
sTD_Student.IELTS = txtIELTS.Text != "" ? decimal.Parse(txtIELTS.Text) : 0;
sTD_Student.TOFEL = txtTOFEL.Text != "" ? decimal.Parse(txtTOFEL.Text) : 0;
sTD_Student.ID = sID;
sTD_Student.BatchNo = ddlBatchID.SelectedValue != "" ? Convert.ToInt32(ddlBatchID.SelectedValue) : 0;
sTD_Student.Year = year;
//sTD_Student.StudentID =
sTD_Student.RowStatusID = 1;
DataSet dsStudent = new DataSet();
dsStudent = STD_StudentManager.InsertSTD_Student(sTD_Student);
sTD_Student.StudentID = dsStudent.Tables[0].Rows[0]["StudentID"].ToString();
sTD_Student.StudentCode = dsStudent.Tables[0].Rows[0]["StudentCode"].ToString();
//add to educational background to the db
if (Session["educationalBackground"] != null)
{
List<COMN_EducatinalBackground> educationalBackground = new List<COMN_EducatinalBackground>();
educationalBackground = (List<COMN_EducatinalBackground>)Session["educationalBackground"];
foreach (COMN_EducatinalBackground cOMN_EducatinalBackground in educationalBackground)
{
cOMN_EducatinalBackground.UserID = sTD_Student.StudentID;
COMN_EducatinalBackgroundManager.InsertCOMN_EducatinalBackground(cOMN_EducatinalBackground);
}
educationalBackground.RemoveRange(0, educationalBackground.Count);
}
// Add job_experience
if (Session["jobexperience"] != null)
{
List<COMN_JobExperience> jobexperience = new List<COMN_JobExperience>();
jobexperience = (List<COMN_JobExperience>)Session["jobexperience"];
foreach (COMN_JobExperience cOMN_JobExperience in jobexperience)
{
cOMN_JobExperience.UserID = sTD_Student.StudentID;
COMN_JobExperienceManager.InsertCOMN_JobExperience(cOMN_JobExperience);
}
jobexperience.RemoveRange(0, jobexperience.Count);
}
// Add job_experience
if (Session["contacts"] != null)
{
List<STD_Contact> contacts = new List<STD_Contact>();
contacts = (List<STD_Contact>)Session["contacts"];
foreach (STD_Contact sTD_Contact in contacts)
{
sTD_Contact.StudentID = sTD_Student.StudentID;
STD_ContactManager.InsertSTD_Contact(sTD_Contact);
}
contacts.RemoveRange(0, contacts.Count);
}
}
catch (Exception ex)
{
lblError.Text = ex.Message;
}
#endregion
#region Add semester fee
if (txtSemesterFee.Text != "" && txtSemesterFee.Text != "0" && ddlCourseID.SelectedIndex != 0)
{
STD_FeesMaster sTD_FeesMaster = new STD_FeesMaster();
sTD_FeesMaster = insertFeesMaster(29, studentID); //Semester Fee = 29
}
#endregion
Response.Redirect("AdminDetailsSTD_Student.aspx?ID=" + studentID);
}
catch (Exception ex)
{
lblError.Text = ex.Message;
}
}
public static STD_FeesMaster GetSTD_StudentByStudentID(string StudentID)
{
STD_FeesMaster sTD_FeesMaster = new STD_FeesMaster();
SqlSTD_FeesMasterProvider sqlSTD_FeesMasterProvider = new SqlSTD_FeesMasterProvider();
sTD_FeesMaster = sqlSTD_FeesMasterProvider.GetSTD_FeesMasterByStudentID(StudentID);
return sTD_FeesMaster;
}
private STD_FeesMaster insertFeesMaster(int accountID)
{
//add in the FeesMaster
STD_FeesMaster sTD_FeesMaster = new STD_FeesMaster();
// sTD_FeesMaster.FeesMasterID= int.Parse(ddlFeesMasterID.SelectedValue);
DataSet ds = STD_FeesMasterManager.GetSTD_FeesMasterByStudentIDnCourseIDnFeesTypeID(hfStudentID.Value, int.Parse(ddlCourseIDReceived.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(txtTotalAmount.Text);
sTD_FeesMaster.Discount += decimal.Parse(txtDiscount.Text);
sTD_FeesMaster.TotalPaymentNeedtoPay += decimal.Parse(txtTotalAmountNeedToPay.Text);
sTD_FeesMaster.IsPaid = false;
sTD_FeesMaster.PaymentStatusID = int.Parse("1");
sTD_FeesMaster.ExtraField2 = (decimal.Parse(sTD_FeesMaster.ExtraField2) + decimal.Parse(txtTotalAmountNeedToPay.Text)).ToString();
//sTD_FeesMaster.ExtraField3 += " "+ txtRemarkForReceipt.Text;
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(txtTotalAmount.Text);
sTD_FeesMaster.Discount = decimal.Parse(txtDiscount.Text);
sTD_FeesMaster.TotalPaymentNeedtoPay = decimal.Parse(txtTotalAmountNeedToPay.Text);
sTD_FeesMaster.FeesTypeID = accountID;
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 = txtRemarkForReceipt.Text;
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);
}
return sTD_FeesMaster;
}
public static int InsertSTD_FeesMaster(STD_FeesMaster sTD_FeesMaster)
{
SqlSTD_FeesMasterProvider sqlSTD_FeesMasterProvider = new SqlSTD_FeesMasterProvider();
return sqlSTD_FeesMasterProvider.InsertSTD_FeesMaster(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 = 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;
}
public STD_FeesMaster GetSTD_FeesMasterFromReader(IDataReader reader)
{
try
{
STD_FeesMaster sTD_FeesMaster = new STD_FeesMaster
(
DataAccessObject.IsNULL<int>(reader["FeesMasterID"]),
DataAccessObject.IsNULL<string>(reader["FeesMasterName"]),
DataAccessObject.IsNULL<decimal>(reader["TotalPayment"]),
DataAccessObject.IsNULL<decimal>(reader["Discount"]),
DataAccessObject.IsNULL<decimal>(reader["TotalPaymentNeedtoPay"]),
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["Remarks"]),
DataAccessObject.IsNULL<bool>(reader["IsPaid"]),
DataAccessObject.IsNULL<int>(reader["PaymentStatusID"]),
DataAccessObject.IsNULL<string>(reader["ExtraField1"]),
DataAccessObject.IsNULL<string>(reader["ExtraField2"]),
DataAccessObject.IsNULL<string>(reader["ExtraField3"]),
DataAccessObject.IsNULL<string>(reader["ExtraField4"]),
DataAccessObject.IsNULL<string>(reader["ExtraField5"]),
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"])
);
return sTD_FeesMaster;
}
catch(Exception ex)
{
return null;
}
}
