public ActionResult DeleteConfirmed(int id) { NonRecurringFeeMultiplier nonRecurringFeeMultiplier = db.NonRecurringFeeMultipliers.Find(id); db.NonRecurringFeeMultipliers.Remove(nonRecurringFeeMultiplier); db.SaveChanges(); return(RedirectToAction("Index")); }
// GET: NonRecurringFeeMultipliers/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } NonRecurringFeeMultiplier nonRecurringFeeMultiplier = db.NonRecurringFeeMultipliers.Find(id); if (nonRecurringFeeMultiplier == null) { return(HttpNotFound()); } return(View(nonRecurringFeeMultiplier)); }
//public JsonResult EditMultiplier(int instal, int stdid) //{ // double? remaining = 0; // var list = db.NonRecurringMonths.Where(x => x.StudentId == stdid && x.Status == "Pending").Select(x => x.InstalmentAmount).ToList(); // foreach (var item in list) // { // remaining += item; // } // var SharePerInstalment = remaining / instal; // var RemainingInstalments = Convert.ToDouble(remaining / SharePerInstalment); // var result = new { remaining, SharePerInstalment, RemainingInstalments }; // return Json(result, JsonRequestBehavior.AllowGet); //} // GET: NonRecurringFeeMultipliers/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } NonRecurringFeeMultiplier nonRecurringFeeMultiplier = db.NonRecurringFeeMultipliers.Find(id); if (nonRecurringFeeMultiplier == null) { return(HttpNotFound()); } ViewBag.DescriptionId = new SelectList(db.NonRecurringCharges, "Id", "ExpenseType", nonRecurringFeeMultiplier.DescriptionId); return(View(nonRecurringFeeMultiplier)); }
public ActionResult Create([Bind(Include = "Id,StudentId,DescriptionId,Date,TutionFee,PaidAmount,RemainingAmount,SharePerInstalment,Instalments,PaidInstalments,RemainingInstalments,Multiplier")] NonRecurringFeeMultiplier nonRecurringFeeMultiplier) { try { if (ModelState.IsValid) { var classid = Convert.ToInt32(Request.Form["ClassId"]); var Month = Request.Form["Month"]; var stdid = db.AspNetStudents.Where(x => x.ClassID == classid && x.AspNetUser.Status != "False").Select(x => x.Id).ToList(); foreach (var item in stdid) { nonRecurringFeeMultiplier.StudentId = item; nonRecurringFeeMultiplier.Month = Month; nonRecurringFeeMultiplier.Status = "Pending"; db.NonRecurringFeeMultipliers.Add(nonRecurringFeeMultiplier); db.SaveChanges(); } //foreach (var item in stdid) //{ // NonRecurringMonth stdfeemonth = new NonRecurringMonth(); // stdfeemonth.StudentId = item; // stdfeemonth.Status = "Pending"; // stdfeemonth.InstalmentAmount = nonRecurringFeeMultiplier.TutionFee; // var dddd = DateTime.Now; // var d = dddd.ToString("yyyy-MM-dd"); // stdfeemonth.IssueDate = d; // stdfeemonth.Months = DateTime.Now.Month.ToString(); // db.NonRecurringMonths.Add(stdfeemonth); // db.SaveChanges(); //} //var stdList = db.AspNetStudents.Where(x => x.ClassID == classid).ToList().Count(); //for (int i = 0; i < stdList; i++) //{ // Ledger ledger = db.Ledgers.Where(x => x.Name == "Student Receivables").FirstOrDefault(); // ledger.StartingBalance += Convert.ToDecimal(nonRecurringFeeMultiplier.TutionFee); // ledger.CurrentBalance += Convert.ToDecimal(nonRecurringFeeMultiplier.TutionFee); // db.SaveChanges(); //} //for (int i = 0; i < stdList; i++) //{ // Ledger ledger = db.Ledgers.Where(x => x.Name == "Student Fee").FirstOrDefault(); // ledger.StartingBalance += Convert.ToDecimal(nonRecurringFeeMultiplier.TutionFee); // ledger.CurrentBalance += Convert.ToDecimal(nonRecurringFeeMultiplier.TutionFee); // db.SaveChanges(); //} return(RedirectToAction("Index")); } } catch (Exception e) { ViewBag.Error = e.Message; } ViewBag.DescriptionId = new SelectList(db.NonRecurringCharges, "Id", "ExpenseType", nonRecurringFeeMultiplier.DescriptionId); return(View(nonRecurringFeeMultiplier)); }
public JsonResult GetChallanForm(string month, string idlist) { var userid = idlist.Split(','); var Nextmonth = ""; var dates = db.FeeDateSettings.FirstOrDefault(); List <challanform> ChallanList = new List <challanform>(); try { foreach (var item in userid) { var student = db.AspNetStudents.Where(x => x.StudentID == item).FirstOrDefault(); StudentFeeMonth Student_FeeMonth = db.StudentFeeMonths.Where(x => x.StudentId == student.Id && x.Months == month).FirstOrDefault(); Student_FeeMonth.ValildityDate = dates.ValidityDate; Student_FeeMonth.DueDate = dates.DueDate; Student_FeeMonth.Status = "Printed"; db.SaveChanges(); int recordid = Student_FeeMonth.Id; recordid++; var Studentdata = db.StudentFeeMonths.Where(x => x.Id == recordid).FirstOrDefault(); if (Studentdata.Multiplier == 0) { Nextmonth = month + '-' + Studentdata.Months; } double?trip = 0; NonRecurringFeeMultiplier nonrecurringfee = db.NonRecurringFeeMultipliers.Where(x => x.StudentId == student.Id && x.Month == Student_FeeMonth.Months).FirstOrDefault(); if (nonrecurringfee != null) { trip = nonrecurringfee.TutionFee; } AspNetSession Session = db.AspNetSessions.OrderByDescending(x => x.Id).Select(x => x).FirstOrDefault(); decimal? No = 0; var Student_Penalty = db.StudentPenalties.Where(x => x.StudentId == student.Id && x.Status == "Pending").Select(x => x.PenaltyFee.Amount).FirstOrDefault(); if (Student_Penalty == null) { Student_Penalty = 0; } var Student_discount = db.StudentDiscounts.Where(x => x.StudentId == student.Id).Select(x => x.FeeDiscount.Amount).FirstOrDefault(); if (Student_discount == null) { Student_discount = 0; } ///////////////arrears//////////// var _SessionId = Student_FeeMonth.SessionId; int _Id = Student_FeeMonth.Id - 1; bool Flag = true; double?Arrear = 0; while (Flag) { try { double?payableamount = db.StudentFeeMonths.Where(x => x.StudentId == student.Id && x.SessionId == _SessionId && x.Status == "Pending" && x.Id == _Id).FirstOrDefault().FeePayable; Arrear += payableamount; _Id--; } catch (Exception ex) { Flag = false; } } /////////End///////// challanform Challan = new challanform(); Challan.AcademicSessionStart = Session.SessionStartDate; Challan.AcademicSessionEnd = Session.SessionEndDate; Challan.StudentName = student.AspNetUser.Name; Challan.StudentUserName = student.AspNetUser.UserName; Challan.StudentClass = student.AspNetClass.ClassName; Challan.SchoolName = "IPC Aziz Avenue Campus"; Challan.BranchName = "Canal Branch"; Challan.ChallanCopy = new List <string>(); Challan.ChallanCopy.Add("Parent Copy"); Challan.ChallanCopy.Add("Bank Copy"); Challan.ChallanCopy.Add("School Copy"); if (Nextmonth == "") { Challan.FeeMonth = Student_FeeMonth.Months; } else { Challan.FeeMonth = Nextmonth; } var duedate = Student_FeeMonth.DueDate.ToString().Split(' '); Challan.DueDate = duedate[0]; var validdate = Student_FeeMonth.ValildityDate.ToString().Split(' '); Challan.ValidDate = validdate[0]; Challan.PayableFee = Student_FeeMonth.FeePayable - Convert.ToDouble(Student_discount); Challan.Arrears = Arrear; var totalpayable = Arrear + Convert.ToDouble(Student_Penalty) + Student_FeeMonth.FeePayable; Challan.TripCharges = trip; Challan.TotalAmount = totalpayable + trip; /////////////Challan No///////////// var challan = db.StudentChallanForms.Where(x => x.StudentId == student.Id && x.StudentFeeMonthId == Student_FeeMonth.Id).FirstOrDefault(); if (challan == null) { try { No = (int)db.StudentChallanForms.Select(x => x.ChallanNo).Max(); No++; StudentChallanForm stdchallan = new StudentChallanForm(); stdchallan.StudentId = student.Id; stdchallan.ChallanNo = No; stdchallan.StudentFeeMonthId = Student_FeeMonth.Id; stdchallan.Status = "Created"; db.StudentChallanForms.Add(stdchallan); db.SaveChanges(); ////////////// Accounting System/////////////// Ledger ledger_Assets = db.Ledgers.Where(x => x.Name == "Student Receivables").FirstOrDefault(); ledger_Assets.CurrentBalance += Convert.ToDecimal(Challan.TotalAmount); db.SaveChanges(); Ledger ledger_Income = db.Ledgers.Where(x => x.Name == "Student Fee").FirstOrDefault(); ledger_Income.CurrentBalance += Convert.ToDecimal(Challan.TotalAmount); db.SaveChanges(); ///////////////Send Text Message////////////////// //AspNetParent_Child parentChild = db.AspNetParent_Child.Where(x => x.ChildID == student.AspNetUser.Id).FirstOrDefault(); //var number = db.AspNetUsers.Where(x => x.Id == parentChild.ParentID).Select(x => x.PhoneNumber).FirstOrDefault(); //var message = "Fee Challan of " + student.AspNetUser.Name + "is generated. Its due date is :" + Challan.DueDate + "and validity date:" + Challan.ValidDate; //var url = "http://www.outreach.pk/api/sendsms.php/sendsms/url"; //String result = ""; //var newnum = ""; //if (number != null) //{ // var num = number.Substring(1); // newnum = "92" + num; //} //String messageer = HttpUtility.UrlEncode(message); //String strPost = "id=ipcngsch&pass=ipc_ngs123&msg=" + messageer + "&to=" + newnum + "&mask=IPC-NGS&type=xml&lang=English"; //StreamWriter myWriter = null; //HttpWebRequest objRequest = (HttpWebRequest)WebRequest.Create(url); //objRequest.Method = "POST"; //objRequest.ContentLength = Encoding.UTF8.GetByteCount(strPost); //objRequest.ContentType = "application/x-www-form-urlencoded"; //try //{ // myWriter = new StreamWriter(objRequest.GetRequestStream()); // myWriter.Write(strPost); //} //catch (Exception e) //{ //} //finally //{ // myWriter.Close(); //} //HttpWebResponse objResponse = (HttpWebResponse)objRequest.GetResponse(); //using (StreamReader sr = new StreamReader(objResponse.GetResponseStream())) //{ // result = sr.ReadToEnd(); // // Close and clean up the StreamReader // sr.Close(); //} //var messge = result; //////////////end text message/////////// } catch { No = 5050100; StudentChallanForm stdchallan = new StudentChallanForm(); stdchallan.StudentId = student.Id; stdchallan.ChallanNo = No; stdchallan.StudentFeeMonthId = Student_FeeMonth.Id; stdchallan.Status = "Created"; db.StudentChallanForms.Add(stdchallan); db.SaveChanges(); /////////// Accounting System/////////// Ledger ledger_Assets = db.Ledgers.Where(x => x.Name == "Student Receivables").FirstOrDefault(); ledger_Assets.CurrentBalance += Convert.ToDecimal(Challan.TotalAmount); db.SaveChanges(); Ledger ledger_Income = db.Ledgers.Where(x => x.Name == "Student Fee").FirstOrDefault(); ledger_Income.CurrentBalance += Convert.ToDecimal(Challan.TotalAmount); db.SaveChanges(); ////////////////End/////////////// } } else { No = challan.ChallanNo; } Challan.ChallanID = No; ChallanList.Add(Challan); } return(Json(ChallanList, JsonRequestBehavior.AllowGet)); } catch { var Error = "Error"; return(Json(Error, JsonRequestBehavior.AllowGet)); } }