public ActionResult Create(State state)
{
if (ModelState.IsValid)
{
var dao = new StateDao();
var getState = dao.getByName(state.StateName);
//Check if State name exits in database
if (getState != null)
{
ModelState.AddModelError("StateName", "State name exists in database.");
return(View(state));
}
var entity = new State();
entity.StateName = state.StateName;
entity.StateDescription = state.StateDescription;
long id = dao.create(entity);
if (id > 0)
{
ViewBag.CreateStateSuccessMessage = "Create " + state.StateName + " successful";
}
else
{
ViewBag.CreateStateErrorMessage = "Create " + state.StateName + " failed";
}
}
return(View(state));
}
public void should_get_the_state_associated_with_the_name()
{
var dao = new StateDao();
dao.SetState("my-state-name", "my-state");
Assert.That(dao.StateByName("my-state-name"), Is.EqualTo("my-state"));
}
private void GetOrderDataSet()
{
try
{
using (PersistentManager pm = new PersistentManager())
{
StateDao stateDao = new StateDao();
DataTable FindStateQueryType = stateDao.FindOrderListTable();
StateQueryDialog stateQueryDialog = new StateQueryDialog(FindStateQueryType);
if (stateQueryDialog.ShowDialog() == DialogResult.OK)
{
string stateCode = "";
string indexNo = "";
string viewName = "";
stateCode = stateQueryDialog.SelectedQueryType.ToString();
indexNo = stateDao.FindOrderIndexNoByStateCode(stateCode).Rows[0]["ROW_INDEX"].ToString();
viewName = stateDao.FindOrderIndexNoByStateCode(stateCode).Rows[0]["VIEWNAME"].ToString();
bsMain.DataSource = stateDao.FindOrderStateByIndexNo(indexNo, viewName);
}
}
}
catch (Exception ex)
{
Logger.Error(ex.Message);
}
}
public void should_convert_state_to_int() {
var dao = new StateDao();
dao.SetState("my-state-name", "50");
int state;
var ok = dao.StateByName("my-state-name", out state);
Assert.That(ok, Is.True);
Assert.That(state, Is.EqualTo(50));
}
public void should_convert_state_to_datetime()
{
var dao = new StateDao();
dao.SetState("my-state-name", "2013-10-01");
DateTime state;
var ok = dao.StateByName("my-state-name", out state);
Assert.That(ok, Is.True);
Assert.That(state, Is.EqualTo(new DateTime(2013, 10, 1)));
}
public void should_convert_state_to_datetime()
{
var dao = new StateDao();
dao.SetState("my-state-name", "2013-10-01");
DateTime state;
var ok = dao.StateByName("my-state-name", out state);
Assert.That(ok, Is.True);
Assert.That(state, Is.EqualTo(new DateTime(2013, 10, 1)));
}
public void should_convert_state_to_int()
{
var dao = new StateDao();
dao.SetState("my-state-name", "50");
int state;
var ok = dao.StateByName("my-state-name", out state);
Assert.That(ok, Is.True);
Assert.That(state, Is.EqualTo(50));
}
public ActionResult Index(string searchString, string sorting = "decs",
int searchPageSize = 10, int searchPage = 1)
{
ViewBag.SearchString = searchString;
if (sorting.Equals("asc"))
{
sorting = "decs";
}
else
{
sorting = "asc";
}
ViewBag.Sorting = sorting;
ViewBag.SearchStatePage = searchPage;
ViewBag.SearchStatePageSize = searchPageSize;
var dao = new StateDao();
var model = dao.listAllPaging(searchString, sorting, searchPageSize, searchPage);
var totalRows = dao.totalRows(searchString);
if (totalRows == 0)
{
ViewBag.SearchStatePageDisplay = 0;
}
else
{
ViewBag.SearchStatePageDisplay = (searchPage - 1) * searchPageSize + 1;
}
var pageRange = searchPage * searchPageSize;
if (totalRows > (pageRange))
{
ViewBag.SearchStatePageSizeDisplay = pageRange;
}
else
{
ViewBag.SearchStatePageSizeDisplay = totalRows;
}
ViewBag.TotalStateDisplay = totalRows;
return(View(model));
}
/// <summary>
///
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public ActionResult Edit(long?id)
{
if (id == null)
{
Response.StatusCode = 404;
return(View("NotFound"));
}
else
{
var dao = new StateDao();
var state = dao.getById(id);
if (state == null)
{
Response.StatusCode = 404;
return(View("NotFound"));
}
else
{
return(View(state));
}
}
}
public ActionResult Edit(State state)
{
if (ModelState.IsValid)
{
var dao = new StateDao();
var checkExistState = dao.getById(state.Id);
if (checkExistState == null)
{
Response.StatusCode = 404;
return(View("NotFound"));
}
if (!state.StateName.Equals(checkExistState.StateName))
{
var stateDetail = dao.getByName(state.StateName);
if (stateDetail != null)
{
ModelState.AddModelError("StateName", "State " + state.StateName + " exists in database.");
return(View(state));
}
}
var entity = new State();
entity.Id = state.Id;
entity.StateName = state.StateName;
entity.StateDescription = state.StateDescription;
bool update = dao.update(entity);
if (update)
{
ViewBag.EditStateSuccessMessage = "Update state successful";
}
else
{
ViewBag.EditStateErrorMessage = "Update state failed";
}
}
return(View(state));
}
/// <summary>
///
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public ActionResult Detail(long?id)
{
var dao = new StateDao();
//check if id = null
if (id == null)
{
Response.StatusCode = 404;
return(View("NotFound"));
}
//check if id does not exist in database
if (dao.getById(id) == null)
{
Response.StatusCode = 404;
return(View("NotFound"));
}
else
{
return(View(dao.getById(id)));
}
}
public ActionResult Delete(long?id)
{
if (id == null)
{
Response.StatusCode = 404;
return(View("NotFound"));
}
else
{
var dao = new StateDao();
var state = dao.getById(id);
if (state == null)
{
Response.StatusCode = 404;
return(View("NotFound"));
}
else
{
new StateDao().delete(id);
return(RedirectToAction("Index"));
}
}
}
public Service(string tweetsFilepath)
{
stateDao = new StateDao(tweetsFilepath);
}
public void should_throw_no_result_exception_when_state_is_not_found()
{
var dao = new StateDao();
Assert.Throws <NoResultException>(() => dao.StateByName("missing-state"));
}
public void should_get_the_state_associated_with_the_name() {
var dao = new StateDao();
dao.SetState("my-state-name", "my-state");
Assert.That(dao.StateByName("my-state-name"), Is.EqualTo("my-state"));
}
public void should_throw_no_result_exception_when_state_is_not_found() {
var dao = new StateDao();
Assert.Throws<NoResultException>(() => dao.StateByName("missing-state"));
}
public States MapToEntity(StateDao s)
{
var mapper = StateMapper.CreateMapper();
return(mapper.Map <States>(s));
}
