public async Task <ActionResult> WebRebatePlanListSelect(jQueryDataTableParamModel Params)
{
var list = (await GlobalVariableOpService.GetRebatePlanDetails()).lookupParameters;
var _filtered = new List <LookupParameters>();
if (!string.IsNullOrEmpty(Params.sSearch))
{
Params.sSearch = Params.sSearch.ToLower();
}
if (!string.IsNullOrEmpty(Params.sSearch))
{
_filtered = list.Where(p => (!string.IsNullOrEmpty(p.PlanId) ? p.PlanId : string.Empty).ToLower().Contains(Params.sSearch.ToLower()) ||
(!string.IsNullOrEmpty(p.Descp) ? p.Descp : string.Empty).ToLower().Contains(Params.sSearch.ToLower())).ToList();
_filtered = _filtered.Skip(Params.iDisplayStart).Take(Params.iDisplayLength).ToList();
}
else
{
_filtered = list.Skip(Params.iDisplayStart).Take(Params.iDisplayLength).ToList();
}
return(Json(new
{
sEcho = Params.sEcho,
iTotalRecords = list.Count(),
iTotalDisplayRecords = list.Count(),
aaData = _filtered.Select(p => new object[] { null, p.PlanId, p.Descp, p.type, p.EffectiveFrom, p.ExpiryDate, p.LastUpdated, p.PlanUserId, p.MinPurchaseAmt, p.SubSeqPurchaseAmt, p.SubSeqBillingAmt, p.BillingPlanLastUpdate, p.BillingPlanUserId })
}, JsonRequestBehavior.AllowGet));
}
public async Task <ActionResult> WebEventTypeListSelect(jQueryDataTableParamModel Params)
{
var _filtered = new List <LookupParameters>();
var list = (await GlobalVariableOpService.GetDetailEventTypes()).lookupParameters;
if (!string.IsNullOrEmpty(Params.sSearch))
{
Params.sSearch = Params.sSearch.ToLower();
}
if (!string.IsNullOrEmpty(Params.sSearch))
{
_filtered = list.Where(p => (!string.IsNullOrEmpty(p.EventTypeId) ? p.EventTypeId : string.Empty).ToLower().Contains(Params.sSearch.ToLower()) ||
(!string.IsNullOrEmpty(p.SelectedEventType) ? p.SelectedEventType : string.Empty).ToLower().Contains(Params.sSearch.ToLower()) ||
(!string.IsNullOrEmpty(p.ShortDescp) ? p.ShortDescp : string.Empty).ToLower().Contains(Params.sSearch.ToLower()) ||
(!string.IsNullOrEmpty(p.DetailedDescp) ? p.DetailedDescp : string.Empty).ToLower().Contains(Params.sSearch.ToLower())).ToList();
_filtered = _filtered.Skip(Params.iDisplayStart).Take(Params.iDisplayLength).ToList();
}
else
{
_filtered = list.Skip(Params.iDisplayStart).Take(Params.iDisplayLength).ToList();
}
return(Json(new
{
sEcho = Params.sEcho,
iTotalRecords = list.Count(),
iTotalDisplayRecords = list.Count(),
aaData = _filtered.Select(p => new object[] { p.EventTypeId, p.SelectedEventType, p.ShortDescp, p.DetailedDescp, p.SelectedStatus, p.LastUpdated, p.UpdatedBy })
}, JsonRequestBehavior.AllowGet));
}
public async Task <ActionResult> WebProdRefListSelect(jQueryDataTableParamModel Params)
{
var list = (await GlobalVariableOpService.GetProdRefs()).lookupParameters;
var _filtered = new List <LookupParameters>();
if (!string.IsNullOrEmpty(Params.sSearch))
{
Params.sSearch = Params.sSearch.ToLower();
}
if (!string.IsNullOrEmpty(Params.sSearch))
{
_filtered = list.Where(p => (!string.IsNullOrEmpty(p.Descp) ? p.Descp : string.Empty).ToLower().Contains(Params.sSearch.ToLower()) ||
(!string.IsNullOrEmpty(p.UnitPrice)?p.UnitPrice : string.Empty).ToLower().Contains(Params.sSearch.ToLower()) ||
(!string.IsNullOrEmpty(p.SelectedProductType) ? p.SelectedProductType : string.Empty).ToLower().Contains(Params.sSearch.ToLower()) ||
(!string.IsNullOrEmpty(p.SelectedProductCategory) ? p.SelectedProductCategory : string.Empty).ToLower().Contains(Params.sSearch.ToLower()) ||
(!string.IsNullOrEmpty(p.ProductName) ? p.ProductName: string.Empty).ToLower().Contains(Params.sSearch.ToLower()) ||
(!string.IsNullOrEmpty(p.ProductCode) ? p.ProductCode : string.Empty).ToLower().Contains(Params.sSearch.ToLower()) ||
(!string.IsNullOrEmpty(p.LastUpdated) ? p.LastUpdated : string.Empty).Contains(Params.sSearch.ToLower())).ToList();
_filtered = _filtered.Skip(Params.iDisplayStart).Take(Params.iDisplayLength).ToList();
}
else
{
_filtered = list.Skip(Params.iDisplayStart).Take(Params.iDisplayLength).ToList();
}
return(Json(new
{
sEcho = Params.sEcho,
iTotalRecords = list.Count(),
iTotalDisplayRecords = list.Count(),
aaData = _filtered.Select(p => new object[] { p.ProductCode, p.ProductName, p.Descp, p.SelectedProductCategory, p.SelectedProductType, p.UnitPrice, p.SelectedBillingPlan, p.LastUpdated })
}, JsonRequestBehavior.AllowGet));
}
public async Task <ActionResult> FillData(string Code, string id = null)
{
LookupParameters dropDowns;
switch (Code)
{
case "lp":
var Countries = await BaseService.GetRefLib("Country");
dropDowns = new LookupParameters
{
Countries = Countries,
States = Countries.Count() > 1? await BaseService.WebGetState(Countries[1].Value): null
};
var buttons = System.Web.HttpContext.Current.Session["CtrlAccessibility"];
return(Json(new { Model = new LookupParameters(), Selects = dropDowns, buttonPermissions = buttons }, JsonRequestBehavior.AllowGet));
case "pg":
dropDowns = new LookupParameters
{
ProductCategory = await BaseService.GetRefLib("ProdCategory"),
ProductType = await BaseService.GetRefLib("ProdType"),
BillingPlan = (await BaseService.WebGetPlan("0")),
ProductCodes = await BaseService.WebGetProduct(null, false)
};
var values = dropDowns.BillingPlan.Select(p => p.Value).ToList();
return(Json(new { Model = new LookupParameters(), Selects = dropDowns }, JsonRequestBehavior.AllowGet));
case "rb":
dropDowns = new LookupParameters
{
RebateType = await BaseService.GetRefLib("RebatePlanInd"),
};
return(Json(new { Model = new LookupParameters(), Selects = dropDowns }, JsonRequestBehavior.AllowGet));
case "ev":
dropDowns = new LookupParameters
{
EventType = await BaseService.GetRefLib("NtfEventType"),
Priority = await BaseService.GetRefLib("Priority"),
Status = await BaseService.GetRefLib("Status"),
Scope = await BaseService.GetRefLib("NtfEventOwner", null, "1", null),
Owner = await BaseService.GetRefLib("NtfEventOwner", null, "1", null),
Frequency = await BaseService.GetRefLib("NtfEventPeriodType"),
RefTo = await BaseService.GetEvtRefConf(id),
Languages = await BaseService.GetRefLib("Language"),
};
var result = (await GlobalVariableOpService.GetEventTypes(id)).lookupParameters;
return(Json(new { Model = result, Selects = dropDowns }, JsonRequestBehavior.AllowGet));
default:
return(Json(new { }, JsonRequestBehavior.AllowGet));
}
}
public async Task <ActionResult> WebUndefinedProdType(jQueryDataTableParamModel Params)
{
var list = (await GlobalVariableOpService.WebUndefinedProdType()).lookupParameters;
var _filtered = new List <LookupParameters>();
_filtered = list.Skip(Params.iDisplayStart).Take(Params.iDisplayLength).ToList();
return(Json(new
{
sEcho = Params.sEcho,
iTotalRecords = list.Count(),
iTotalDisplayRecords = list.Count(),
aaData = _filtered.Select(p => new object[] { p.ProductCode, p.ProductName, p.Descp, p.SelectedProductCategory, p.SelectedProductType, p.UnitPrice })
}, JsonRequestBehavior.AllowGet));
}
public async Task <ActionResult> WebEventTypeTemplateSelect(string EventTypeId)
{
var list = (await GlobalVariableOpService.GetEventTypeTemplates(EventTypeId)).TmplDisplays;
return(Json(list, JsonRequestBehavior.AllowGet));
}
public async Task <ActionResult> WebEventTypeMaint(LookupParameters Params)
{
var result = await GlobalVariableOpService.SaveEventTypeMaint(Params, GetUserId);
return(Json(result));
}
public async Task <ActionResult> WebEventTypeSelect(string EventTypeId)
{
var result = await GlobalVariableOpService.GetEventTypes(EventTypeId);
return(Json(new { Model = result }, JsonRequestBehavior.AllowGet));
}
public async Task <ActionResult> WebRebatePlanSelect(string PlanId)
{
var list = (await GlobalVariableOpService.GetRebatePlans(PlanId)).lookupParameters;
return(Json(list, JsonRequestBehavior.AllowGet));
}
public async Task <ActionResult> WebProdRefMaint(LookupParameters _Param)
{
var result = await GlobalVariableOpService.SaveProdRefMaint(_Param, GetUserId);
return(Json(result));
}
public async Task <ActionResult> WebProdGroupRefMaint(LookupParameters param)
{
var data = await GlobalVariableOpService.SaveProdGroupRefMaint(param, GetUserId);
return(Json(data));
}
public async Task <ActionResult> WebProdRefSelect(string ProdCd)
{
var data = (await GlobalVariableOpService.GetDetailProdRefs(ProdCd)).lookupParameters;
return(Json(data, JsonRequestBehavior.AllowGet));
}
public async Task <JsonResult> WebRefListSelect(string refType, jQueryDataTableParamModel Params)
{
ViewBag.CurrentStatus = refType;
var _filtered = new List <LookupParameters>();
var list = (await GlobalVariableOpService.GetRefList(refType)).lookupParameters;
if (!string.IsNullOrEmpty(Params.sSearch))
{
Params.sSearch = Params.sSearch.ToLower();
}
if (refType.ToLower() == "state")
{
if (!string.IsNullOrEmpty(Params.sSearch))
{
_filtered = list.Where(p => (!string.IsNullOrEmpty(p.Country) ? p.Country: string.Empty).ToLower().Contains(Params.sSearch.ToLower()) ||
(!string.IsNullOrEmpty(p.StateCode) ? p.StateCode : string.Empty).ToLower().Contains(Params.sSearch.ToLower()) ||
(!string.IsNullOrEmpty(p.StateName) ? p.StateName : string.Empty).ToLower().Contains(Params.sSearch.ToLower()) ||
(!string.IsNullOrEmpty(p.ParameterCode) ? p.ParameterCode : string.Empty).ToLower().Contains(Params.sSearch.ToLower())).ToList();
_filtered = _filtered.Skip(Params.iDisplayStart).Take(Params.iDisplayLength).ToList();
}
else
{
_filtered = list.Skip(Params.iDisplayStart).Take(Params.iDisplayLength).ToList();
}
return(Json(new
{
sEcho = Params.sEcho,
iTotalRecords = list.Count(),
iTotalDisplayRecords = list.Count(),
aaData = _filtered.Select(p => new object[] { p.Country, p.StateCode, p.StateName, p.ParameterCode })
}, JsonRequestBehavior.AllowGet));
}
else if (refType.ToLower() == "city")
{
if (!string.IsNullOrEmpty(Params.sSearch))
{
_filtered = list.Where(p => (!string.IsNullOrEmpty(p.Country) ? p.Country : string.Empty).ToLower().Contains(Params.sSearch.ToLower()) ||
(!string.IsNullOrEmpty(p.StateName) ? p.StateName : string.Empty).ToLower().Contains(Params.sSearch.ToLower()) ||
(!string.IsNullOrEmpty(p.ParameterCode) ? p.ParameterCode : string.Empty).ToLower().Contains(Params.sSearch.ToLower()) ||
(!string.IsNullOrEmpty(p.CityName) ? p.CityName : string.Empty).ToLower().Contains(Params.sSearch.ToLower())).ToList();
_filtered = _filtered.Skip(Params.iDisplayStart).Take(Params.iDisplayLength).ToList();
}
else
{
_filtered = list.Skip(Params.iDisplayStart).Take(Params.iDisplayLength).ToList();
}
return(Json(new
{
sEcho = Params.sEcho,
iTotalRecords = list.Count(),
iTotalDisplayRecords = list.Count(),
aaData = _filtered.Select(p => new object[] { p.Country, p.StateName, p.ParameterCode, p.CityName })
}, JsonRequestBehavior.AllowGet));
}
else
{
if (!string.IsNullOrEmpty(Params.sSearch))
{
_filtered = list.Where(p => (!string.IsNullOrEmpty(p.ParameterCode) ? p.ParameterCode : string.Empty).ToLower().Contains(Params.sSearch.ToLower()) ||
(!string.IsNullOrEmpty(p.ParameterDescp) ? p.ParameterDescp : string.Empty).ToLower().Contains(Params.sSearch.ToLower())).ToList();
_filtered = _filtered.Skip(Params.iDisplayStart).Take(Params.iDisplayLength).ToList();
}
else
{
_filtered = list.Skip(Params.iDisplayStart).Take(Params.iDisplayLength).ToList();
}
return(Json(new
{
sEcho = Params.sEcho,
iTotalRecords = list.Count(),
iTotalDisplayRecords = list.Count(),
aaData = _filtered.Select(p => new object[] { p.ParameterCode, p.ParameterDescp, null, null })
}, JsonRequestBehavior.AllowGet));
}
}
public async Task <ActionResult> WebRefMaint(LookupParameters globalVariable)
{
var result = await GlobalVariableOpService.SaveRefMaint(globalVariable, globalVariable.flag);
return(Json(result));
}
public async Task <ActionResult> WebRefSelect(string RefType, string RefCd, string RefNo, string RefId)
{
var result = (await GlobalVariableOpService.GetRefDetail(RefType, RefCd, RefNo, RefId)).lookupParameter;
return(Json(result, JsonRequestBehavior.AllowGet));
}
