public ActionResult Delete(int seq, string txtSearch, int hidPageSize)
{
BoardDispatch boardDispatch = new BoardDispatch();
int retVal = boardDispatch.DeleteBoard(seq);
return(RedirectToAction("Main", "Search", new { txtSearch = txtSearch, hidPageSize = hidPageSize }));
}
public ActionResult Modify(int seq, string txtLabel, string txtSubject, string txtComment, string txtSearch, int hidPageSize)
{
BoardDispatch boardDispatch = new BoardDispatch();
int returnVal = boardDispatch.UpdateBoard(seq, txtLabel, txtSubject, txtComment);
return(RedirectToAction("Detail", "Book", new { Seq = seq, txtSearch = txtSearch, hidPageSize = hidPageSize }));
}
public ActionResult Write(string txtLabel, string txtSubject, string txtComment)
{
BoardDispatch boardDispatch = new BoardDispatch();
int seq = boardDispatch.InsertBoard(txtLabel, txtSubject, txtComment);
return(RedirectToAction("Detail", "Book", new { Seq = seq, txtSearch = "", hidPageSize = 1 }));
}
public ActionResult Index()
{
BoardDispatch boardDispatch = new BoardDispatch();
//라벨리스트
DataSet dataLabel = boardDispatch.GetLabelList(6);
ViewBag.LabelList = dataLabel.Tables[0].Rows;
return(View());
}
private BoardT GetDetail(int seq, int option)
{
BoardDispatch boardDispatch = new BoardDispatch();
DataSet data = boardDispatch.GetBoardDetail(seq);
BoardT boardT = new BoardT
{
Comment = option == 1 ? data.Tables[0].Rows[0]["Comment"].ToString().Replace("\n", "<br/>") : data.Tables[0].Rows[0]["Comment"].ToString(),
LabelName = data.Tables[0].Rows[0]["LabelName"].ToString(),
RegDate = (DateTime)data.Tables[0].Rows[0]["RegDate"],
Seq = (int)data.Tables[0].Rows[0]["Seq"],
Subject = data.Tables[0].Rows[0]["Subject"].ToString()
};
return(boardT);
}
public ActionResult Main(string txtSearch, string hidPageSize)
{
string searchValue = txtSearch == null ? "" : txtSearch;
SearchOptionView searchOptionView = new SearchOptionView();
searchOptionView.TxtSearch = searchValue;
ViewBag.SearchOptionView = searchOptionView;
int pageSize = String.IsNullOrWhiteSpace(hidPageSize) ? 1 : Convert.ToInt32(hidPageSize);
int startCount = ((pageSize - 1) * PAGECOUNT) + 1;
int endCount = pageSize * PAGECOUNT;
BoardDispatch boardDispatch = new BoardDispatch();
DataSet data = boardDispatch.GetBoardList(searchValue, startCount, endCount);
List <BoardT> boardResults = new List <BoardT>();
foreach (DataRow row in data.Tables[0].Rows)
{
boardResults.Add(new BoardT
{
Comment = row["Comment"].ToString(),
LabelName = row["LabelName"].ToString(),
RegDate = (DateTime)row["RegDate"],
Seq = (int)row["Seq"],
Subject = row["Subject"].ToString()
});
}
//Paging 처리
int totalCount = Convert.ToInt32(data.Tables[1].Rows[0][0]);
var pager = new Pager(totalCount, pageSize, PAGECOUNT);
ViewBag.Pagination = pager;
//라벨리스트
DataSet dataLabel = boardDispatch.GetLabelList(15);
ViewBag.LabelList = dataLabel.Tables[0].Rows;
return(View("Main", new SearchResult {
SearchText = searchValue, IsValid = true, BoardTotalCount = totalCount, lstBoard = boardResults, ServerError = ""
}));
}
