public async Task <JsonResult> Create(FormCollection fc)
{
Overtimerate o = OvertimerateHelper.GetObject(null, fc);
Dictionary <string, object> err = null;
ISession se = NHibernateHelper.CurrentSession;
err = o.IsValid(se);
if (err == null)
{
await Task.Run(() =>
{
using (ITransaction tx = se.BeginTransaction())
{
se.SaveOrUpdate(o);
tx.Commit();
}
});
return(Json(new Dictionary <string, object>
{
{ "success", 1 },
{ "message", "Overtime Rate was successfully added." }
},
JsonRequestBehavior.AllowGet));
}
else
{
return(Json(err, JsonRequestBehavior.AllowGet));
}
}
public async Task <ActionResult> List()
{
int year = CommonHelper.GetValue <int>(Request["year"], 0);
int pgnum = CommonHelper.GetValue <int>(Request["pgnum"], 1);
int pgsize = CommonHelper.GetValue <int>(Request["pgsize"], 0);
string sortcolumn = CommonHelper.GetValue(Request["sortcolumn"], OvertimerateHelper.DEFAULT_SORT_COLUMN);
string sortdir = CommonHelper.GetValue(Request["sortdir"], OvertimerateHelper.DEFAULT_SORT_DIR);
Sort sort = new Sort(sortcolumn, sortdir);
Dictionary <string, object> filters = new Dictionary <string, object>
{
{ "year", year }
};
ListModel <Overtimerate> l = null;
if (year == 0)
{
l = await OvertimerateHelper.GetAll(pgnum, pgsize, sort);
}
else
{
l = await OvertimerateHelper.GetFilterBy(filters, pgnum, pgsize, sort);
}
return(View("_list", l));
}
//
// GET: /Admin/OvertimeRate/
public async Task <ActionResult> Index()
{
ListModel <Overtimerate> l = null;
l = await OvertimerateHelper.GetAll();
return(View(l));
}
public async Task <JsonResult> Delete(FormCollection fc)
{
int year = CommonHelper.GetValue <int>(Request["year"], 0);
int pgnum = CommonHelper.GetValue <int>(Request["pgnum"], 1);
int pgsize = CommonHelper.GetValue <int>(Request["pgsize"], 0);
string ids = fc.Get("id[]");
string[] idlist = ids.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries);
string itemscount = null;
Dictionary <string, object> filters = new Dictionary <string, object>
{
{ "year", year }
};
ISession se = NHibernateHelper.CurrentSession;
await Task.Run(() =>
{
using (ITransaction tx = se.BeginTransaction())
{
se.CreateQuery("delete from Overtimerate where id in (:idlist)")
.SetParameterList("idlist", idlist)
.ExecuteUpdate();
tx.Commit();
}
});
if (year == 0)
{
itemscount = await OvertimerateHelper.GetItemMessage(null, pgnum, pgsize);
}
else
{
itemscount = await OvertimerateHelper.GetItemMessage(filters, pgnum, pgsize);
}
return(Json(new Dictionary <string, object>
{
{ "success", 1 },
{ "itemscount", itemscount },
{ "message", string.Format("{0} Overtime rate(s) was successfully deleted.", idlist.Length) }
},
JsonRequestBehavior.AllowGet));
}