Student Accounting
shinta0x01
perl
2 years ago
19 kB
30
Indexable
#JQuery
$().ready(function () {
$('.display').hide()
$(".btn").click(function () {
if ($('#stud_id').val() == "" || $('#lname') == "" || $('#fname') == "") {
alert("Some fields are empty")
} else {
$('.ass').show()
$('.display').show()
$.post('../Home/postStudentAccounting', {
stud_id: $('#stud_id').val(),
lname: $('#lname').val(),
fname: $('#fname').val(),
gender: $('input[name="gender"]:checked').val(),
course_code: $('#course_code').val(),
year: $('#year').val(),
subject: $('#subject').val()
}, function (data) {
$('#d_studid').text('Student ID: ' + data[0].stud_id)
$('#d_name').text('Name: ' + data[0].lname + ", " + data[0].fname)
$('#d_gender').text('Gender: ' + data[0].gender)
$('#d_coursecode').text('Course Code: ' + data[0].course_code)
$('#d_course').text('Course: ' + data[0].course)
$('#d_year').text('Year: ' + data[0].year)
$('#d_subject').text('Subjects: ' + data[0].subject)
$('#d_totalunit').text('Total Unit: ' + data[0].total_unit)
$('#d_tuitionperunit').text('Tuition Per Unit: ' + data[0].tuition_unit)
$('#d_totaltuition').text('Total Tuition: ' + data[0].total_tuition)
$('#d_reg').text('Registration: ' + data[0].reg)
$('#d_misc').text('Miscellaneous: ' + data[0].misc)
$('#d_labfee').text('Lab Fee: ' + data[0].lab_fee)
$('#d_totalfee').text('Total Fee: ' + data[0].total_fee)
$('#p').text(data[0].prelim_fee)
$('#m').text(data[0].midterm_fee)
$('#s').text(data[0].semi_fee)
$('#f').text(data[0].final_fee)
$('#d_mop').text('Mode of Payment: ' + data[0].mop)
})
}
})
$('.ass').hide()
$('#btnfee').click(function () {
$.post('../Home/postStudentFee', {
radio_val: $('input[name="fee"]:checked').val(),
pre_val: $('#p').text(),
mid_val: $('#m').text(),
semi_val: $('#s').text(),
final_val: $('#f').text(),
tendered_amt: $('#tendered_amt').val(),
}, function (data) {
console.log(data[0].final_tendered)
if (data[0].final_tendered < data[0].amount) {
alert("Insufficient Balance")
} else {
$('#word').text(data[0].word + " and " + data[0].cents + " cents")
$('#change').html("<b>" + "Change: " + data[0].change + "</b>")
}
})
})
})
#HTML
<div class="container">
<div class="row">
<h2 class=" text-center">Student Accounting</h2>
<div class="col-md-4">
Student ID
<input class="form-control" type="number" id="stud_id" placeholder="Student ID" /><br />
Lastname
<input class="form-control" type="text" id="lname" placeholder="Lastname" /><br />
Firstname
<input class="form-control" type="text" id="fname" placeholder="Firstname" /><br />
Gender: <br /><input type="radio" name="gender" id="male" value="Male" /> Male<br />
<input type="radio" name="gender" id="female" value="Female" /> Female<br />
<input type="radio" name="gender" id="others" value="Prefer not to say" /> Prefer not to say<br /><br />
<select class="form-control" id="course_code">
<option value="" selected disabled hidden>Course Code</option>
<option>0001</option>
<option>0002</option>
<option>0003</option>
<option>0004</option>
<option>0005</option>
<option>0006</option>
<option>0007</option>
<option>0008</option>
</select>
<br />
<select class="form-control" id="subject">
<option value="" selected disabled hidden>Subjects</option>
<option>1</option>
<option>2</option>
<option>3</option>
<option>4</option>
<option>5</option>
<option>6</option>
<option>7</option>
<option>8</option>
<option>9</option>
<option>10</option>
</select>
<br />
<select class="form-control" id="year">
<option value="" selected disabled hidden>Year</option>
<option>1</option>
<option>2</option>
<option>3</option>
<option>4</option>
</select><br />
<br /><br />
<button class="btn btn-primary">Submit</button>
</div>
<div class="display col-md-4">
<p id="d_studid">Student ID: </p>
<p id="d_name">Name: </p>
<p id="d_gender">Gender: </p>
<p id="d_coursecode">Course Code: </p>
<p id="d_course">Course: </p>
<p id="d_year">Year: </p>
<p id="d_subject">Subjects: </p>
<p id="d_totalunit">Total Unit: </p>
<p id="d_tuitionperunit">Tuition Per Unit: </p>
<p id="d_totaltuition"><b>Total Tuition: </b></p>
<p id="d_reg">Registration: </p>
<p id="d_misc">Miscellaneous: </p>
<p id="d_labfee">Lab Fee: </p>
<p id="d_totalfee">Total Fee: </p>
<p id="d_mop"><b>Mode of Payment: </b></p>
</div>
<div class="ass col-md-4">
<input type="radio" id="pre" name="fee" value="1" /><span id="d_prelimfee"> Prelim Fee </span><span id="p"></span><br />
<input type="radio" id="mid" name="fee" value="2" /><span id="d_midfee"> Midterm Fee </span><span id="m"></span><br />
<input type="radio" id="semi" name="fee" value="3" /><span id="d_semifee"> Semi Final Fee </span><span id="s"></span><br />
<input type="radio" id="final" name="fee" value="4" /><span id="d_finalfee"> Final Fee </span><span id="f"></span><br />
<input type="number" id="tendered_amt" />
<button class="btn btn-primary" id="btnfee">Save</button>
<br />
<p id="word"></p>
<p id="change"></p>
</div>
</div>
</div>
<script src="~/Scripts/jQuery/jquery-3.7.1.min.js"></script>
<script src="~/Scripts/js/studentaccounting.js"></script>
# CSharp
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Mvc;
namespace WebApplication1.Controllers
{
public class HomeController : Controller
{
public ActionResult Index()
{
return View();
}
public ActionResult About()
{
ViewBag.Message = "Your application description page.";
return View();
}
public ActionResult Contact()
{
ViewBag.Message = "Your contact page.";
return View();
}
public ActionResult StudentAccouting()
{
return View();
}
public ActionResult postStudentAccounting()
{
var data = new List<object>();
var stud_id = Request["stud_id"];
var lname = Request["lname"];
var fname = Request["fname"];
var gender = Request["gender"];
var course_code = Convert.ToInt32(Request["course_code"]);
var course = "";
var year = Request["year"];
var subject = Convert.ToInt32(Request["subject"]);
var total_unit = subject * 3.00;
var tuition_unit = 0.0;
var reg = 0.0;
var misc = 0.0;
var lab_fee = 0.0;
var mop = "";
if (course_code == 0001)
{
course = "C1";
tuition_unit = 356.75;
reg = 545.00;
misc = 1000.45;
lab_fee = 1900.75;
}
else if (course_code == 0002)
{
course = "C2";
tuition_unit = 387.75;
reg = 550.00;
misc = 1050.35;
lab_fee = 1920.20;
}
else if (course_code == 0003)
{
course = "C3";
tuition_unit = 345.94;
reg = 555.00;
misc = 1100.25;
lab_fee = 1939.65;
}
else if (course_code == 0004)
{
course = "C4";
tuition_unit = 351.26;
reg = 560.00;
misc = 1150.15;
lab_fee = 1959.10;
}
else if (course_code == 0005)
{
course = "C5";
tuition_unit = 378.44;
reg = 565.00;
misc = 1200.05;
lab_fee = 1978.55;
}
else if (course_code == 0006)
{
course = "C6";
tuition_unit = 326.11;
reg = 570.00;
misc = 1249.05;
lab_fee = 1998.00;
}
else if (course_code == 0007)
{
course = "C7";
tuition_unit = 310.45;
reg = 610.00;
misc = 1299.85;
lab_fee = 2017.45;
}
else if (course_code == 0008)
{
course = "C8";
tuition_unit = 399.79;
reg = 624.00;
misc = 1349.75;
lab_fee = 2036.90;
}
var total_tuition = Math.Round(total_unit * tuition_unit);
var total_fee = Math.Round(total_tuition + reg + misc + lab_fee, 2);
var prelim_fee = Math.Round(total_fee * .53, 2);
var midterm_fee = Math.Round(total_fee * .64, 2);
var semi_fee = Math.Round(total_fee * .75, 2);
var final_fee = Math.Round(total_fee, 2);
if (total_fee >= 8000)
{
mop = "CASH";
}
else if (total_fee >= 5000)
{
mop = "CHECK";
}
else
{
mop = "CREDIT";
}
data.Add(new
{
stud_id = stud_id,
lname = lname,
fname = fname,
gender = gender,
tuition_unit = tuition_unit,
course_code = course_code,
course = course,
year = year,
subject = subject,
total_unit = total_unit,
total_tuition = total_tuition,
reg = reg,
misc = misc,
lab_fee = lab_fee,
total_fee = total_fee,
prelim_fee = prelim_fee,
midterm_fee = midterm_fee,
semi_fee = semi_fee,
final_fee = final_fee,
mop = mop
});
return Json(data, JsonRequestBehavior.AllowGet);
}
public ActionResult postStudentFee()
{
var data = new List<object>();
var radio_val = Convert.ToInt32(Request["radio_val"]);
var pre_val = Convert.ToDouble(Request["pre_val"]);
var mid_val = Convert.ToDouble(Request["mid_val"]);
var semi_val = Convert.ToDouble(Request["semi_val"]);
var final_val = Convert.ToDouble(Request["final_val"]);
double amount = 0.0;
var tendered_amt = Convert.ToDouble(Request["tendered_amt"]);
double final_tendered = tendered_amt / 100;
if (radio_val == 1)
amount = pre_val;
else if(radio_val == 2)
amount = mid_val;
else if (radio_val == 3)
amount = semi_val;
else if(radio_val == 4)
amount = final_val;
var cents = Convert.ToInt32(amount * 100) % 100;
var word_amount = (int)amount;
int ones = word_amount % 10;
word_amount /= 10;
int tens = word_amount % 10;
word_amount /= 10;
int hundreds = word_amount % 10;
word_amount /= 10;
int thousands = word_amount % 10;
word_amount /= 10;
int tenThousands = word_amount % 10;
string word = "";
// Handling ten thousands place
if (tenThousands == 1)
{
if (thousands == 0)
word = "Ten Thousand";
else if (thousands == 1)
word = "Eleven Thousand";
else if (thousands == 2)
word = "Twelve Thousand";
else if (thousands == 3)
word = "Thirteen Thousand";
else if (thousands == 4)
word = "Fourteen Thousand";
else if (thousands == 5)
word = "Fifteen Thousand";
else if (thousands == 6)
word = "Sixteen Thousand";
else if (thousands == 7)
word = "Seventeen Thousand";
else if (thousands == 8)
word = "Eighteen Thousand";
else if (thousands == 9)
word = "Nineteen Thousand";
}
else if (tenThousands == 2)
word = "Twenty Thousand";
else if (tenThousands == 3)
word = "Thirty Thousand";
else if (tenThousands == 4)
word = "Forty Thousand";
else if (tenThousands == 5)
word = "Fifty Thousand";
else if (tenThousands == 6)
word = "Sixty Thousand";
else if (tenThousands == 7)
word = "Seventy Thousand";
else if (tenThousands == 8)
word = "Eighty Thousand";
else if (tenThousands == 9)
word = "Ninety Thousand";
// Handling thousands place
if (thousands != 0 && tenThousands != 1)
{
word += " ";
if (thousands == 1)
word += "One Thousand";
else if (thousands == 2)
word += "Two Thousand";
else if (thousands == 3)
word += "Three Thousand";
else if (thousands == 4)
word += "Four Thousand";
else if (thousands == 5)
word += "Five Thousand";
else if (thousands == 6)
word += "Six Thousand";
else if (thousands == 7)
word += "Seven Thousand";
else if (thousands == 8)
word += "Eight Thousand";
else if (thousands == 9)
word += "Nine Thousand";
}
// Handling hundreds place
if (hundreds != 0)
{
word += " ";
if (hundreds == 1)
word += "One Hundred";
else if (hundreds == 2)
word += "Two Hundred";
else if (hundreds == 3)
word += "Three Hundred";
else if (hundreds == 4)
word += "Four Hundred";
else if (hundreds == 5)
word += "Five Hundred";
else if (hundreds == 6)
word += "Six Hundred";
else if (hundreds == 7)
word += "Seven Hundred";
else if (hundreds == 8)
word += "Eight Hundred";
else if (hundreds == 9)
word += "Nine Hundred";
}
// Handling tens and ones place
if (tens != 0)
{
word += " ";
if (tens == 1)
{
if (ones == 0)
word += "Ten";
else if (ones == 1)
word += "Eleven";
else if (ones == 2)
word += "Twelve";
else if (ones == 3)
word += "Thirteen";
else if (ones == 4)
word += "Fourteen";
else if (ones == 5)
word += "Fifteen";
else if (ones == 6)
word += "Sixteen";
else if (ones == 7)
word += "Seventeen";
else if (ones == 8)
word += "Eighteen";
else if (ones == 9)
word += "Nineteen";
}
else
{
if (tens == 2)
word += "Twenty";
else if (tens == 3)
word += "Thirty";
else if (tens == 4)
word += "Forty";
else if (tens == 5)
word += "Fifty";
else if (tens == 6)
word += "Sixty";
else if (tens == 7)
word += "Seventy";
else if (tens == 8)
word += "Eighty";
else if (tens == 9)
word += "Ninety";
}
if (tens != 1 && ones != 0)
word += " ";
}
if (ones != 0 && tens != 1)
{
if (tens == 0)
word += " ";
if (ones == 1)
word += "One";
else if (ones == 2)
word += "Two";
else if (ones == 3)
word += "Three";
else if (ones == 4)
word += "Four";
else if (ones == 5)
word += "Five";
else if (ones == 6)
word += "Six";
else if (ones == 7)
word += "Seven";
else if (ones == 8)
word += "Eight";
else if (ones == 9)
word += "Nine";
}
var change = Math.Round(final_tendered - amount, 2);
data.Add(new
{
cents = cents,
amount = amount,
final_tendered = final_tendered,
word = word,
change = change,
});
return Json(data, JsonRequestBehavior.AllowGet);
}
}
}Editor is loading...
Leave a Comment