public string AddUpdateOnlineTest(OnlineTestViewModel objOnlineTest) { var onlineTestData = _iDOnlineTest.AddUpdateOnlineTest(objOnlineTest); if (!string.IsNullOrEmpty(onlineTestData)) { return(onlineTestData); } else { return(onlineTestData); } }
public string AddUpdateOnlineTest(OnlineTestViewModel objOnlineTest) { List <SqlParameter> sqlParameterList = new List <SqlParameter>(); sqlParameterList.Add(new SqlParameter("OnlineTestID", objOnlineTest.OnlineTestID)); sqlParameterList.Add(new SqlParameter("OnlineTestNo", string.IsNullOrEmpty(objOnlineTest.OnlineTestNo) ? DGeneric.GetNewId("OnlineTest", "OnlineTestID").ToString() : objOnlineTest.OnlineTestNo)); sqlParameterList.Add(new SqlParameter("TestSeriesID", objOnlineTest.TestSeriesID)); sqlParameterList.Add(new SqlParameter("TestTypeID", objOnlineTest.TestTypeID)); sqlParameterList.Add(new SqlParameter("TestName", !string.IsNullOrEmpty(objOnlineTest.TestName) ? objOnlineTest.TestName : string.Empty)); sqlParameterList.Add(new SqlParameter("TestDuration", !string.IsNullOrEmpty(objOnlineTest.TestDuration) ? objOnlineTest.TestDuration : string.Empty)); sqlParameterList.Add(new SqlParameter("SessionID", objOnlineTest.SessionID)); sqlParameterList.Add(new SqlParameter("StreamID", string.Join(",", objOnlineTest.StreamID))); sqlParameterList.Add(new SqlParameter("CourseID", objOnlineTest.CourseID != null ? objOnlineTest.CourseID.Length > 0 ? string.Join(",", objOnlineTest.CourseID) : string.Empty : string.Empty)); sqlParameterList.Add(new SqlParameter("BatchID", objOnlineTest.BatchID != null & objOnlineTest.CourseID != null ? objOnlineTest.BatchID.Length > 0 & objOnlineTest.CourseID.Length > 0 ? string.Join(",", objOnlineTest.BatchID) : string.Empty : string.Empty)); sqlParameterList.Add(new SqlParameter("SubjectID", objOnlineTest.SubjectID != null ? objOnlineTest.SubjectID.Length > 0 ? string.Join(",", objOnlineTest.SubjectID) : string.Empty : string.Empty)); sqlParameterList.Add(new SqlParameter("Topic", !string.IsNullOrEmpty(objOnlineTest.Topic) ? objOnlineTest.Topic : string.Empty)); sqlParameterList.Add(new SqlParameter("Instructions", !string.IsNullOrEmpty(objOnlineTest.Instructions) ? objOnlineTest.Instructions : string.Empty)); sqlParameterList.Add(new SqlParameter("TestMarks", !string.IsNullOrEmpty(objOnlineTest.TestMarks) ? objOnlineTest.TestMarks : string.Empty)); sqlParameterList.Add(new SqlParameter("PassingPercentage", !string.IsNullOrEmpty(objOnlineTest.PassingPercentage) ? objOnlineTest.PassingPercentage : string.Empty)); sqlParameterList.Add(new SqlParameter("IsNegativeMarking", objOnlineTest.IsNegativeMarking)); sqlParameterList.Add(new SqlParameter("StartDate", Convert.ToDateTime(objOnlineTest.StartDate))); sqlParameterList.Add(new SqlParameter("StartTime", !string.IsNullOrEmpty(objOnlineTest.StartTime) ? objOnlineTest.StartTime : string.Empty)); sqlParameterList.Add(new SqlParameter("EndDate", Convert.ToDateTime(objOnlineTest.EndDate))); sqlParameterList.Add(new SqlParameter("EndTime", !string.IsNullOrEmpty(objOnlineTest.EndTime) ? objOnlineTest.EndTime : string.Empty)); sqlParameterList.Add(new SqlParameter("IsVisible", objOnlineTest.IsVisible)); sqlParameterList.Add(new SqlParameter("IsActive", true)); sqlParameterList.Add(new SqlParameter("CreatedByUserID", 1)); sqlParameterList.Add(new SqlParameter("CreatedOnDate", DGeneric.SystemDateTime)); return(DGeneric.RunSP_ExecuteNonQuery("sp_AddUpdateOnlineTest", sqlParameterList)); //if (!Directory.Exists("educationbridge.co.in\\" + OnlineTestID + "\\English")) // { // Directory.CreateDirectory("C:\\" + OnlineTestID + "\\English"); // } //if (!Directory.Exists("C:\\" + OnlineTestID + "\\Hindi")) // { // Directory.CreateDirectory("C:\\" + OnlineTestID + "\\Hindi"); // } //return CommonEnum.Status.Success.ToString(); }
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 HttpResponseMessage AddUpdateOnlineTest(OnlineTestViewModel objTestSeries) { return(Request.CreateResponse(HttpStatusCode.OK, _iBOnlineTest.AddUpdateOnlineTest(objTestSeries))); }