//Method for Course to Compare
private void ComapreCourse()
{
//To Retrive all StreamList Based on FirstStreamName.
var data = StreamProvider.Instance.GetStreamListByStreamName(txtFirsteStream.Text.Trim());
DivStreamDetails.Visible = true;
DivStreamDetails.Focus();
if (data.Count > 0)
{
var query = data.Select(result => new
{
result.CourseStreamName,
result.CourseName,
result.CourseStreamHistory,
result.CourseStreamDesc,
result.CourseSteamFuture,
result.CourseStreamRelatedIndustry,
result.CourseStreamCoreCompanies,
}).First();
lblStream1.Text = query.CourseStreamName;
liStreamBasicInfo.Visible = true;
lblComFirstStreamName.Visible = true;
lblComFirstStreamName.Text = query.CourseStreamName;
lblComFirstStreamName.NavigateUrl = Utils.ApplicationRelativeWebRoot + ("Stream-Detail/" + Utils.RemoveIllegealFromCourse(query.CourseName) + "/" + Utils.RemoveIllegalCharacters(query.CourseStreamName)).ToLower();
if (!(query.CourseStreamHistory.Equals("NULL", StringComparison.OrdinalIgnoreCase)))
{
lblBriefHistory.Text =
!string.IsNullOrEmpty(
Convert.ToString(query.CourseStreamHistory.ToString(CultureInfo.InvariantCulture)))
? query.CourseStreamHistory
: "N/A";
}
else
{
lblBriefHistory.Text = "N/A";
}
if (!(query.CourseStreamDesc.Equals("NULL", StringComparison.OrdinalIgnoreCase)))
{
lblShortDesc.Text =
!string.IsNullOrEmpty(
Convert.ToString(query.CourseStreamDesc.ToString(CultureInfo.InvariantCulture)))
? query.CourseStreamDesc
: "N/A";
}
else
{
lblShortDesc.Text = "N/A";
}
if (!(query.CourseSteamFuture.Equals("NULL", StringComparison.OrdinalIgnoreCase)))
{
lblFuruteScope.Text =
!string.IsNullOrEmpty(
Convert.ToString(query.CourseSteamFuture.ToString(CultureInfo.InvariantCulture)))
? query.CourseSteamFuture
: "N/A";
}
else
{
lblFuruteScope.Text = "N/A";
}
if (!(query.CourseStreamRelatedIndustry.Equals("NULL", StringComparison.OrdinalIgnoreCase)))
{
lblReIndustry.Text =
!string.IsNullOrEmpty(
Convert.ToString(query.CourseStreamRelatedIndustry.ToString(CultureInfo.InvariantCulture)))
? query.CourseStreamRelatedIndustry
: "N/A";
}
else
{
lblReIndustry.Text = "N/A";
}
if (!(query.CourseStreamCoreCompanies.Equals("NULL", StringComparison.OrdinalIgnoreCase)))
{
lblCoreCompanies.Text =
!string.IsNullOrEmpty(
Convert.ToString(query.CourseStreamCoreCompanies.ToString(CultureInfo.InvariantCulture)))
? query.CourseStreamCoreCompanies
: "N/A";
}
else
{
lblCoreCompanies.Text = "N/A";
}
}
//To Retrive all StreamList based on SecondCollegeName
var data1 = StreamProvider.Instance.GetStreamListByStreamName(txtSecondCollegeName.Text.Trim());
if (data1.Count > 0)
{
var query = data1.Select(result => new
{
result.CourseStreamName, result.CourseStreamHistory, result.CourseStreamDesc, result.CourseName,
result.CourseSteamFuture, result.CourseStreamRelatedIndustry, result.CourseStreamCoreCompanies,
}).First();
lblStream2.Text = query.CourseStreamName;
liStreamBasicInfo.Visible = true;
lblComSecondStreamName.Visible = true;
lblComSecondStreamName.Text = query.CourseStreamName;
lblComSecondStreamName.NavigateUrl = Utils.ApplicationRelativeWebRoot + ("Stream-Detail/" + Utils.RemoveIllegealFromCourse(query.CourseName) + "/" + Utils.RemoveIllegalCharacters(query.CourseStreamName)).ToLower();
if (!(query.CourseStreamHistory.Equals("NULL", StringComparison.OrdinalIgnoreCase)))
{
lblBriefHistory1.Text =
!string.IsNullOrEmpty(
Convert.ToString(query.CourseStreamHistory.ToString(CultureInfo.InvariantCulture)))
? query.CourseStreamHistory
: "N/A";
}
else
{
lblBriefHistory1.Text = "N/A";
}
if (!(query.CourseStreamDesc.Equals("NULL", StringComparison.OrdinalIgnoreCase)))
{
lblShortDesc1.Text =
!string.IsNullOrEmpty(
Convert.ToString(query.CourseStreamDesc.ToString(CultureInfo.InvariantCulture)))
? query.CourseStreamDesc
: "N/A";
}
else
{
lblShortDesc1.Text = "N/A";
}
if (!(query.CourseSteamFuture.Equals("NULL", StringComparison.OrdinalIgnoreCase)))
{
lblFuruteScope1.Text =
!string.IsNullOrEmpty(
Convert.ToString(query.CourseSteamFuture.ToString(CultureInfo.InvariantCulture)))
? query.CourseSteamFuture
: "N/A";
}
else
{
lblFuruteScope1.Text = "N/A";
}
if (!(query.CourseStreamRelatedIndustry.Equals("NULL", StringComparison.OrdinalIgnoreCase)))
{
lblReIndustry1.Text =
!string.IsNullOrEmpty(
Convert.ToString(query.CourseStreamRelatedIndustry.ToString(CultureInfo.InvariantCulture)))
? query.CourseStreamRelatedIndustry
: "N/A";
}
else
{
lblReIndustry1.Text = "N/A";
}
if (!(query.CourseStreamCoreCompanies.Equals("NULL", StringComparison.OrdinalIgnoreCase)))
{
lblCoreCompanies1.Text =
!string.IsNullOrEmpty(
Convert.ToString(query.CourseStreamCoreCompanies.ToString(CultureInfo.InvariantCulture)))
? query.CourseStreamCoreCompanies
: "N/A";
}
else
{
lblCoreCompanies1.Text = "N/A";
}
}
}
// Method to Bind the Course Compare
protected void BindCompare(int streamId1, int streamId2)
{
DivStreamDetails.Visible = true;
DivStreamDetails.Focus();
//Return StreamName based on First StreamId1
var data = StreamProvider.Instance.GetStreamListById(Convert.ToInt32(Request.QueryString["StreamId1"]));
if (data.Count > 0)
{
var query = data.Select(result => new
{
StreamName = result.CourseStreamName,
}).First();
//Bind First StreamDatails based on firstStreamName
txtFirsteStream.Text = query.StreamName;
var sreamdata = StreamProvider.Instance.GetStreamListByStreamName(txtFirsteStream.Text.Trim());
if (data.Count > 0)
{
var streamquery = sreamdata.Select(result => new
{
result.CourseStreamName, result.CourseStreamHistory, result.CourseStreamDesc,
CourseStreamFuture = result.CourseSteamFuture, result.CourseStreamRelatedIndustry, result.CourseStreamCoreCompanies,
}).First();
lblStream1.Text = streamquery.CourseStreamName;
lblComFirstStreamName.Text = streamquery.CourseStreamName;
lblBriefHistory.Text = streamquery.CourseStreamHistory;
lblShortDesc.Text = streamquery.CourseStreamDesc;
lblFuruteScope.Text = streamquery.CourseStreamFuture;
lblReIndustry.Text = streamquery.CourseStreamRelatedIndustry;
lblCoreCompanies.Text = streamquery.CourseStreamCoreCompanies;
}
}
//Return StreamName based on Second StreamId2
var secondStreamdata = StreamProvider.Instance.GetStreamListById(Convert.ToInt32(Request.QueryString["StreamId2"]));
if (secondStreamdata.Count > 0)
{
var secondStreamquery = secondStreamdata.Select(result => new
{
StreamName = result.CourseStreamName,
}).First();
txtSecondCollegeName.Text = secondStreamquery.StreamName;
//Bind Second StreamDatails based on SecondStreamName
var secondStreamNamedata = StreamProvider.Instance.GetStreamListByStreamName(txtSecondCollegeName.Text.Trim());
if (secondStreamNamedata.Count > 0)
{
var selectSecondStreamNamedata = secondStreamNamedata.Select(result => new
{
result.CourseStreamName, result.CourseStreamHistory, result.CourseStreamDesc,
CourseStreamFuture = result.CourseSteamFuture, result.CourseStreamRelatedIndustry, result.CourseStreamCoreCompanies,
}).First();
lblStream2.Text = selectSecondStreamNamedata.CourseStreamName;
lblComSecondStreamName.Text = selectSecondStreamNamedata.CourseStreamName;
lblBriefHistory1.Text = selectSecondStreamNamedata.CourseStreamHistory;
lblShortDesc1.Text = selectSecondStreamNamedata.CourseStreamDesc;
lblFuruteScope1.Text = selectSecondStreamNamedata.CourseStreamFuture;
lblReIndustry1.Text = selectSecondStreamNamedata.CourseStreamRelatedIndustry;
lblCoreCompanies1.Text = selectSecondStreamNamedata.CourseStreamCoreCompanies;
}
}
}
