public IEnumerable <StateMaster> getStates()
{
using (CISERPEntities db = new CISERPEntities())
{
return(db.StateMasters.ToList());
}
}
public IEnumerable <ClassMaster> GetClasses()
{
using (CISERPEntities db = new CISERPEntities())
{
return(db.ClassMasters.ToList());
}
}
public IEnumerable <BoardMaster> GetBoards()
{
using (CISERPEntities dn = new CISERPEntities())
{
return(dn.BoardMasters.ToList());
}
}
public IEnumerable <StateMaster> getStates(int id)
{
using (CISERPEntities db = new CISERPEntities())
{
return(db.StateMasters.Where(a => a.CountryId == id).ToList());
}
}
public IEnumerable <CountryMaster> GetCountries()
{
using (CISERPEntities db = new CISERPEntities())
{
return(db.CountryMasters.ToList());
}
}
public IEnumerable <CityMaster> getCitiesByStateId(int id)
{
using (CISERPEntities db = new CISERPEntities())
{
return(db.CityMasters.Where(a => a.StateId == id).ToList());
}
}
//methods
public void SaveNewStudent(StudentGenaralDetailsCustomModel newData)
{
using (CISERPEntities db = new CISERPEntities())
{
StudentGenaralDetail newStudent = new StudentGenaralDetail();
newStudent.FirstName = newData.FirstName;
newStudent.LastName = newData.LastName;
newStudent.Gender = newData.Gender;
newStudent.DOB = newData.DateOfBirth;
newStudent.BloodGroup = newData.BloodGroup;
newStudent.Caste = newData.Cast;
newStudent.Category = newData.Category;
newStudent.Email = newData.Email;
newStudent.MiddleName = newData.MiddleName;
newStudent.MobileNumber = newData.MobileNumber;
newStudent.Nationality = newData.Nationality;
newStudent.Religion = newData.Religion;
newStudent.StLocalAddress = newData.StLocalAddress;
newStudent.StLocalCityId = newData.StLocalCityId;
newStudent.StLocalStateId = newData.StLocalStateId;
newStudent.StLocalZip = newData.StLocalZip;
newStudent.StPerAddress = newData.StPerAddress;
newStudent.StPerCityId = newData.StPerCityId;
newStudent.StPerStateId = newData.StPerStateId;
newStudent.StPerZip = newData.StPerZip;
db.StudentGenaralDetails.Add(newStudent);
db.SaveChanges();
}
}
//methods
public void AddFamilyDetails(StudentFamilyDetailsViewModel newData)
{
StudentFamilyDetail dbInstance = new StudentFamilyDetail();
using (CISERPEntities db = new CISERPEntities())
{
dbInstance.FatherName = newData.FatherName;
dbInstance.FatherContactNo = newData.FatherContactNo;
dbInstance.FatherDesignation = newData.FatherDesignation;
dbInstance.FatherEmail = newData.FatherEmail;
dbInstance.FatherIncomeMonthly = newData.FatherIncomeMonthly;
dbInstance.FatherOccupation = newData.FatherOccupation;
dbInstance.FatherOfficeAddress = newData.FatherOfficeAddress;
dbInstance.FatherQualification = newData.FatherQualification;
dbInstance.MotherContactNo = newData.MotherContactNo;
dbInstance.MotherDesignation = newData.MotherDesignation;
dbInstance.MotherIncomeMonthly = newData.MotherIncomeMonthly;
dbInstance.MotherName = newData.MotherName;
dbInstance.MotherOccupation = newData.MotherOccupation;
dbInstance.MotherOfficeAddress = newData.MotherOfficeAddress;
dbInstance.MotherQualification = newData.MotherQualification;
dbInstance.FamilyEmail = newData.FamilEmail;
dbInstance.FamilyGuardianName = newData.FamilyGuardianName;
dbInstance.FamilyIncomeMonthly = newData.FamilyIncomeMonthly;
dbInstance.FamilyRelationship = newData.FamilyRelaltionship;
dbInstance.FatherContactNo = newData.FatherContactNo;
db.StudentFamilyDetails.Add(dbInstance);
db.SaveChanges();
}
}
public void SaveData()
{
using (CISERPEntities db = new CISERPEntities())
{
StudentPreviousSchool newData = new StudentPreviousSchool();
newData.Board = this.Board;
newData.CityId = this.CityId;
newData.Class = this.Class;
newData.CountryId = this.CountryId;
newData.FromDate = this.FromDate;
newData.Marks = this.Marks;
newData.Medium = this.Medium;
newData.Percentage = this.Percentage;
newData.Schooladdress = this.SchooolAddress;
newData.SchoolName = this.SchoolName;
newData.ToDate = this.ToDate;
newData.StateId = this.StateId;
db.StudentPreviousSchools.Add(newData);
db.SaveChanges();
}
}
