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; } }