private List <CourseMasterProperty> BindCourseHome(DataTable dataTable)
{
var courseMasterObjectList = new List <CourseMasterProperty>();
try
{
if (dataTable != null && dataTable.Rows.Count > 0)
{
for (var j = 0; j < dataTable.Rows.Count; j++)
{
var objCoursemaster = new CourseMasterProperty
{
CourseId = (dataTable.Rows[j]["AjCourseId"] is DBNull) ? 0 :
Convert.ToInt32(dataTable.Rows[j]["AjCourseId"]),
CourseName =
(dataTable.Rows[j]["AjCourseName"] is DBNull) ? null :
Convert.ToString(dataTable.Rows[j]["AjCourseName"])
};
courseMasterObjectList.Add(objCoursemaster);
}
}
}
catch (Exception ex)
{
var err = ex.Message;
if (ex.InnerException != null)
{
err = err + " :: Inner Exception :- " + ex.ToString();
}
const string addInfo = "Error while executing BindCourseMasterObject in Course.cs :: -> ";
var objPub = new ClsExceptionPublisher();
objPub.Publish(err, addInfo);
}
return(courseMasterObjectList);
}
private List <CourseMasterProperty> BindCourseMasterObject(DataTable dataTable)
{
var courseMasterObjectList = new List <CourseMasterProperty>();
try
{
if (dataTable != null && dataTable.Rows.Count > 0)
{
for (var j = 0; j < dataTable.Rows.Count; j++)
{
var objCoursemaster = new CourseMasterProperty
{
CourseCategoryId =
(dataTable.Rows[j]["AjCourseCategoryId"] is DBNull) ? 0 :
Convert.ToInt32(dataTable.Rows[j]["AjCourseCategoryId"]),
CourseCategoryName =
(dataTable.Rows[j]["AjCourseCategoryName"] is DBNull) ? null :
Convert.ToString(dataTable.Rows[j]["AjCourseCategoryName"]),
CourseEligibiltyId =
(dataTable.Rows[j]["AjCollegeCourseEligibiltyId"] is DBNull) ? 0 :
Convert.ToInt32(dataTable.Rows[j]["AjCollegeCourseEligibiltyId"]),
CourseEligibityName =
(dataTable.Rows[j]["AjCollegeCourseEligibiltyName"] is DBNull) ? null :
Convert.ToString(dataTable.Rows[j]["AjCollegeCourseEligibiltyName"]),
CourseId =
(dataTable.Rows[j]["AjCourseId"] is DBNull) ? 0 :
Convert.ToInt32(dataTable.Rows[j]["AjCourseId"]),
CourseName =
(dataTable.Rows[j]["AjCourseName"] is DBNull) ? null :
Convert.ToString(dataTable.Rows[j]["AjCourseName"]),
CoursePopularName =
(dataTable.Rows[j]["AjCoursepopularName"] is DBNull) ? null :
Convert.ToString(dataTable.Rows[j]["AjCoursepopularName"]),
CourseShortName =
(dataTable.Rows[j]["AjCourseShortName"] is DBNull) ? null :
Convert.ToString(dataTable.Rows[j]["AjCourseShortName"]),
CourseMetaDesc =
(dataTable.Rows[j]["AjCourseMetaDesc"] is DBNull) ? null :
Convert.ToString(dataTable.Rows[j]["AjCourseMetaDesc"]),
CourseMetaTag =
(dataTable.Rows[j]["AjCourseMetaTag"] is DBNull) ? null :
Convert.ToString(dataTable.Rows[j]["AjCourseMetaTag"]),
CourseStatus =
(dataTable.Rows[j]["AjCourseStatus"] is DBNull) ? false :
Convert.ToBoolean(dataTable.Rows[j]["AjCourseStatus"]),
CourseTitle =
(dataTable.Rows[j]["AjCourseTitle"] is DBNull) ? null :
Convert.ToString(dataTable.Rows[j]["AjCourseTitle"]),
CourseUrl =
(dataTable.Rows[j]["AjCourseUrl"] is DBNull) ? null :
Convert.ToString(dataTable.Rows[j]["AjCourseUrl"]),
CourseDesc =
(dataTable.Rows[j]["AjCourseDesc"] is DBNull) ? null :
Convert.ToString(dataTable.Rows[j]["AjCourseDesc"]),
CourseImage =
(dataTable.Rows[j]["AjCourseImage"] is DBNull) ? null :
Convert.ToString(dataTable.Rows[j]["AjCourseImage"]),
HelpLineNo =
(dataTable.Rows[j]["AjHelpLineNo"] is DBNull) ? null :
Convert.ToString(dataTable.Rows[j]["AjHelpLineNo"]),
IsBookSeatVisible =
(dataTable.Rows[j]["AjIsBookSeatVisible"] is DBNull) ? false :
Convert.ToBoolean(dataTable.Rows[j]["AjIsBookSeatVisible"])
};
courseMasterObjectList.Add(objCoursemaster);
}
}
}
catch (Exception ex)
{
var err = ex.Message;
if (ex.InnerException != null)
{
err = err + " :: Inner Exception :- " + ex.ToString();
}
const string addInfo = "Error while executing BindCourseMasterObject in Course.cs :: -> ";
var objPub = new ClsExceptionPublisher();
objPub.Publish(err, addInfo);
}
return(courseMasterObjectList);
}
