public List <SubTopicViewModel> GetSubTopic() { List <SqlParameter> sqlParameterList = new List <SqlParameter>(); List <DataTableMapping> dataTableMappingList = new List <DataTableMapping>(); dataTableMappingList.Add(new DataTableMapping("Table7", "SubTopic")); DataSet ds = DGeneric.RunSP_ReturnDataSet("sp_GetAllMasterData", sqlParameterList, dataTableMappingList); List <SubTopicViewModel> testTypeList = new List <SubTopicViewModel>(); if (ds.Tables.Count > 0) { foreach (DataTable dt in ds.Tables) { if (dt.Rows.Count > 0) { string tableName = Convert.ToString(dt.Rows[0]["TableName"]); switch (tableName) { case "SubTopic": testTypeList = DGeneric.BindDataList <SubTopicViewModel>(dt); break; } } } } return(testTypeList); //return ds.Tables["SubTopic"].AsEnumerable().Select(s => new SubTopicViewModel() //{ // SubTopicID = Convert.ToInt32(s["SubTopicID"]), // SubTopic = s["SubTopic"].ToString(), // Description = s["Description"].ToString(), // TopicID = Convert.ToInt32(s["TopicID"]), // IsActive = Convert.ToBoolean(s["IsActive"]), //}).ToList(); }
public List <CourseViewModel> GetCourseByStream(string StreamId) { if (StreamId != "") { List <SqlParameter> parameter = new List <SqlParameter>(); parameter.Add(new SqlParameter("@StreamID", StreamId)); DataTable dt = DGeneric.RunSP_ReturnDataSet("sp_GetStreamCourseBatch", parameter, null).Tables[0]; if (dt.Rows.Count > 0) { return(DGeneric.BindDataList <CourseViewModel>(dt)); } else { return(new List <CourseViewModel>()); } //return dt.AsEnumerable().Select(s => new CourseViewModel() //{ // CourseID = Convert.ToInt32(s["CourseID"]), // Course = Convert.ToString(s["Course"]) //}).ToList(); } else { return(new List <CourseViewModel>()); } }
public StudyMaterialViewModel GetStudyMaterialByID(int StudyMaterialID) { var studyMaterialViewModelData = new StudyMaterialViewModel(); List <SqlParameter> sqlParameterList = new List <SqlParameter>(); sqlParameterList.Add(new SqlParameter("@StudyMaterialID", StudyMaterialID)); DataTable dt = DGeneric.RunSP_ReturnDataSet("sp_GetStudyMaterialByID", sqlParameterList, null).Tables[0]; if (dt.Rows.Count > 0) { return(DGeneric.BindDataList <StudyMaterialViewModel>(dt).FirstOrDefault()); } else { return(new List <StudyMaterialViewModel>().FirstOrDefault()); } //if (ds.Tables.Count > 0) //{ // studyMaterialViewModelData = DGeneric.BindDataList<OnlineTestViewModel>(dt).FirstOrDefault(); // studyMaterialViewModelData.StreamID = dt.Rows[0]["StreamID"].ToString().Split(',').Select(int.Parse).ToArray(); // //Vaibhav Changed because of empty data // // onlineTestViewModelData.CourseID = dt.Rows[0]["CourseID"].ToString().Split(',').Select(int.Parse).ToArray(); // // onlineTestViewModelData.BatchID = dt.Rows[0]["BatchID"].ToString().Split(',').Select(int.Parse).ToArray(); // studyMaterialViewModelData.CourseID = dt.Rows[0]["CourseID"].ToString() != string.Empty ? dt.Rows[0]["CourseID"].ToString().Split(',').Select(int.Parse).ToArray() : null; // studyMaterialViewModelData.BatchID = dt.Rows[0]["BatchID"].ToString() != string.Empty ? dt.Rows[0]["BatchID"].ToString().Split(',').Select(int.Parse).ToArray() : null; //} //return studyMaterialViewModelData; }
public List <TopicViewModel> GetTopic() { List <SqlParameter> sqlParameterList = new List <SqlParameter>(); List <DataTableMapping> dataTableMappingList = new List <DataTableMapping>(); dataTableMappingList.Add(new DataTableMapping("Table6", "Topic")); DataSet ds = DGeneric.RunSP_ReturnDataSet("sp_GetAllMasterData", sqlParameterList, dataTableMappingList); List <TopicViewModel> testTypeList = new List <TopicViewModel>(); if (ds.Tables.Count > 0) { foreach (DataTable dt in ds.Tables) { if (dt.Rows.Count > 0) { string tableName = Convert.ToString(dt.Rows[0]["TableName"]); switch (tableName) { case "Topic": testTypeList = DGeneric.BindDataList <TopicViewModel>(dt); break; } } } } return(testTypeList); }
public static Login GetUserDetails1(Login user) { List <SqlParameter> parameter = new List <SqlParameter>(); parameter.Add(new SqlParameter("@UserName", user.UserName)); parameter.Add(new SqlParameter("@Password", user.UserPassword)); parameter.Add(new SqlParameter("@UserTypeID", user.UserTypeID)); DataTable dt = DGeneric.RunSP_ReturnDataSet("sp_Login", parameter, null).Tables[0]; if (dt.Rows.Count > 0) { return(DGeneric.BindDataList <Login>(dt).FirstOrDefault()); } else { return(new Login()); } //Login Userlist = null; //foreach (DataRow dr in dt.Rows) //{ // Userlist = new Login() // { // UserID = Convert.ToInt32(dr["UserID"]), // FirstName = dr["FirstName"].ToString(), // LastName = dr["LastName"].ToString(), // MobileNo = dr["Mobile"].ToString(), // UserName = dr["UserName"].ToString(), // // UserPassword = Convert.ToString(dr["UserPassword"]), // UserTypeID = Convert.ToInt32(dr["UserTypeID"]), // UserType = Convert.ToString(dr["UserType"]) // }; //} //return Userlist; }
public List <EligibleStudentViewModel> GetEligibleStudent(int OnlineTestID) { List <SqlParameter> sqlParameterList = new List <SqlParameter>(); sqlParameterList.Add(new SqlParameter("@OnlineTestID", OnlineTestID)); DataTable dt = DGeneric.RunSP_ReturnDataSet("sp_GetEligibleStudent", sqlParameterList, null).Tables[0]; if (dt.Rows.Count > 0) { return(DGeneric.BindDataList <EligibleStudentViewModel>(dt)); } //return dt.AsEnumerable().Select(s => new EligibleStudentViewModel() //{ // StudentID = Convert.ToInt32(s["StudentID"]), // OnlineTestID = Convert.ToInt32(s["OnlineTestID"]), // EnrollmentNo = (s["EnrollmentNo"]).ToString(), // StudentName = (s["StudentName"]).ToString(), // Gender = (s["Gender"]).ToString(), // MobileNumber = (s["MobileNumber"]).ToString(), // FatherMobileNo = (s["FatherMobileNo"]).ToString(), // IsEligible = Convert.ToBoolean((s["IsEligible"])), // TestStatusID = Convert.ToInt32(s["TestStatusID"]) //}).ToList(); else { return(new List <EligibleStudentViewModel>()); } }
public List <TestTypeViewModel> GetTestType() { List <SqlParameter> sqlParameterList = new List <SqlParameter>(); List <DataTableMapping> dataTableMappingList = new List <DataTableMapping>(); dataTableMappingList.Add(new DataTableMapping("Table", "TestType")); dataTableMappingList.Add(new DataTableMapping("Table1", "QuestionType")); dataTableMappingList.Add(new DataTableMapping("Table2", "Subject")); DataSet ds = DGeneric.RunSP_ReturnDataSet("sp_GetAllMasterData", sqlParameterList, dataTableMappingList); List <TestTypeViewModel> testTypeList = new List <TestTypeViewModel>(); if (ds.Tables.Count > 0) { foreach (DataTable dt in ds.Tables) { if (dt.Rows.Count > 0) { string tableName = Convert.ToString(dt.Rows[0]["TableName"]); switch (tableName) { case "TestType": testTypeList = DGeneric.BindDataList <TestTypeViewModel>(dt); break; } } } } return(ds.Tables["TestType"].AsEnumerable().Select(s => new TestTypeViewModel() { TestTypeID = Convert.ToInt32(s["TestTypeID"]), TestType = s["TestType"].ToString(), }).ToList()); }
public List <StudentViewModel> GetStudentDetails() { string strQuery = @"SELECT dbo.StudentAccount.StudentAccountID, dbo.StudentAccount.StudentID, dbo.StudentAccount.Password, dbo.StudentAccount.IsActive, dbo.StudentAccount.CreatedByUserID, dbo.StudentAccount.CreatedOnDate, dbo.Student.EnrollmentNo, dbo.Student.EnrollmentDate, dbo.Student.FirstName, dbo.Student.MiddleName, dbo.Student.LastName, dbo.Student.Gender, dbo.Student.DOB, dbo.Student.MobileNumber, dbo.Student.PhoneNumber, dbo.Student.Email, dbo.Student.Address, dbo.Student.Landmark, dbo.Student.CityID, dbo.Student.Pin, dbo.Student.Medium, dbo.Student.Cast, dbo.Student.PhotoUrl, dbo.Student.StreamID, dbo.Student.CourseID, dbo.Student.BatchID, dbo.Student.SessionID, dbo.Student.[School/College], dbo.Student.FatherName, dbo.Student.FatherOccupation, dbo.Student.FatherMobile, dbo.Student.FatherEmail,ss.[Session],s.Stream,c.Course,b.Batch FROM dbo.StudentAccount left JOIN dbo.Student ON dbo.Student.StudentID = dbo.StudentAccount.StudentID left join dbo.[Session] ss on Student.SessionID= ss.SessionID left join dbo.Stream s on Student.StreamID= s.StreamID left join dbo.Course c on Student.CourseID= c.CourseID left join dbo.Batch b on Student.BatchID= b.BatchID" ; DataTable dt = DGeneric.GetData(strQuery).Tables[0]; if (dt.Rows.Count > 0) { return(DGeneric.BindDataList <StudentViewModel>(dt)); } else { return(new List <StudentViewModel>()); } //return dt.AsEnumerable().Select(x => new StudentViewModel() //{ // StudentAccountID = Convert.ToInt32(x["StudentAccountID"]), // StudentID = Convert.ToInt32(x["StudentID"]), // EnrollmentNo = x["EnrollmentNo"].ToString(), // EnrollmentDate = x["EnrollmentDate"].ToString().ConvertDateTimeToString(), // FirstName = x["FirstName"].ToString(), // LastName = x["LastName"].ToString(), // Gender = x["Gender"].ToString(), // DOB = x["DOB"].ToString().ConvertDateTimeToString(), // MobileNo = x["MobileNumber"].ToString(), // Email = x["Email"].ToString(), // Address = x["Address"].ToString(), // Landmark = x["Landmark"].ToString(), // Pincode = x["Pin"].ToString(), // CityID = Convert.ToInt32(x["CityID"]), // Caste = x["Cast"].ToString(), // PhotoUrl = x["PhotoUrl"].ToString(), // Medium = x["Medium"].ToString(), // FatherName = x["FatherName"].ToString(), // FatherMobile = x["FatherMobile"].ToString(), // FatherEmail = x["FatherEmail"].ToString(), // //SessionID = Convert.ToInt32(x["SessionID"]), // //StreamID = Convert.ToInt32(x["StreamID"]), // //CourseID = Convert.ToInt32(x["CourseID"]), // //BatchID = Convert.ToInt32(x["BatchID"]), //}).ToList(); }
public List <StudyMaterialViewModel> GetStudyMaterial() { DataTable dt = DGeneric.RunSP_ReturnDataSet("sp_GetStudyMaterial", null, null).Tables[0]; if (dt.Rows.Count > 0) { return(DGeneric.BindDataList <StudyMaterialViewModel>(dt)); } else { return(new List <StudyMaterialViewModel>()); } }
public List <GeneralSettingsViewModel> GetGeneralSettings() { DataTable dt = DGeneric.GetData("Select * from GeneralSettings").Tables[0]; if (dt.Rows.Count > 0) { return(DGeneric.BindDataList <GeneralSettingsViewModel>(dt)); } else { return(new List <GeneralSettingsViewModel>()); } }
public StudentDashboardViewModel GetStudentDashboardDetail(int StudentID) { List <SqlParameter> sqlParameterList = new List <SqlParameter>(); sqlParameterList.Add(new SqlParameter("StudentID", StudentID)); List <DataTableMapping> dataTableMapping = new List <DataTableMapping>(); dataTableMapping.Add(new DataTableMapping("Table", "TotalTest")); dataTableMapping.Add(new DataTableMapping("Table1", "NotStarted")); dataTableMapping.Add(new DataTableMapping("Table2", "Started")); dataTableMapping.Add(new DataTableMapping("Table3", "Completed")); dataTableMapping.Add(new DataTableMapping("Table4", "TestPercentage")); DataSet ds = DGeneric.RunSP_ReturnDataSet("sp_GetStudentDashboard", sqlParameterList, dataTableMapping); var StudentDashboardData = new StudentDashboardViewModel(); if (ds.Tables.Count > 0) { foreach (DataTable dt in ds.Tables) { if (dt.Rows.Count > 0) { string tableName = Convert.ToString(dt.TableName); switch (tableName) { case "TotalTest": StudentDashboardData.TotalTest = Convert.ToInt32(dt.Rows[0]["TotalTest"]); break; case "NotStarted": StudentDashboardData.NotStarted = Convert.ToInt32(dt.Rows[0]["NotStarted"]); break; case "Started": StudentDashboardData.Started = Convert.ToInt32(dt.Rows[0]["Started"]); break; case "Completed": StudentDashboardData.Completed = Convert.ToInt32(dt.Rows[0]["Completed"]); break; case "TestPercentage": StudentDashboardData.TestPercentage = DGeneric.BindDataList <TestPercentage>(dt).OrderBy(o => o.ResultID).ToList(); break; } } } } return(StudentDashboardData); }
public List <SliderViewModel> GetSlider(int SliderID) { List <SqlParameter> sqlParameterList = new List <SqlParameter>(); sqlParameterList.Add(new SqlParameter("SliderID", SliderID > 0 ? SliderID : 0)); DataTable dt = DGeneric.RunSP_ReturnDataSet("sp_GetSlider", sqlParameterList, null).Tables[0]; if (dt.Rows.Count > 0) { return(DGeneric.BindDataList <SliderViewModel>(dt)); } else { return(new List <SliderViewModel>()); } }
public List <StudyMaterialViewModel> GetStudyMaterialBySubTopic(string SubTopicID) { List <SqlParameter> parameter = new List <SqlParameter>(); parameter.Add(new SqlParameter("SubTopicID", SubTopicID)); DataTable dt = DGeneric.RunSP_ReturnDataSet("sp_GetStudyMaterialBySubTopic", parameter, null).Tables[0]; if (dt.Rows.Count > 0) { return(DGeneric.BindDataList <StudyMaterialViewModel>(dt)); } else { return(new List <StudyMaterialViewModel>()); } }
public List <NotificationViewModel> GetNotification(int NotificationID, int ReciverID) { List <SqlParameter> sqlParameterList = new List <SqlParameter>(); sqlParameterList.Add(new SqlParameter("NotificationID", NotificationID > 0 ? NotificationID : 0)); sqlParameterList.Add(new SqlParameter("ReciverID", ReciverID > 0 ? ReciverID : 0)); DataTable dt = DGeneric.RunSP_ReturnDataSet("sp_GetNotification", sqlParameterList, null).Tables[0]; if (dt.Rows.Count > 0) { return(DGeneric.BindDataList <NotificationViewModel>(dt)); } else { return(new List <NotificationViewModel>()); } }
public List <StudentOnlineTestViewModel> GetOnlineTestByStudentID(int StudentID) { List <SqlParameter> sqlParameterList = new List <SqlParameter>(); sqlParameterList.Add(new SqlParameter("@StudentID", StudentID)); DataTable dt = DGeneric.RunSP_ReturnDataSet("sp_GetOnlineTestByStudentID", sqlParameterList, null).Tables[0]; if (dt.Rows.Count > 0) { return(DGeneric.BindDataList <StudentOnlineTestViewModel>(dt)); } else { return(new List <StudentOnlineTestViewModel>()); } //return dt.AsEnumerable().Select(s => new StudentOnlineTestViewModel() //{ // EligibleStudentID = Convert.ToInt32(s["EligibleStudentID"]), // StudentID = Convert.ToInt32(s["StudentID"]), // OnlineTestID = Convert.ToInt32(s["OnlineTestID"]), // OnlineTestNo = s["OnlineTestNo"].ToString(), // TestSeriesID = Convert.ToInt32(s["TestSeriesID"]), // TestTypeID = Convert.ToInt32(s["TestTypeID"]), // TestSeriesName = s["TestSeries"].ToString(), // TestTypeName = s["TestType"].ToString(), // TestName = s["TestName"].ToString(), // TestDuration = s["TestDuration"].ToString(), // SessionID = Convert.ToInt32(s["SessionID"]), // //StreamID = Convert.ToInt32(s["StreamID"]), // //CourseID = Convert.ToInt32(s["CourseID"]), // //BatchID = Convert.ToInt32(s["BatchID"]), // SubjectID = Convert.ToInt32(s["SubjectID"]), // Topic = s["Topic"].ToString(), // Instructions = s["Instructions"].ToString(), // TestMarks = s["TestMarks"].ToString(), // PassingPercentage = s["PassingPercentage"].ToString(), // IsNegativeMarking = Convert.ToBoolean(s["IsNegativeMarking"]), // IsVisible = Convert.ToBoolean(s["IsVisible"]), // StartTime = s["StartTime"].ToString(), // EndTime = s["EndTime"].ToString(), // StartDate = Convert.ToDateTime(s["StartDate"]), // EndDate = Convert.ToDateTime(s["EndDate"]), // IsActive = Convert.ToBoolean(s["IsActive"]) //}).ToList(); }
public List <StudentResponseViewModel> GetStudentResponse(int StudentID, int TestID) { List <SqlParameter> paramerterList = new List <SqlParameter>(); paramerterList.Add(new SqlParameter("@StudentID", StudentID)); paramerterList.Add(new SqlParameter("@TestID", TestID)); DataTable dt = DGeneric.RunSP_ReturnDataSet("sp_GetStudentResponse", paramerterList, null).Tables[0]; if (dt.Rows.Count > 0) { return(DGeneric.BindDataList <StudentResponseViewModel>(dt)); } else { return(new List <StudentResponseViewModel>()); } }
//return dt.AsEnumerable().Select(s => new BatchViewModel() //{ // BatchID = Convert.ToInt32(s["BatchID"]), // Batch = s["Batch"].ToString(), //}).ToList(); public List <SessionViewModel> GetSession() { DataTable dt = DGeneric.RunSP_ReturnDataSet("sp_SessionSelect", null, null).Tables[0]; if (dt.Rows.Count > 0) { return(DGeneric.BindDataList <SessionViewModel>(dt)); } else { return(new List <SessionViewModel>()); } //return dt.AsEnumerable().Select(s => new SessionViewModel() //{ // SessionID = Convert.ToInt32(s["SessionID"]), // Session = Convert.ToString(s["Session"]), //}).ToList(); }
public List <OnlineTestViewModel> GetOnlineTest() { DataTable dt = DGeneric.RunSP_ReturnDataSet("sp_GetAllOnlineTest", null, null).Tables[0]; if (dt.Rows.Count > 0) { return(DGeneric.BindDataList <OnlineTestViewModel>(dt)); } else { return(new List <OnlineTestViewModel>()); } //return dt.AsEnumerable().Select(s => new OnlineTestViewModel() //{ // OnlineTestID = Convert.ToInt32(s["OnlineTestID"]), // OnlineTestNo = s["OnlineTestNo"].ToString(), // TestSeriesID = Convert.ToInt32(s["TestSeriesID"]), // TestSeries = s["TestSeries"].ToString(), // TestTypeID = Convert.ToInt32(s["TestTypeID"]), // TestType = s["TestType"].ToString(), // TestName = s["TestName"].ToString(), // TestDuration = s["TestDuration"].ToString(), // SessionID = Convert.ToInt32(s["SessionID"]), // //StreamID = s["StreamID"].ToString().Split(',').ToArray(), // //CourseID = Convert.ToInt32(s["CourseID"]), // //BatchID = Convert.ToInt32(s["BatchID"]), // //StreamID = s["StreamID"].ToString().Split(',').Select(int.Parse).ToArray(), // //CourseID = s["CourseID"].ToString() != string.Empty ? dt.Rows[0]["CourseID"].ToString().Split(',').Select(int.Parse).ToArray() : null, // //BatchID = s["BatchID"].ToString() != string.Empty ? dt.Rows[0]["BatchID"].ToString().Split(',').Select(int.Parse).ToArray() : null, // // SubjectID = Convert.ToInt32(s["SubjectID"]), // Topic = s["Topic"].ToString(), // Instructions = s["Instructions"].ToString(), // TestMarks = s["TestMarks"].ToString(), // PassingPercentage = s["PassingPercentage"].ToString(), // IsNegativeMarking = Convert.ToBoolean(s["IsNegativeMarking"]), // IsVisible = Convert.ToBoolean(s["IsVisible"]), // StartTime = s["StartTime"].ToString(), // EndTime = s["EndTime"].ToString(), // StartDate = Convert.ToString(s["StartDate"]).ConvertDateTimeToString(), // EndDate = Convert.ToString(s["EndDate"]).ConvertDateTimeToString() //}).ToList(); }
public List <StudentReport> GetFilteredStudent(StudentReport objSR) { List <SqlParameter> sqlParameterList = new List <SqlParameter>(); sqlParameterList.Add(new SqlParameter("@SessionID", !string.IsNullOrEmpty(objSR.SessionID)? objSR.SessionID:null)); sqlParameterList.Add(new SqlParameter("@StreamID", objSR.StreamID != null ? objSR.StreamID.Length > 0 ? string.Join(",", objSR.StreamID) : string.Empty : string.Empty)); sqlParameterList.Add(new SqlParameter("@CourseID", objSR.CourseID != null ? objSR.CourseID.Length > 0 ? string.Join(",", objSR.CourseID) : string.Empty : string.Empty)); sqlParameterList.Add(new SqlParameter("@BatchID", objSR.BatchID != null & objSR.CourseID != null ? objSR.BatchID.Length > 0 & objSR.CourseID.Length > 0 ? string.Join(",", objSR.BatchID) : string.Empty : string.Empty)); DataTable dt = DGeneric.RunSP_ReturnDataSet("sp_GetFilterStudent", sqlParameterList, null).Tables[0]; if (dt.Rows.Count > 0) { return(DGeneric.BindDataList <StudentReport>(dt)); } else { return(new List <StudentReport>()); } }
public TopicViewModel GetTopicByID(int TopicID) { var topicViewModelData = new TopicViewModel(); List <SqlParameter> sqlParameterList = new List <SqlParameter>(); sqlParameterList.Add(new SqlParameter("@TopicID", TopicID)); IList <DataTableMapping> dataTableMappingList = new List <DataTableMapping>(); dataTableMappingList.Add(new DataTableMapping("Table", "Topic")); dataTableMappingList.Add(new DataTableMapping("Table1", "Course")); dataTableMappingList.Add(new DataTableMapping("Table2", "Batch")); DataSet ds = DGeneric.RunSP_ReturnDataSet("sp_GetTopicByID", sqlParameterList, dataTableMappingList); if (ds.Tables.Count > 0) { foreach (DataTable dt in ds.Tables) { if (dt.Rows.Count > 0) { switch (dt.TableName) { case "Topic": topicViewModelData = DGeneric.BindDataList <TopicViewModel>(dt).FirstOrDefault(); topicViewModelData.StreamID = dt.Rows[0]["StreamID"].ToString().Split(',').Select(int.Parse).ToArray(); topicViewModelData.CourseID = dt.Rows[0]["CourseID"].ToString() != string.Empty ? dt.Rows[0]["CourseID"].ToString().Split(',').Select(int.Parse).ToArray() : null; topicViewModelData.BatchID = dt.Rows[0]["BatchID"].ToString() != string.Empty ? dt.Rows[0]["BatchID"].ToString().Split(',').Select(int.Parse).ToArray() : null; break; case "Course": topicViewModelData.Course = DGeneric.BindDataList <CourseViewModel>(dt); break; case "Batch": topicViewModelData.Batch = DGeneric.BindDataList <BatchViewModel>(dt); break; } } } } return(topicViewModelData); }
public List <BatchViewModel> GetBatchByCourse(string CourseId) { if (CourseId != "") { List <SqlParameter> parameter = new List <SqlParameter>(); parameter.Add(new SqlParameter("CourseID", CourseId)); DataTable dt = DGeneric.RunSP_ReturnDataSet("sp_GetStreamCourseBatch", parameter, null).Tables[0]; if (dt.Rows.Count > 0) { return(DGeneric.BindDataList <BatchViewModel>(dt)); } else { return(new List <BatchViewModel>()); } } else { return(new List <BatchViewModel>()); } }
public OnlineTestViewModel GetOnlineTestById(int OnlineTestID) { var onlineTestViewModelData = new OnlineTestViewModel(); List <SqlParameter> sqlParameterList = new List <SqlParameter>(); sqlParameterList.Add(new SqlParameter("@OnlineTestID", OnlineTestID)); IList <DataTableMapping> dataTableMappingList = new List <DataTableMapping>(); dataTableMappingList.Add(new DataTableMapping("Table", "OnlineTest")); dataTableMappingList.Add(new DataTableMapping("Table1", "Course")); dataTableMappingList.Add(new DataTableMapping("Table2", "Batch")); dataTableMappingList.Add(new DataTableMapping("Table3", "Subject")); DataSet ds = DGeneric.RunSP_ReturnDataSet("sp_GetOnlineTestById", sqlParameterList, dataTableMappingList); if (ds.Tables.Count > 0) { foreach (DataTable dt in ds.Tables) { if (dt.Rows.Count > 0) { switch (dt.TableName) { case "OnlineTest": onlineTestViewModelData = DGeneric.BindDataList <OnlineTestViewModel>(dt).FirstOrDefault(); onlineTestViewModelData.StreamID = dt.Rows[0]["StreamID"].ToString().Split(',').Select(int.Parse).ToArray(); //Vaibhav Changed because of empty data // onlineTestViewModelData.CourseID = dt.Rows[0]["CourseID"].ToString().Split(',').Select(int.Parse).ToArray(); // onlineTestViewModelData.BatchID = dt.Rows[0]["BatchID"].ToString().Split(',').Select(int.Parse).ToArray(); onlineTestViewModelData.CourseID = dt.Rows[0]["CourseID"].ToString() != string.Empty ? dt.Rows[0]["CourseID"].ToString().Split(',').Select(int.Parse).ToArray() : null; onlineTestViewModelData.BatchID = dt.Rows[0]["BatchID"].ToString() != string.Empty ? dt.Rows[0]["BatchID"].ToString().Split(',').Select(int.Parse).ToArray() : null; onlineTestViewModelData.SubjectID = dt.Rows[0]["SubjectID"].ToString() != string.Empty ? dt.Rows[0]["SubjectID"].ToString().Split(',').Select(int.Parse).ToArray() : null; //onlineTestViewModelData.StartDate = Convert.ToString(dt.Rows[0]["StartDate"]).ConvertDateTimeToString(); //onlineTestViewModelData.EndDate = Convert.ToString(dt.Rows[0]["EndDate"]).ConvertDateTimeToString(); break; case "Course": onlineTestViewModelData.Course = DGeneric.BindDataList <CourseViewModel>(dt); break; case "Batch": onlineTestViewModelData.Batch = DGeneric.BindDataList <BatchViewModel>(dt); break; case "Subject": onlineTestViewModelData.Subject = DGeneric.BindDataList <SubjectViewModel>(dt); break; } } } } return(onlineTestViewModelData); //if (dt.Rows.Count > 0) //{ // foreach (DataRow item in dt.Rows) // { // onlineTestViewModelData.OnlineTestID = Convert.ToInt32(item["OnlineTestID"]); // onlineTestViewModelData.OnlineTestNo = item["OnlineTestNo"].ToString(); // onlineTestViewModelData.TestSeriesID = Convert.ToInt32(item["TestSeriesID"]); // onlineTestViewModelData.TestTypeID = Convert.ToInt32(item["TestTypeID"]); // onlineTestViewModelData.TestName = item["TestName"].ToString(); // onlineTestViewModelData.TestDuration = item["TestDuration"].ToString(); // onlineTestViewModelData.SessionID = Convert.ToInt32(item["SessionID"]); // onlineTestViewModelData.StreamID = item["StreamID"].ToString().Split(',').Cast<int>().ToArray(); // onlineTestViewModelData.CourseID = item["CourseID"].ToString().Split(',').Cast<int>().ToArray(); // onlineTestViewModelData.BatchID = item["BatchID"].ToString().Split(',').Cast<int>().ToArray(); // onlineTestViewModelData.SubjectID = Convert.ToInt32(item["SubjectID"]); // onlineTestViewModelData.Topic = item["Topic"].ToString(); // onlineTestViewModelData.Instructions = item["Instructions"].ToString(); // onlineTestViewModelData.TestMarks = item["TestMarks"].ToString(); // onlineTestViewModelData.PassingPercentage = item["PassingPercentage"].ToString(); // onlineTestViewModelData.IsNegativeMarking = Convert.ToBoolean(item["IsNegativeMarking"]); // onlineTestViewModelData.IsVisible = Convert.ToBoolean(item["IsVisible"]); // onlineTestViewModelData.StartTime = item["StartTime"].ToString(); // onlineTestViewModelData.EndTime = item["EndTime"].ToString(); // onlineTestViewModelData.StartDate = Convert.ToDateTime(item["StartDate"]); // onlineTestViewModelData.EndDate = Convert.ToDateTime(item["EndDate"]); // } //} //return onlineTestViewModelData; //return ds.Tables[0].AsEnumerable().Select(s => new OnlineTestViewModel() //{ // OnlineTestID = Convert.ToInt32(s["OnlineTestID"]), // OnlineTestNo = s["OnlineTestNo"].ToString(), // TestSeriesID = Convert.ToInt32(s["TestSeriesID"]), // TestTypeID = Convert.ToInt32(s["TestTypeID"]), // TestName = s["TestName"].ToString(), // TestDuration = s["TestDuration"].ToString(), // SessionID = Convert.ToInt32(s["SessionID"]), // StreamID = s["StreamID"].ToString().Split(',').Cast<int>().ToArray(), // CourseID = s["CourseID"].ToString().Split(',').Cast<int>().ToArray(), // BatchID = s["BatchID"].ToString().Split(',').Cast<int>().ToArray(), // SubjectID = Convert.ToInt32(s["SubjectID"]), // Topic = s["Topic"].ToString(), // Instructions = s["Instructions"].ToString(), // TestMarks = s["TestMarks"].ToString(), // PassingPercentage = s["PassingPercentage"].ToString(), // IsNegativeMarking = Convert.ToBoolean(s["IsNegativeMarking"]), // IsVisible = Convert.ToBoolean(s["IsVisible"]), // StartTime = s["StartTime"].ToString(), // EndTime = s["EndTime"].ToString(), // StartDate = Convert.ToDateTime(s["StartDate"]), // EndDate = Convert.ToDateTime(s["EndDate"]) //}).FirstOrDefault(); }
public MasterViewModel GetMasterData() { List <SqlParameter> sqlParameterList = new List <SqlParameter>(); DataSet ds = DGeneric.RunSP_ReturnDataSet("sp_GetAllMasterData", sqlParameterList, null); var masterData = new MasterViewModel(); if (ds.Tables.Count > 0) { foreach (DataTable dt in ds.Tables) { if (dt.Rows.Count > 0) { string tableName = Convert.ToString(dt.Rows[0]["TableName"]); switch (tableName) { case "TestType": masterData.TestType = DGeneric.BindDataList <TestTypeViewModel>(dt); break; case "TestSeries": masterData.TestSeries = DGeneric.BindDataList <TestSeriesViewModel>(dt); break; case "Stream": masterData.Stream = DGeneric.BindDataList <StreamViewModel>(dt); break; case "Session": masterData.Session = DGeneric.BindDataList <SessionViewModel>(dt); break; case "Subject": masterData.Subject = DGeneric.BindDataList <SubjectViewModel>(dt); break; case "Topic": masterData.Topic = DGeneric.BindDataList <TopicViewModel>(dt); break; case "SubTopic": masterData.SubTopic = DGeneric.BindDataList <SubTopicViewModel>(dt); break; case "Batch": masterData.Batch = DGeneric.BindDataList <BatchViewModel>(dt); break; case "DefaultLecture": masterData.DefaultLecture = DGeneric.BindDataList <LectureModel>(dt); break; case "Users": masterData.UserList = DGeneric.BindDataList <UserViewModel>(dt); break; case "Faculty": masterData.FacultyList = DGeneric.BindDataList <FacultyViewModel>(dt); break; } } } } return(masterData); }
public TimeTableViewModel GetTimeTableByDate(TimeTableViewModel objTimeTable) { var timeTableViewModel = new TimeTableViewModel(); List <DataTableMapping> dataTableMappingList = new List <DataTableMapping>(); dataTableMappingList.Add(new DataTableMapping("Table", "TimeTable")); dataTableMappingList.Add(new DataTableMapping("Table1", "Lecture")); dataTableMappingList.Add(new DataTableMapping("Table2", "Batch")); dataTableMappingList.Add(new DataTableMapping("Table3", "DefaultLecture")); List <SqlParameter> sqlParameterList = new List <SqlParameter>(); sqlParameterList.Add(new SqlParameter("@Date", Convert.ToDateTime(objTimeTable.FromDate))); sqlParameterList.Add(new SqlParameter("@ShiftID", Convert.ToInt32(objTimeTable.ShiftID))); sqlParameterList.Add(new SqlParameter("@SessionID", Convert.ToInt32(objTimeTable.SessionID))); DataSet ds = DGeneric.RunSP_ReturnDataSet("sp_GetTimeTableByDate", sqlParameterList, dataTableMappingList); List <LectureViewModel> obj = new List <LectureViewModel>(); if (ds.Tables.Count > 0) { foreach (DataTable dt in ds.Tables) { if (dt.Rows.Count > 0) { switch (dt.TableName) { case "Lecture": foreach (DataRow dr in ds.Tables[1].Rows) { obj.Add(new LectureViewModel() { Lecture = new LectureViewModel() { LectureID = Convert.ToInt32(dr["LectureID"]), LectureName = dr["Lecture"].ToString(), Time_From = dr["Time_From"].ToString(), Time_To = dr["Time_To"].ToString() }, Batch = new ViewModels.Master.BatchViewModel() { BatchID = Convert.ToInt32(dr["BatchID"]), Batch = dr["Batch"].ToString() }, Subject = dr["Subject"].ToString(), FacultyID = Convert.ToInt32(dr["FacultyID"]), Faculty = dr["Faculty"].ToString(), TimeTableID = Convert.ToInt32(dr["TimeTableID"]), ID = Convert.ToInt32(dr["ID"]) }); } break; case "TimeTable": timeTableViewModel = DGeneric.BindDataList <TimeTableViewModel>(ds.Tables[0]).FirstOrDefault(); timeTableViewModel.DateType = "single"; timeTableViewModel.FromDate = Convert.ToString(ds.Tables[0].Rows[0]["TimeTableDate"]).ConvertDateTimeToString(); timeTableViewModel.LectureID = ds.Tables[0].Rows[0]["LectureID"].ToString() != string.Empty ? ds.Tables[0].Rows[0]["LectureID"].ToString().Split(',').Select(int.Parse).ToArray() : null; timeTableViewModel.BatchID = ds.Tables[0].Rows[0]["BatchID"].ToString() != string.Empty ? ds.Tables[0].Rows[0]["BatchID"].ToString().Split(',').Select(int.Parse).ToArray() : null; timeTableViewModel.LectureList = obj; break; case "DefaultLecture": timeTableViewModel.Lecture = DGeneric.BindDataList <LectureModel>(dt); break; case "Batch": timeTableViewModel.Batch = DGeneric.BindDataList <BatchViewModel>(dt); break; } } } } return(timeTableViewModel); //return ds.Tables[0].AsEnumerable().Select(s => new TimeTableViewModel() //{ // TimeTableID = Convert.ToInt32(s["TimeTableID"]), // Description = s["Description"].ToString(), // FromDate = Convert.ToDateTime(s["TimeTableDate"]), // ToDate = Convert.ToDateTime(s["TimeTableDate"]), // ShiftID = Convert.ToInt32(s["ShiftID"]), // SessionID = Convert.ToInt32(s["SessionID"]), // BatchID = Convert.ToInt32(s["BatchID"]).Split(',').ToArray(), // LectureID = Convert.ToInt32(s["LectureID"]), // CreatedByUserID = Convert.ToInt32(s["CreatedByUserID"]), // CreatedOnDate = Convert.ToDateTime(s["CreatedOnDate"]), // IsActive = Convert.ToBoolean(s["IsActive"]), // LectureList = obj //}).ToList(); }