public ActionResult NoticeDetails(int? idNotice)
{
NoticeDetailsViewModel ndvm = new NoticeDetailsViewModel();
if (idNotice.HasValue)
{
List<NoticeComment> comments = new List<NoticeComment>();
NoticeDetails nDet = new NoticeDetails();
DBHelper.GetNoticeById(idNotice.Value, ref nDet, ref comments );
ndvm.Notice = nDet;
ndvm.NoticeComments = comments;
}
return View(ndvm);
}
public static void GetNoticeById(int idNotice, ref NoticeDetails nDet, ref List<NoticeComment> comments)
{
nDet = new NoticeDetails();
using (eStanarContext context = new eStanarContext())
{
using (IDbConnection oaConnection = context.Database.Connection)
{
oaConnection.Open();
using (IDbCommand oaCommand = oaConnection.CreateCommand())
{
oaCommand.CommandType = CommandType.StoredProcedure;
oaCommand.CommandText = "GetNoticeById";
SqlParameter idNoticeParameter = new SqlParameter()
{
ParameterName = "@idNoticeIn",
DbType = System.Data.DbType.Int32,
Direction = System.Data.ParameterDirection.Input,
Value = idNotice
};
oaCommand.Parameters.Add(idNoticeParameter);
var objectContext = ((IObjectContextAdapter)context).ObjectContext;
using (IDataReader dataReader = oaCommand.ExecuteReader())
{
nDet = objectContext.Translate<NoticeDetails>(dataReader as DbDataReader).ToList().First();
dataReader.NextResult();
comments = objectContext.Translate<NoticeComment>(dataReader as DbDataReader).ToList();
}
}
}
}
}