public PartialViewResult GeneratSetting()
{
var model = new GeneralSettingViewModel();
model.SnapTolerance = _SettingBL.getSettingAsInt(DataAccess.Logic.SettingBL.SettingParameters.SnapTolorance, "SYSTEM");
return(PartialView(model));
}
public ActionResult Create(GeneralSettingViewModel model, string submit)
{
if (ModelState.IsValid)
{
//taruh logic Insert disini,
return(RedirectToAction("Index"));
}
ViewBag.FormName = "General Setting";
return(View(model));
}
public GeneralSettingViewModel UpdateGeneralSetting(GeneralSettingViewModel model)
{
var keys = this._SettingsRepository.Get();
keys.FirstOrDefault(k => k.Key == "FiscalYearEndDay").Value = model.FiscalYearEndDay;
keys.FirstOrDefault(k => k.Key == "FiscalYearEndMonth").Value = model.FiscalYearEndMonth;
keys.FirstOrDefault(k => k.Key == "FiscalYearStartDay").Value = model.FiscalYearStartDay;
keys.FirstOrDefault(k => k.Key == "FiscalYearStartMonth").Value = model.FiscalYearStartMonth;
keys.FirstOrDefault(k => k.Key == "IsInventoryRequiredSetting").Value = model.IsInventoryRequired.ToString();
this._SettingsRepository.Update(keys);
this._unitOfWork.Commit();
var result = this.GetGeneralSetting();
return(result);
}
public GeneralSettingViewModel GetGeneralSetting()
{
var keys = this._SettingsRepository.Get().ToList();
var result = new GeneralSettingViewModel
{
FiscalYearEndDay = keys.FirstOrDefault(k => k.Key == "FiscalYearEndDay").Value,
FiscalYearEndMonth = keys.FirstOrDefault(k => k.Key == "FiscalYearEndMonth").Value,
FiscalYearStartDay = keys.FirstOrDefault(k => k.Key == "FiscalYearStartDay").Value,
FiscalYearStartMonth = keys.FirstOrDefault(k => k.Key == "FiscalYearStartMonth").Value,
IsInventoryRequiredSetting = keys.FirstOrDefault(k => k.Key == "IsInventoryRequiredSetting").Value
};
if (string.IsNullOrEmpty(result.IsInventoryRequiredSetting) == false)
{
result.IsInventoryRequired = bool.Parse(result.IsInventoryRequiredSetting);
}
return(result);
}
public ViewResult Index(int?page, string filter, string cFilter, string sortKey, string sortDir, string cSortDir)
{
//DEFAULT
if (sortKey == null && sortDir == null)
{
sortKey = ViewBag.SortKey = "GSCode"; //yang harus diisi
sortDir = "ASC";
}
//Page
page = filter == null ? page : 1;
int pageNumber = page ?? 1;
int pageSize = 5; //yang harus diisi
//NEW OR CURRENT --> FILTER & SORT
filter = filter == null ? cFilter : filter;
sortDir = sortDir == null ? cSortDir : sortDir;
//QUERY
var query = from a in ent.Resolve <GeneralSetting>().AsQueryable() //yang harus dibikin
select new
{
GeneralSettingId = a.GeneralSettingId,
GSCode = a.GSCode,
GSKey = a.GSKey,
GSValue = a.GSValue
};
//CUSTOM FILTER
if (!string.IsNullOrEmpty(filter))
{
query = query.Where(x => x.GSCode.Contains(filter) || x.GSValue.Contains(filter)); //yang harus ditentukan
}
//ORDER BY & TOOGLE SORT DIRECTION
query = query.OrderByField(sortKey, sortDir == "ASC" ? true : false);
//GET PAGING
var pagingResult = query.ToPaging(pageNumber, pageSize);
//Map to VIEW MODEL
GeneralSettingViewPaging pagingList = new GeneralSettingViewPaging();
pagingList.Paging = pagingResult;
pagingList.Data = new List <GeneralSettingViewModel>();
foreach (var item in pagingResult)
{
GeneralSettingViewModel data = new GeneralSettingViewModel();
data.GeneralSettingId = item.GeneralSettingId;
data.GSCode = item.GSCode;
data.GSKey = item.GSKey;
data.GSValue = item.GSValue;
pagingList.Data.Add(data);
}
//Ga usah dirubah
ViewBag.cSortDir = sortDir; //buat jaga kondisi sort
ViewBag.SortDir = sortDir == "ASC" ? "DESC" : "ASC"; //buat bolak balikin (Toogle)
ViewBag.SortKey = sortKey;
ViewBag.cFilter = filter;
ViewBag.FormName = "General Setting";
return(View(pagingList));
}
