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)));
}
