public AspNetContext(HttpContext httpContext)
{
// Assign properties
_request = new AspNetRequest(httpContext.Request);
_session = new AspNetSession(httpContext);
_response = new AspNetResponse(httpContext.Response);
}
public ActionResult DeleteConfirmed(int id)
{
AspNetSession aspNetSession = db.AspNetSessions.Find(id);
db.AspNetSessions.Remove(aspNetSession);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public AspNetContext(HttpContext httpContext, string resourcePath = null)
{
// Assign properties
_request = new AspNetRequest(httpContext.Request);
_request.ResourcePath = new Uri(resourcePath, UriKind.RelativeOrAbsolute);
_session = new AspNetSession(httpContext);
_response = new AspNetResponse(httpContext.Response);
}
public ActionResult Edit([Bind(Include = "Id,SessionName,SessionStartDate,SessionEndDate,Status")] AspNetSession aspNetSession)
{
if (ModelState.IsValid)
{
db.Entry(aspNetSession).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(aspNetSession));
}
public ActionResult Create([Bind(Include = "Id,SessionName,SessionStartDate,SessionEndDate,Status")] AspNetSession aspNetSession)
{
if (ModelState.IsValid)
{
db.AspNetSessions.Add(aspNetSession);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(aspNetSession));
}
public ActionResult Edit([Bind(Include = "Id,SessionName,SessionStartDate,SessionEndDate,Status")] AspNetSession aspNetSession)
{
if (ModelState.IsValid)
{
if (db.AspNetSessions.Where(x => x.Status == "Active").Count() == 0 || aspNetSession.Status == "InActive")
{
db.Entry(aspNetSession).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
}
return(View(aspNetSession));
}
// GET: AspNetSession/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
AspNetSession aspNetSession = db.AspNetSessions.Find(id);
if (aspNetSession == null)
{
return(HttpNotFound());
}
return(View(aspNetSession));
}
public ActionResult Create([Bind(Include = "Id,SessionName,SessionStartDate,SessionEndDate,Status")] AspNetSession aspNetSession)
{
var TransactionObj = db.Database.BeginTransaction();
if (db.AspNetSessions.Where(x => x.Status == "Active").Count() == 0 || aspNetSession.Status == "InActive")
{
if (ModelState.IsValid)
{
aspNetSession.SessionEndDate = Convert.ToDateTime(Request.Form["SessionEndDate"]);
aspNetSession.SessionStartDate = Convert.ToDateTime(Request.Form["SessionStartDate"]);
db.AspNetSessions.Add(aspNetSession);
db.SaveChanges();
}
TransactionObj.Commit();
////////////////////////////////////////////////////////Term Add/////////////////////////////////////////////////////////////////
int length = 3;
for (int i = 0; i < length; i++)
{
AspNetTerm aspnetTerm = new AspNetTerm();
aspnetTerm.SessionID = aspNetSession.Id;
aspnetTerm.TermName = "Term " + (i + 1);
aspnetTerm.TermStartDate = DateTime.Now;
aspnetTerm.TermEndDate = DateTime.Now;
aspnetTerm.Status = "InActive";
db.AspNetTerms.Add(aspnetTerm);
db.SaveChanges();
}
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
var UserNameLog = User.Identity.Name;
AspNetUser a = db.AspNetUsers.First(x => x.UserName == UserNameLog);
string UserIDLog = a.Id;
var logMessage = "New Session Added, SessionName: " + aspNetSession.SessionName + ", SessionStartDate: " + aspNetSession.SessionStartDate + ", SessionEndDate: " + aspNetSession.SessionEndDate + ", Status: " + aspNetSession.Status;
var LogControllerObj = new AspNetLogsController();
LogControllerObj.CreateLogSave(logMessage, UserIDLog);
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
return(RedirectToAction("Indexs"));
}
else
{
return(RedirectToAction("Index"));
}
}
public ActionResult Edit([Bind(Include = "Id,SessionName,SessionStartDate,SessionEndDate,Status,Total_Fee")] AspNetSession aspNetSession)
{
if (ModelState.IsValid)
{
db.Entry(aspNetSession).State = EntityState.Modified;
db.SaveChanges();
//Change Class Name of Session Name
var ClassToModify = db.AspNetClasses.Where(x => x.SessionID == aspNetSession.Id).FirstOrDefault();
ClassToModify.ClassName = aspNetSession.SessionName;
ClassToModify.Class = aspNetSession.SessionName;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(aspNetSession));
}
public ActionResult TimeTableFromFile()
{
var dbTransaction = db.Database.BeginTransaction();
HttpPostedFileBase file = Request.Files["subjects"];
if ((file != null) && (file.ContentLength > 0) && !string.IsNullOrEmpty(file.FileName))
{
string fileName = file.FileName;
string fileContentType = file.ContentType;
byte[] fileBytes = new byte[file.ContentLength];
var data = file.InputStream.Read(fileBytes, 0, Convert.ToInt32(file.ContentLength));
}
var studentList = new List <RegisterViewModel>();
using (var package = new ExcelPackage(file.InputStream))
{
var currentSheet = package.Workbook.Worksheets;
var workSheet = currentSheet.First();
var noOfCol = workSheet.Dimension.End.Column;
var noOfRow = workSheet.Dimension.End.Row;
string ErrorMsg = null;
int rowIterator;
for (rowIterator = 2; rowIterator <= noOfRow; rowIterator++)
{
var TimeTable = new AspNetTimeTable();
var SessionName = workSheet.Cells[rowIterator, 6].Value.ToString();
int GetSessionID;
int GetClassID;
AspNetSession Session = db.AspNetSessions.Where(x => x.SessionName == SessionName).FirstOrDefault();
if (Session == null)
{
ErrorMsg = "Error in Row " + Convert.ToString(rowIterator - 1) + " Session Name is not valid or empty";
TempData["ErrorMsg"] = ErrorMsg;
return(RedirectToAction("Create", "AspNetTimeTable"));
}
else
{
GetSessionID = Session.Id;
GetClassID = db.AspNetClasses.Where(x => x.SessionID == GetSessionID).Select(x => x.Id).FirstOrDefault();
}
var CourseType = workSheet.Cells[rowIterator, 5].Value.ToString();
var CourseTypeLower = CourseType.ToLower();
if (CourseTypeLower == "css" || CourseTypeLower == "pms")
{
//valid course Type css or pms
}
else
{
ErrorMsg = "Error in Row " + Convert.ToString(rowIterator - 1) + "Course Type is not valid or empty";
TempData["ErrorMsg"] = ErrorMsg;
return(RedirectToAction("Create", "AspNetTimeTable"));
}
var RoomName = workSheet.Cells[rowIterator, 1].Value.ToString();
//RoomID;
int RoomID = db.AspNetRooms.Where(x => x.Name == RoomName).FirstOrDefault().Id;
AspNetRoom room = new AspNetRoom();
room = db.AspNetRooms.Where(x => x.Name == RoomName).FirstOrDefault();
if (room == null)
{
ErrorMsg = "Error in Row " + Convert.ToString(rowIterator - 1) + "Room Name is not valid or empty";
TempData["ErrorMsg"] = ErrorMsg;
return(RedirectToAction("Create", "AspNetTimeTable"));
}
else
{
RoomID = room.Id;
}
var SlotName = workSheet.Cells[rowIterator, 2].Value.ToString();
//var SlotID = db.AspNetTimeslots.Where(x => x.Name == SlotName).FirstOrDefault().Id;
int SlotID = db.AspNetTimeslots.Where(x => x.Name == SlotName).FirstOrDefault().Id;
AspNetTimeslot slot = new AspNetTimeslot();
slot = db.AspNetTimeslots.Where(x => x.Name == SlotName).FirstOrDefault();
if (slot == null)
{
ErrorMsg = "Error in Row " + Convert.ToString(rowIterator - 1) + " Slot Name is not valid or empty";
TempData["ErrorMsg"] = ErrorMsg;
return(RedirectToAction("Create", "AspNetTimeTable"));
}
else
{
SlotID = slot.Id;
}
string SubName = workSheet.Cells[rowIterator, 3].Value.ToString();
int SubjectID;
AspNetSubject subject = new AspNetSubject();
subject = db.AspNetSubjects.Where(x => x.SubjectName == SubName && x.ClassID == GetClassID && x.CourseType == CourseType).FirstOrDefault();
if (subject == null)
{
ErrorMsg = "Error in Row " + Convert.ToString(rowIterator - 1) + " Subject Name is not valid or empty";
TempData["ErrorMsg"] = ErrorMsg;
return(RedirectToAction("Create", "AspNetTimeTable"));
}
else
{
SubjectID = subject.Id;
}
//var UserName = workSheet.Cells[rowIterator, 4].Value.ToString();
//string TeacherID;
//AspNetUser teacher = new AspNetUser();
//teacher = db.AspNetUsers.Where(x => x.UserName == UserName).FirstOrDefault();
//if (teacher == null)
//{
// ErrorMsg = "Error in Row " + Convert.ToString(rowIterator - 1) + " Teacher Name is not valid or empty";
// TempData["ErrorMsg"] = ErrorMsg;
// return RedirectToAction("Create", "AspNetTimeTable");
//}
//else
//{
// TeacherID = teacher.Id;
//}
DateTime Day = Convert.ToDateTime(workSheet.Cells[rowIterator, 4].Value.ToString());
var Description = (workSheet.Cells[rowIterator, 7].Value.ToString());
//var Date = workSheet.Cells[rowIterator, 5].Value.ToString();
//DateTime Day = DateTime.ParseExact(Date, "dd/MM/yyyy", null);
TimeTable.RoomID = RoomID;
TimeTable.SlotID = SlotID;
TimeTable.SubjectID = SubjectID;
TimeTable.Description = Description;
//TimeTable.Teacher_ID = TeacherID;
TimeTable.Day = Day.ToString();
TimeTable.IsPopulated = false;
// TimeTable.SessionID = GetSessionID;
db.AspNetTimeTables.Add(TimeTable);
db.SaveChanges();
}
}
dbTransaction.Commit();
// return RedirectToAction("Index", "AspNetTimeTable");
//catch (Exception e)
//{
// dbTransaction.Dispose();
//}
return(RedirectToAction("CreateTimetable"));
}
public ActionResult Create([Bind(Include = "Id,SessionName,SessionStartDate,SessionEndDate,Status,Total_Fee")] AspNetSession aspNetSession)
{
var TransactionObj = db.Database.BeginTransaction();
if (ModelState.IsValid)
{
aspNetSession.SessionEndDate = Convert.ToDateTime(Request.Form["SessionEndDate"]);
aspNetSession.SessionStartDate = Convert.ToDateTime(Request.Form["SessionStartDate"]);
aspNetSession.Total_Fee = aspNetSession.Total_Fee;
db.AspNetSessions.Add(aspNetSession);
db.SaveChanges();
}
TransactionObj.Commit();
////////////////////////////////////////////////////////Term Add/////////////////////////////////////////////////////////////////
//int length = 3;
//for (int i = 0; i < length; i++)
//{
// AspNetTerm aspnetTerm = new AspNetTerm();
// aspnetTerm.SessionID = aspNetSession.Id;
// aspnetTerm.TermName = "Term " + (i + 1);
// aspnetTerm.TermStartDate = DateTime.Now;
// aspnetTerm.TermEndDate = DateTime.Now;
// aspnetTerm.Status = "InActive";
// db.AspNetTerms.Add(aspnetTerm);
// db.SaveChanges();
//}
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
var UserNameLog = User.Identity.Name;
AspNetUser a = db.AspNetUsers.First(x => x.UserName == UserNameLog);
string UserIDLog = a.Id;
var logMessage = "New Session Added, SessionName: " + aspNetSession.SessionName + ", SessionStartDate: " + aspNetSession.SessionStartDate + ", SessionEndDate: " + aspNetSession.SessionEndDate + ", Status: " + aspNetSession.Status;
var LogControllerObj = new AspNetLogsController();
LogControllerObj.CreateLogSave(logMessage, UserIDLog);
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
AspNetClass Class = new AspNetClass();
var CurrentSession = db.AspNetSessions.OrderByDescending(x => x.Id).FirstOrDefault();
Class.ClassName = CurrentSession.SessionName;
Class.Class = CurrentSession.SessionName;
Class.SessionID = CurrentSession.Id;
db.AspNetClasses.Add(Class);
db.SaveChanges();
//Create Subjects to New Session
var AllSubjectsofTestSession = db.AspNetSubjects.Where(x => x.ClassID == 1).ToList();
List <subjects_mapping> list = new List <subjects_mapping>();
foreach (AspNetSubject Subject in AllSubjectsofTestSession)
{
subjects_mapping sub = new subjects_mapping();
sub.oldId = Subject.Id;
sub.name = Subject.SubjectName;
AspNetSubject NewSubjectForSession = new AspNetSubject();
NewSubjectForSession = Subject;
NewSubjectForSession.ClassID = Class.Id;
NewSubjectForSession.TeacherID = null;
db.AspNetSubjects.Add(NewSubjectForSession);
db.SaveChanges();
sub.newId = NewSubjectForSession.Id;
list.Add(sub);
}
var AllTeacherSubjects = db.AspNetTeacherSubjects.Where(x => x.AspNetSubject.ClassID == 1).ToList();
foreach (var item in AllTeacherSubjects)
{
foreach (var item1 in list)
{
if (item1.oldId == item.SubjectID)
{
AspNetTeacherSubject TS = new AspNetTeacherSubject();
TS.SubjectID = item1.newId;
TS.TeacherID = item.TeacherID;
db.AspNetTeacherSubjects.Add(TS);
break;
}
}
}
db.SaveChanges();
var UserIDs = (from teacher in db.AspNetUsers.Where(x => x.Status != "False")
join t2 in db.AspNetUsers_Session
on teacher.Id equals t2.UserID
join t3 in db.AspNetEmployees
on teacher.Id equals t3.UserId
where teacher.AspNetRoles.Select(y => y.Name).Contains("Teacher") && t2.AspNetSession.AspNetClasses.Any(x => x.Id == 1) /*&& db.AspNetChapters.Any(x=>x.Id==id)*/
select new
{
TeacherId = teacher.Id,
EmployeeId = t3.Id,
}).ToList();
foreach (var Id in UserIDs)
{
string IdString = Id.TeacherId.ToString();
AspNetUsers_Session UserSession = new AspNetUsers_Session();
UserSession.SessionID = aspNetSession.Id;
UserSession.UserID = IdString;
db.AspNetUsers_Session.Add(UserSession);
db.SaveChanges();
}
foreach (var Id in UserIDs)
{
Aspnet_Employee_Session EmployeeSession = new Aspnet_Employee_Session();
EmployeeSession.Emp_Id = Id.EmployeeId;
EmployeeSession.Session_Id = aspNetSession.Id;
db.Aspnet_Employee_Session.Add(EmployeeSession);
db.SaveChanges();
}
return(RedirectToAction("Indexs"));
}
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));
}
}
