public ActionResult EditFeeHeading(NewFeeHeading objNewFeeHeading)
{
using (wisdomDBEntities db = new wisdomDBEntities())
{
ClassController _class = new ClassController();
NewFeeHeading Existing = db.NewFeeHeadings.Find(objNewFeeHeading.FID);
Existing.January = objNewFeeHeading.January;
Existing.February = objNewFeeHeading.February;
Existing.March = objNewFeeHeading.March;
Existing.April = objNewFeeHeading.April;
Existing.May = objNewFeeHeading.May;
Existing.June = objNewFeeHeading.June;
Existing.July = objNewFeeHeading.July;
Existing.August = objNewFeeHeading.August;
Existing.September = objNewFeeHeading.September;
Existing.October = objNewFeeHeading.October;
Existing.November = objNewFeeHeading.November;
Existing.December = objNewFeeHeading.December;
Existing.Class = Convert.ToString(_class.GetClassID(objNewFeeHeading.Class));
Existing.Heading = objNewFeeHeading.Heading;
Existing.IsMonth = objNewFeeHeading.IsMonth;
db.SaveChanges();
return(RedirectToAction("FeeHeadings"));
}
}
public FeesData(string csName)
{
ConnectionStringName = csName;
SchoolDB = new wisdomDBEntities(csName);
_class = new ClassData(csName);
SchoolSession = PropertiesConfiguration.ActiveSession;
}
public ActionResult AddClass()
{
using (wisdomDBEntities db = new wisdomDBEntities())
{
return(View("AddClass"));
}
}
public ActionResult EditFeeDetail(StudentFeeDetail objClass)
{
using (wisdomDBEntities db = new wisdomDBEntities())
{
ClassController _class = new ClassController();
objClass.Class = _class.GetClassID(objClass.Class).ToString();
StudentFeeDetail Existing = db.StudentFeeDetails.Find(objClass.Id);
Existing.Name = objClass.Name;
Existing.Class = objClass.Class;
Existing.AdmissionNo = objClass.AdmissionNo;
Existing.ReciptNo = objClass.ReciptNo;
Existing.Months = objClass.Months;
Existing.PaidAmount = objClass.PaidAmount;
Existing.PreviousDue = objClass.PreviousDue;
Existing.TotalAmount = objClass.TotalAmount;
Existing.GrandTotal = objClass.GrandTotal;
Existing.Balance = objClass.Balance;
Existing.Concession = objClass.Concession;
Existing.Fine = objClass.Fine;
Existing.OldBalanced = objClass.OldBalanced;
Existing.TransportFee = objClass.TransportFee;
Existing.BalancedShow = objClass.BalancedShow;
db.SaveChanges();
return(RedirectToAction("StudentFeeDetailList"));
}
}
public AttendanceData(string csName)
{
this.unitOfWork = new UnitOfWork(csName);
SchoolDB = new wisdomDBEntities(csName);
_class = new ClassData(csName);
SchoolSession = PropertiesConfiguration.ActiveSession;
}
//EditFeeHeading
public ActionResult AddFeeHeading()
{
using (wisdomDBEntities db = new wisdomDBEntities())
{
return(View("AddFeeHEading"));
}
}
public ActionResult EditSession(Session objSession)
{
using (wisdomDBEntities db = new wisdomDBEntities())
{
Session Existing = db.Sessions.Find(objSession.Id);
Existing.IsActive = objSession.IsActive;
db.SaveChanges();
return(View("Index"));
}
}
public ActionResult DeleteSchool(int id)
{
using (wisdomDBEntities db = new wisdomDBEntities())
{
School objSchool = db.Schools.Find(id);
db.Schools.Remove(objSchool);
db.SaveChanges();
return(RedirectToAction("School"));
}
}
public ActionResult EditSchool(int id)
{
using (wisdomDBEntities db = new wisdomDBEntities())
{
School SeletedSchool = new School();
SeletedSchool = db.Schools.Find(id);
return(View("EditSchool", SeletedSchool));
}
}
//DeleteFeeHeading
public ActionResult FeeHeadingDelete(int id)
{
using (wisdomDBEntities db = new wisdomDBEntities())
{
NewFeeHeading objDelete = db.NewFeeHeadings.Find(id);
db.NewFeeHeadings.Remove(objDelete);
db.SaveChanges();
return(RedirectToAction("FeeHeadings"));
}
}
//Class
public ActionResult EditClass(int id)
{
using (wisdomDBEntities db = new wisdomDBEntities())
{
Class SeletedClass = new Class();
SeletedClass = db.Classes.Find(id);
return(View("EditClass", SeletedClass));
}
}
public ActionResult DeleteClass(int id)
{
using (wisdomDBEntities db = new wisdomDBEntities())
{
Class objDelete = db.Classes.Find(id);
db.Classes.Remove(objDelete);
db.SaveChanges();
return(RedirectToAction("ClassList"));
}
}
//Class
public ActionResult EditFeeDetail(int id)
{
using (wisdomDBEntities db = new wisdomDBEntities())
{
ClassController _class = new ClassController();
StudentFeeDetail SeletedStudentFeeDetail = new StudentFeeDetail();
SeletedStudentFeeDetail = db.StudentFeeDetails.Find(id);
SeletedStudentFeeDetail.Class = _class.GetClassName(SeletedStudentFeeDetail.Class);
return(View("EditFeeDetail", SeletedStudentFeeDetail));
}
}
public ActionResult EditClass(Class objClass)
{
using (wisdomDBEntities db = new wisdomDBEntities())
{
Class Existing = db.Classes.Find(objClass.CID);
Existing.Class1 = objClass.Class1;
Existing.Inc_Class = objClass.Inc_Class;
db.SaveChanges();
return(RedirectToAction("ClassList"));
}
}
//EditFeeHeading
public ActionResult EditFeeHeading(int id)
{
using (wisdomDBEntities db = new wisdomDBEntities())
{
NewFeeHeading SeletedHeading = new NewFeeHeading();
ClassController _class = new ClassController();
SeletedHeading = db.NewFeeHeadings.Find(id);
SeletedHeading.Class = _class.GetClassName(SeletedHeading.Class);
return(View("EditFeeHEading", SeletedHeading));
}
}
public ActionResult DeleteFeeDetail(int id)
{
using (wisdomDBEntities db = new wisdomDBEntities())
{
StudentFeeDetail objDelete = db.StudentFeeDetails.Find(id);
if (objDelete != null)
{
db.StudentFeeDetails.Remove(objDelete);
db.SaveChanges();
}
return(RedirectToAction("StudentFeeDetailList"));
}
}
public ActionResult EditSchool(School objSchool)
{
using (wisdomDBEntities db = new wisdomDBEntities())
{
School Existing = db.Schools.Find(objSchool.ID);
Existing.SchoolName = objSchool.SchoolName;
Existing.schooladdress = objSchool.schooladdress;
Existing.Phone = objSchool.Phone;
Existing.Date = DateTime.Now;
Existing.logo = objSchool.logo;
db.SaveChanges();
return(RedirectToAction("School"));
}
}
static ApplicationConfigurations()
{
SchoolDB = new wisdomDBEntities();
FillProperties();
}
public UnitOfWork(string csName)
{
_context = new wisdomDBEntities(csName);
}
public AttendanceController()
{
SchoolDB = new wisdomDBEntities();
SchoolSession = ApplicationConfigurations.ActiveSession;
}
public UnitOfWork()
{
_context = new wisdomDBEntities();
}
public DashboardController()
{
SchoolDB = new wisdomDBEntities();
SchoolSession = ApplicationConfigurations.ActiveSession;
}
public DashboardData(string csName)
{
SchoolDB = new wisdomDBEntities(csName);
_class = new ClassData(csName);
SchoolSession = PropertiesConfiguration.ActiveSession;
}
