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