public int Delete(AcademicYear entity)
{
int i = 0;
string[] addParams = { AcademicYear_Constant.ACADEMIC_YEAR_ID };
i = _AYRepository.ExecuteNonQuery(entity, addParams, AcademicYear_Constant.SPROC_ACADEMIC_YEAR_MST_DEL);
return i;
}
public int AddEdit(AcademicYear entity)
{
int i = 0;
User objUser = null;
if (eSchoolSession.IsInSession(SessionKeys.CurrentUser))
objUser = (User)eSchoolSession.GetDirectValue(SessionKeys.CurrentUser);
if (entity != null && string.IsNullOrEmpty(entity.SchoolID))
{
if (objUser != null && !string.IsNullOrEmpty(objUser.SchoolID))
entity.SchoolID = objUser.SchoolID;
}
if (string.IsNullOrEmpty(entity.AcademicYearID))
{
entity.AcademicYearID = Utility.GeneratorUniqueId(ID_PREFIX_CONSTANTS.ACADEMIC_YEAR_ID_PREFIX);
if (objUser != null && !string.IsNullOrEmpty(objUser.UserID))
{
entity.CreatedByID = objUser.UserID;
entity.ModifiedByID = objUser.UserID;
}
else
{
entity.CreatedByID = "1";
entity.ModifiedByID = "1";
}
}
else
{
if (objUser != null && !string.IsNullOrEmpty(objUser.UserID))
entity.ModifiedByID = objUser.UserID;
else
entity.ModifiedByID = "1";
}
string[] addParams = { AcademicYear_Constant.ACADEMIC_YEAR_ID,
AcademicYear_Constant.SCHOOL_ID,
AcademicYear_Constant.ACADEMIC_NAME,
AcademicYear_Constant.IS_ACTIVE,
AcademicYear_Constant.CREATED_BY_ID,
AcademicYear_Constant.MODIFIED_BY_ID
};
i = _AYRepository.ExecuteNonQuery(entity, addParams, AcademicYear_Constant.SPROC_ACADEMIC_YEAR_MST_UPS);
return i;
}
public IEnumerable<AcademicYear> GetAll(AcademicYear entity)
{
User objUser = null;
if (eSchoolSession.IsInSession(SessionKeys.CurrentUser))
objUser = (User)eSchoolSession.GetDirectValue(SessionKeys.CurrentUser);
if (objUser != null && !string.IsNullOrEmpty(objUser.SchoolID))
entity.SchoolID = objUser.SchoolID;
string[] addParams = { Constants.PAGEINDEX, Constants.PAGESIZE, Constants.SORTEXP, AcademicYear_Constant.SCHOOL_ID};
return _AYRepository.GetAll(entity, addParams, AcademicYear_Constant.SPROC_ACADEMIC_YEAR_MST_LSTALL);
}
public AcademicYear Get(AcademicYear entity)
{
string[] addParams = { AcademicYear_Constant.ACADEMIC_YEAR_ID };
return _AYRepository.Get(entity, addParams, AcademicYear_Constant.SPROC_ACADEMIC_YEAR_MST_SEL);
}
public object GetScalar(AcademicYear entity)
{
throw new NotImplementedException();
}
private SelectList GetAllAY()
{
AcademicYear obj = new AcademicYear();
SelectList retList = null;
List<AcademicYear> ObjList = _AcademicYearService.GetAllForLookup(obj).ToList();
if (retList == null)
retList = new SelectList(ObjList, AcademicYear_Constant.ACADEMIC_YEAR_ID, AcademicYear_Constant.ACADEMIC_NAME);
return retList;
}
public bool UploadFromExcelFile(Student entity)
{
OleDbConnection cnn = null;
try
{
if (!string.IsNullOrEmpty(entity.StudentExcelFilePath))
{
cnn = new OleDbConnection(@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + entity.StudentExcelFilePath + "; Extended Properties=Excel 12.0;");
OleDbCommand oconn = new OleDbCommand("select * from [Students$]", cnn);
cnn.Open();
OleDbDataAdapter adp = new OleDbDataAdapter(oconn);
DataTable dt = new DataTable();
adp.Fill(dt);
cnn.Close();
if (dt != null && dt.Rows.Count > 0)
{
DataColumnCollection columns = dt.Columns;
Student objStudent = null;
StudentsParent objStudentsParent = null;
StudentsMedical objStudentsMedical = null;
StudentsTransport objStudentsTransport = null;
int i = 0;
foreach (DataRow row in dt.Rows)
{
objStudent = new Student();
objStudentsParent = new StudentsParent();
objStudentsMedical = new StudentsMedical();
objStudentsTransport = new StudentsTransport();
#region Students Information
if (columns.Contains("Form No") && !string.IsNullOrEmpty(Convert.ToString(row["Form No"])))
objStudent.FormNo = Convert.ToString(row["Form No"]).Trim();
if (columns.Contains("Temp Student ID") && !string.IsNullOrEmpty(Convert.ToString(row["Temp Student ID"])))
objStudent.TempStudentID = Convert.ToString(row["Temp Student ID"]).Trim();
if (columns.Contains("GR No") && !string.IsNullOrEmpty(Convert.ToString(row["GR No"])))
objStudent.GRNo = Convert.ToString(row["GR No"]).Trim();
if (columns.Contains("Admission Type") && !string.IsNullOrEmpty(Convert.ToString(row["Admission Type"])))
objStudent.AdmissionType = Convert.ToString(row["Admission Type"]).Trim();
if (columns.Contains("Academic Year") && !string.IsNullOrEmpty(Convert.ToString(row["Academic Year"])))
{
AcademicYear obj = new AcademicYear();
obj.AcademicName = Convert.ToString(row["Academic Year"]);
obj = _AcademicYearService.GetByName(obj);
if (obj != null && !string.IsNullOrEmpty(obj.AcademicYearID))
objStudent.CurrentAcademicYearID = obj.AcademicYearID;
}
if (columns.Contains("Class") && !string.IsNullOrEmpty(Convert.ToString(row["Class"])))
{
Class obj = new Class();
obj.ClassName = Convert.ToString(row["Class"]);
obj = _ClassService.GetByName(obj);
if (obj != null && !string.IsNullOrEmpty(obj.ClassID))
objStudent.CurrentClassID = obj.ClassID;
}
if (columns.Contains("Section") && !string.IsNullOrEmpty(Convert.ToString(row["Section"])))
{
Section obj = new Section();
obj.SectionName = Convert.ToString(row["Section"]);
obj = _SectionService.GetByName(obj);
if (obj != null && !string.IsNullOrEmpty(obj.SectionID))
objStudent.CurrentSectionID = obj.SectionID;
}
if (columns.Contains("Admission Date") && !string.IsNullOrEmpty(Convert.ToString(row["Admission Date"])))
objStudent.AdmissionDate = Convert.ToDateTime(row["Admission Date"]);
if (columns.Contains("First Name") && !string.IsNullOrEmpty(Convert.ToString(row["First Name"])))
objStudent.FirstName = Convert.ToString(row["First Name"]).Trim();
if (columns.Contains("Middle Name") && !string.IsNullOrEmpty(Convert.ToString(row["Middle Name"])))
objStudent.MiddleName = Convert.ToString(row["Middle Name"]).Trim();
if (columns.Contains("Last Name") && !string.IsNullOrEmpty(Convert.ToString(row["Last Name"])))
objStudent.LastName = Convert.ToString(row["Last Name"]).Trim();
if (columns.Contains("Gender") && !string.IsNullOrEmpty(Convert.ToString(row["Gender"])))
objStudent.Gender = Convert.ToString(row["Gender"]).Trim();
if (columns.Contains("DOB") && !string.IsNullOrEmpty(Convert.ToString(row["DOB"])))
objStudent.DOB = Convert.ToDateTime(row["DOB"]);
if (columns.Contains("Age As On") && !string.IsNullOrEmpty(Convert.ToString(row["Age As On"])))
objStudent.AgeAsOn = Convert.ToDateTime(row["Age As On"]);
if (columns.Contains("Place Of Birth Taluka") && !string.IsNullOrEmpty(Convert.ToString(row["Place Of Birth Taluka"])))
objStudent.PlaceOfBirthTaluka = Convert.ToString(row["Place Of Birth Taluka"]).Trim();
if (columns.Contains("Place Of Birth District") && !string.IsNullOrEmpty(Convert.ToString(row["Place Of Birth District"])))
objStudent.PlaceOfBirthDistrict = Convert.ToString(row["Place Of Birth District"]).Trim();
if (columns.Contains("Mother Tongue") && !string.IsNullOrEmpty(Convert.ToString(row["Mother Tongue"])))
objStudent.MotherTongue = Convert.ToString(row["Mother Tongue"]).Trim();
if (columns.Contains("Nationality") && !string.IsNullOrEmpty(Convert.ToString(row["Nationality"])))
objStudent.Nationality = Convert.ToString(row["Nationality"]).Trim();
if (columns.Contains("Permanant Address") && !string.IsNullOrEmpty(Convert.ToString(row["Permanant Address"])))
objStudent.PermanantAddress = Convert.ToString(row["Permanant Address"]).Trim();
if (columns.Contains("Local Address") && !string.IsNullOrEmpty(Convert.ToString(row["Local Address"])))
objStudent.LocalAddress = Convert.ToString(row["Local Address"]).Trim();
if (columns.Contains("Native State") && !string.IsNullOrEmpty(Convert.ToString(row["Native State"])))
objStudent.NativeState = Convert.ToString(row["Native State"]).Trim();
if (columns.Contains("Category") && !string.IsNullOrEmpty(Convert.ToString(row["Category"])))
objStudent.Category = Convert.ToString(row["Category"]).Trim();
if (columns.Contains("Religion") && !string.IsNullOrEmpty(Convert.ToString(row["Religion"])))
objStudent.Religion = Convert.ToString(row["Religion"]).Trim();
if (columns.Contains("Caste") && !string.IsNullOrEmpty(Convert.ToString(row["Caste"])))
objStudent.Caste = Convert.ToString(row["Caste"]).Trim();
if (columns.Contains("Sub Caste") && !string.IsNullOrEmpty(Convert.ToString(row["Sub Caste"])))
objStudent.SubCaste = Convert.ToString(row["Sub Caste"]).Trim();
if (columns.Contains("Last School Attended") && !string.IsNullOrEmpty(Convert.ToString(row["Last School Attended"])))
objStudent.LastSchoolAttended = Convert.ToString(row["Last School Attended"]).Trim();
if (columns.Contains("Phone No") && !string.IsNullOrEmpty(Convert.ToString(row["Phone No"])))
objStudent.PhoneNo = Convert.ToInt32(row["Phone No"]);
if (columns.Contains("Reason For Transfer") && !string.IsNullOrEmpty(Convert.ToString(row["Reason For Transfer"])))
objStudent.ReasonForTransfer = Convert.ToString(row["Reason For Transfer"]).Trim();
if (columns.Contains("Date Of Leaving School") && !string.IsNullOrEmpty(Convert.ToString(row["Date Of Leaving School"])))
objStudent.DateOfLeavingSchool = Convert.ToDateTime(row["Date Of Leaving School"]);
if (columns.Contains("Remark") && !string.IsNullOrEmpty(Convert.ToString(row["Remark"])))
objStudent.Remark = Convert.ToString(row["Remark"]).Trim();
if (columns.Contains("TC Date") && !string.IsNullOrEmpty(Convert.ToString(row["TC Date"])))
objStudent.TCDate = Convert.ToDateTime(row["TC Date"]);
if (columns.Contains("TC Number") && !string.IsNullOrEmpty(Convert.ToString(row["TC Number"])))
objStudent.TCNumber = Convert.ToString(row["TC Number"]).Trim();
i = AddEdit(objStudent);
#endregion
#region Parents Information
if (i > 0 && !string.IsNullOrEmpty(objStudent.StudentID))
{
objStudentsParent.StudentID = objStudent.StudentID;
if (columns.Contains("Fathers Name") && !string.IsNullOrEmpty(Convert.ToString(row["Fathers Name"])))
objStudentsParent.FathersName = Convert.ToString(row["Fathers Name"]).Trim();
if (columns.Contains("Mothers Name") && !string.IsNullOrEmpty(Convert.ToString(row["Mothers Name"])))
objStudentsParent.MothersName = Convert.ToString(row["Mothers Name"]).Trim();
if (columns.Contains("Ph No Resident") && !string.IsNullOrEmpty(Convert.ToString(row["Ph No Resident"])))
objStudentsParent.PhNoResident = Convert.ToInt32(row["Ph No Resident"]);
if (columns.Contains("Ph No Office") && !string.IsNullOrEmpty(Convert.ToString(row["Ph No Office"])))
objStudentsParent.PhNoOffice = Convert.ToInt32(row["Ph No Office"]);
if (columns.Contains("Mobile No") && !string.IsNullOrEmpty(Convert.ToString(row["Mobile No"])))
objStudentsParent.MobileNo = Convert.ToInt32(row["Mobile No"]);
if (columns.Contains("Email Address") && !string.IsNullOrEmpty(Convert.ToString(row["Email Address"])))
objStudentsParent.EmailAddress = Convert.ToString(row["Email Address"]).Trim();
if (columns.Contains("Qualification") && !string.IsNullOrEmpty(Convert.ToString(row["Qualification"])))
objStudentsParent.Qualification = Convert.ToString(row["Qualification"]).Trim();
if (columns.Contains("Fathers Occupation") && !string.IsNullOrEmpty(Convert.ToString(row["Fathers Occupation"])))
objStudentsParent.FathersOccupation = Convert.ToString(row["Fathers Occupation"]).Trim();
if (columns.Contains("Mothers Occupation") && !string.IsNullOrEmpty(Convert.ToString(row["Mothers Occupation"])))
objStudentsParent.MothersOccupation = Convert.ToString(row["Mothers Occupation"]).Trim();
if (columns.Contains("Fathers Annual Income") && !string.IsNullOrEmpty(Convert.ToString(row["Fathers Annual Income"])))
objStudentsParent.FathersAnnualIncome = Convert.ToString(row["Fathers Annual Income"]).Trim();
if (columns.Contains("Mothers Annual Income") && !string.IsNullOrEmpty(Convert.ToString(row["Mothers Annual Income"])))
objStudentsParent.MothersAnnualIncome = Convert.ToString(row["Mothers Annual Income"]).Trim();
if (columns.Contains("Total Annual Income") && !string.IsNullOrEmpty(Convert.ToString(row["Total Annual Income"])))
objStudentsParent.TotalAnnualIncome = Convert.ToString(row["Total Annual Income"]).Trim();
if (columns.Contains("Total Family Members") && !string.IsNullOrEmpty(Convert.ToString(row["Total Family Members"])))
objStudentsParent.TotalFamilyMembers = Convert.ToInt32(row["Total Family Members"]);
if (columns.Contains("Guardian") && !string.IsNullOrEmpty(Convert.ToString(row["Guardian"])))
objStudentsParent.Guardian = Convert.ToString(row["Guardian"]).Trim();
if (columns.Contains("Guardian Address") && !string.IsNullOrEmpty(Convert.ToString(row["Guardian Address"])))
objStudentsParent.GuardianAddress = Convert.ToString(row["Guardian Address"]).Trim();
if (columns.Contains("Guardian Mobile") && !string.IsNullOrEmpty(Convert.ToString(row["Guardian Mobile"])))
objStudentsParent.GuardianMobile = Convert.ToInt32(row["Guardian Mobile"]);
if (columns.Contains("Guardian Email") && !string.IsNullOrEmpty(Convert.ToString(row["Guardian Email"])))
objStudentsParent.GuardianEmail = Convert.ToString(row["Guardian Email"]).Trim();
if (columns.Contains("Guardian Relationship With Student") && !string.IsNullOrEmpty(Convert.ToString(row["Guardian Relationship With Student"])))
objStudentsParent.GuardianRelationshipWithStudent = Convert.ToString(row["Guardian Relationship With Student"]).Trim();
_IStudentsParentService.AddEdit(objStudentsParent);
}
#endregion
#region Medical Information
if (i > 0 && !string.IsNullOrEmpty(objStudent.StudentID))
{
objStudentsMedical.StudentID = objStudent.StudentID;
if (columns.Contains("Blood Group") && !string.IsNullOrEmpty(Convert.ToString(row["Blood Group"])))
objStudentsMedical.BloodGroup = Convert.ToString(row["Blood Group"]).Trim();
if (columns.Contains("Any Physical Handicap Or Disability") && !string.IsNullOrEmpty(Convert.ToString(row["Any Physical Handicap Or Disability"])))
{
if (Convert.ToString(row["Any Physical Handicap Or Disability"]).Trim() == "Yes")
objStudentsMedical.AnyPhysicalHandicapOrDisability = true;
else if (Convert.ToString(row["Any Physical Handicap Or Disability"]).Trim() == "No")
objStudentsMedical.AnyPhysicalHandicapOrDisability = false;
}
if (columns.Contains("Physical Handicap Or Disability Desc") && !string.IsNullOrEmpty(Convert.ToString(row["Physical Handicap Or Disability Desc"])))
objStudentsMedical.PhysicalHandicapOrDisabilityDesc = Convert.ToString(row["Physical Handicap Or Disability Desc"]).Trim();
if (columns.Contains("Any Other Health Problems") && !string.IsNullOrEmpty(Convert.ToString(row["Any Other Health Problems"])))
{
if (Convert.ToString(row["Any Other Health Problems"]).Trim() == "Yes")
objStudentsMedical.AnyOtherHealthProblems = true;
else if (Convert.ToString(row["Any Other Health Problems"]).Trim() == "No")
objStudentsMedical.AnyOtherHealthProblems = false;
}
if (columns.Contains("Other Health Problems Desc") && !string.IsNullOrEmpty(Convert.ToString(row["Other Health Problems Desc"])))
objStudentsMedical.OtherHealthProblemsDesc = Convert.ToString(row["Other Health Problems Desc"]).Trim();
if (columns.Contains("Allergies Or Chronic Ailments") && !string.IsNullOrEmpty(Convert.ToString(row["Allergies Or Chronic Ailments"])))
objStudentsMedical.AllergiesOrChronicAilments = Convert.ToString(row["Allergies Or Chronic Ailments"]).Trim();
_IStudentsMedicalService.AddEdit(objStudentsMedical);
}
#endregion
#region Transport Information
if (i > 0 && !string.IsNullOrEmpty(objStudent.StudentID))
{
objStudentsTransport.StudentID = objStudent.StudentID;
if (columns.Contains("School Vehicle Opted") && !string.IsNullOrEmpty(Convert.ToString(row["School Vehicle Opted"])))
{
if (Convert.ToString(row["School Vehicle Opted"]).Trim() == "Yes")
objStudentsTransport.SchoolVehicleOpted = true;
else if (Convert.ToString(row["School Vehicle Opted"]).Trim() == "No")
objStudentsTransport.SchoolVehicleOpted = false;
}
if (columns.Contains("Mode Of Transport") && !string.IsNullOrEmpty(Convert.ToString(row["Mode Of Transport"])))
objStudentsTransport.ModeOfTransport = Convert.ToString(row["Mode Of Transport"]).Trim();
if (columns.Contains("Area") && !string.IsNullOrEmpty(Convert.ToString(row["Area"])))
{
Area obj = new Area();
obj.AreaName = Convert.ToString(row["Area"]);
obj = _AreaService.GetByName(obj);
if (obj != null && !string.IsNullOrEmpty(obj.AreaID))
objStudentsTransport.AreaID = obj.AreaID;
}
if (columns.Contains("Bus No") && !string.IsNullOrEmpty(Convert.ToString(row["Bus No"])))
objStudentsTransport.BusNo = Convert.ToString(row["Bus No"]).Trim();
if (columns.Contains("In Time Hr") && !string.IsNullOrEmpty(Convert.ToString(row["In Time Hr"])))
objStudentsTransport.BusInTimeHr = Convert.ToInt32(row["In Time Hr"]);
if (columns.Contains("In Time Min") && !string.IsNullOrEmpty(Convert.ToString(row["In Time Min"])))
objStudentsTransport.BusInTimeMin = Convert.ToInt32(row["In Time Min"]);
if (columns.Contains("In Time AM PM") && !string.IsNullOrEmpty(Convert.ToString(row["In Time AM PM"])))
objStudentsTransport.BusInTimeAMPM = Convert.ToString(row["In Time AM PM"]).Trim();
if (columns.Contains("Out Time Hr") && !string.IsNullOrEmpty(Convert.ToString(row["Out Time Hr"])))
objStudentsTransport.BusOutTimeHr = Convert.ToInt32(row["Out Time Hr"]);
if (columns.Contains("Out Time Min") && !string.IsNullOrEmpty(Convert.ToString(row["Out Time Min"])))
objStudentsTransport.BusOutTimeMin = Convert.ToInt32(row["Out Time Min"]);
if (columns.Contains("Out Time AM PM") && !string.IsNullOrEmpty(Convert.ToString(row["Out Time AM PM"])))
objStudentsTransport.BusOutTimeAMPM = Convert.ToString(row["Out Time AM PM"]).Trim();
_IStudentsTransportService.AddEdit(objStudentsTransport);
}
#endregion
}
}
if (File.Exists(entity.StudentExcelFilePath))
File.Delete(entity.StudentExcelFilePath);
}
}
catch (Exception ex)
{
eSchoolExceptionManagement logExpection = new eSchoolExceptionManagement();
logExpection.ManageException(ex, true, eSchoolExceptionManagement.ErrorLogType.Database, "1");
cnn.Close();
}
finally
{
cnn.Close();
}
return true;
}