public VD_COURSE getDetailsCourse(string CourseID)
{
VD_COURSE course = new VD_COURSE();
_DBAccess = new DBController();
DataSet ds = new DataSet();
ds = _DBAccess.GetEntityDetails("WEB_VD_GET_DETAILS_COURSE", CourseID);
if (ds != null && ds.Tables.Count > 0)
{
if (ds.Tables[0] != null && ds.Tables[0].Rows.Count > 0)
{
course.ID = Convert.ToInt64(ds.Tables[0].Rows[0]["ID"]);
course.Name = Convert.ToString(ds.Tables[0].Rows[0]["Name"]);
course.Descriptions = Convert.ToString(ds.Tables[0].Rows[0]["Descriptions"]);
course.CourseType = Convert.ToInt32(ds.Tables[0].Rows[0]["CourseType"]);
course.CourseTypeName = Convert.ToString(ds.Tables[0].Rows[0]["CourseTypeName"]);
course.FromDate = Convert.ToDateTime(ds.Tables[0].Rows[0]["FromDate"]);
course.ToDate = Convert.ToDateTime(ds.Tables[0].Rows[0]["ToDate"]);
course.IsActive = Convert.ToBoolean(ds.Tables[0].Rows[0]["IsActive"]);
course.zIndex = Convert.ToInt32(ds.Tables[0].Rows[0]["zIndex"]);
}
}
return(course);
}
//Couser
public void insertUpdateCourse(string DataTitle, VD_COURSE course, ref string outputMsg, ref long outputResult)
{
SqlCommand command = this.DataManager.CreateCommand(DataTitle, CommandType.StoredProcedure);
DataManager.AddParameterWithValue(command, "@ID", course.ID);
DataManager.AddParameterWithValue(command, "@Name", course.Name);
DataManager.AddParameterWithValue(command, "@Descriptions", course.Descriptions);
DataManager.AddParameterWithValue(command, "@CourseType", course.CourseType);
DataManager.AddParameterWithValue(command, "@FromDate", course.FromDate);
DataManager.AddParameterWithValue(command, "@ToDate", course.ToDate);
DataManager.AddParameterWithValue(command, "@IsActive", course.IsActive);
DataManager.AddParameterWithValue(command, "@zIndex", course.zIndex);
SqlParameter paramOutputMsg = new SqlParameter("@outputMsg", SqlDbType.NVarChar, 1000);
paramOutputMsg.Direction = ParameterDirection.Output;
DataManager.AddParameter(command, paramOutputMsg);
SqlParameter paramOutputResult = new SqlParameter("@outputResult", SqlDbType.BigInt);
paramOutputResult.Direction = ParameterDirection.Output;
DataManager.AddParameter(command, paramOutputResult);
DataManager.ExecuteNonQuery(command);
if (paramOutputResult.Value != null)
{
outputResult = (long)paramOutputResult.Value;
outputMsg = paramOutputMsg.Value.ToString();
}
else
{
outputResult = -1;
outputMsg = string.Empty;
}
}
public ResultResponse insertUpdateCourse(VD_COURSE _course)
{
string _Msg = string.Empty;
long _Result = 0;
_rr = new ResultResponse();
_DBAccess = new DBController();
_DBAccess.insertUpdateCourse("WEB_VD_INSERT_UPDATE_COURSE", _course, ref _Msg, ref _Result);
_rr.Msg = _Msg;
_rr.Result = _Result;
return(_rr);
}
public void insertUpdateCourse(string DataTitle, VD_COURSE course, ref string outputMsg, ref long outputResult)
{
_DB.insertUpdateCourse(DataTitle, course, ref outputMsg, ref outputResult);
}
