private void SetUpLookupData()
{
var lookupBO = new LookupBO();
ViewBag.CustomerType = lookupBO.GetList()
.Where(x => x.LookupCategory == "CustomerType")
.Select(x => new LookUpSelect
{
Value = x.LookupID,
Text = x.LookupDescription
}).ToList <LookUpSelect>();
ViewBag.BranchList = new BranchBO().GetList()
.Select(x => new Branch
{
BranchID = x.BranchID,
BranchName = x.BranchName
}).ToList <Branch>();
ViewBag.Country = new CountryBO().GetList().Select(x => new
{
Value = x.CountryCode,
Text = x.CountryName
}).ToList();
// ViewBag.Country = countryList;
}
public JsonResult SaveCategory(string ProductCategory)
{
Lookup lookUp = new Lookup();
lookUp.LookupCategory = UTILITY.CONFIG_LOOKUPCATEGORY_CATEGORY;
lookUp.Status = true;
lookUp.ISOCode = "";
lookUp.MappingCode = "";
lookUp.CreatedBy = USER_ID;
lookUp.CreatedOn = UTILITY.SINGAPORETIME;
lookUp.ModifiedBy = USER_ID;
lookUp.ModifiedOn = UTILITY.SINGAPORETIME;
lookUp.LookupDescription = "Desc";
lookUp.LookupCode = ProductCategory;
var lookUpBO = new LookupBO();
var result = lookUpBO.SaveLookup(lookUp);
ViewBag.ProductCategoryList = lookUpBO.GetList()
.Where(x => x.LookupCategory == "CategoryGroup")
.Select(x => new LookUpSelect
{
Value = x.LookupID,
Text = x.LookupCode
}).ToList <LookUpSelect>();
return(Json(ViewBag.ProductCategoryList, JsonRequestBehavior.AllowGet));
}
public JsonResult GetCurrency(Int16 Id)
{
var country = new BranchBO().GetList().Where(x => x.IsActive == true && x.BranchID == Id).FirstOrDefault();
var currencyCode = new LookupBO().GetList().Where(x => x.LookupCategory == "Currency" && x.MappingCode == country.BranchCode).FirstOrDefault();
return(Json(currencyCode == null ? "" : currencyCode.LookupCode, JsonRequestBehavior.AllowGet));
}
public ActionResult CategoryList()
{
var CategoryList = new LookupBO()
.GetList()
.Where(x => x.LookupCategory == UTILITY.CONFIG_LOOKUPCATEGORY_CATEGORY)
.ToList();
return(View(CategoryList));
}
public ActionResult SaveCategoryGroup(Lookup lookUp)
{
lookUp.LookupCategory = UTILITY.CONFIG_LOOKUPCATEGORY_CATEGORY;
lookUp.Status = true;
lookUp.ISOCode = "";
lookUp.MappingCode = "";
lookUp.CreatedBy = USER_ID;
lookUp.CreatedOn = UTILITY.SINGAPORETIME;
lookUp.ModifiedBy = USER_ID;
lookUp.ModifiedOn = UTILITY.SINGAPORETIME;
var lookUpBO = new LookupBO();
var result = lookUpBO.SaveLookup(lookUp);
return(RedirectToAction("CategoryList"));
}
private List <Revenue> GetList(short country, int year)
{
List <Revenue> RevenueList = dbContext.Revenues.Where(x => x.IsActive == true && x.Country == country && x.Year == year).ToList();
var productList = new EduProductBO().GetList().Where(x => x.IsActive == true).ToList();
ViewData["CountryData"] = new BranchBO().GetList().Where(x => x.IsActive == true).ToList();
ViewData["CurrencyList"] = new LookupBO().GetList().Where(x => x.LookupCategory == "Currency").ToList();
var countryrow = ((List <Branch>)ViewData["CountryData"]).Where(x => x.IsActive == true && x.BranchID == country).FirstOrDefault();
var currencyCode = ((List <Lookup>)ViewData["CurrencyList"]).Where(x => x.LookupCategory == "Currency" && x.MappingCode == countryrow.BranchCode).FirstOrDefault();
foreach (EduProduct ep in productList)
{
if (RevenueList.Where(x => x.Product == ep.Id).Count() == 0)
{
RevenueList.Add(new Revenue()
{
Product = ep.Id, ProductName = ep.ProductName, RevenueId = -1, CurrencyCode = currencyCode == null ? "" : currencyCode.LookupCode
});
}
}
return(RevenueList);
}
public ApiResponse <int> Update(LookupBO model)
{
return(new ApiResponse <int>(ResponseCode.Ok, Service.Update(model)));
}
public ApiResponse <int?> Create(LookupBO model)
{
return(new ApiResponse <int?>(ResponseCode.Ok, Service.Add(model)));
}
