public JsonResult ChargeCategory(string id) { List <ChargeCategory> ChargeCategoryList = new List <ChargeCategory>(); Property a = new Property(); DataSet ds = new DataSet(); a.Condition1 = id; a.OnTable = "FetchChargeCategory"; ds = dl.FetchOPDCharge_sp(a); foreach (DataRow item in ds.Tables[0].Rows) { ChargeCategory m = new ChargeCategory(); m.ChargeCategoryId = item["ChargeCategoryId"].ToString(); m.Name = item["Name"].ToString(); ChargeCategoryList.Add(m); } return(Json(ChargeCategoryList, JsonRequestBehavior.AllowGet)); }
private static void Seed(ModelBuilder modelBuilder) { ChargeCategory marketPlaceCategory = new ChargeCategory() { Id = 1, Name = "MarketPlace" }; ChargeCategory serviciosCategory = new ChargeCategory() { Id = 2, Name = "Servicios" }; ChargeCategory externoCategory = new ChargeCategory() { Id = 3, Name = "Externo" }; modelBuilder.Entity <ChargeCategory>().HasData(marketPlaceCategory); modelBuilder.Entity <ChargeCategory>().HasData(serviciosCategory); modelBuilder.Entity <ChargeCategory>().HasData(externoCategory); modelBuilder.Entity <EventType>().HasData(new { Id = 1L, Name = "Clasificado", CategoryId = marketPlaceCategory.Id }); modelBuilder.Entity <EventType>().HasData(new { Id = 2L, Name = "Venta", CategoryId = marketPlaceCategory.Id }); modelBuilder.Entity <EventType>().HasData(new { Id = 3L, Name = "Envío", CategoryId = marketPlaceCategory.Id }); modelBuilder.Entity <EventType>().HasData(new { Id = 4L, Name = "Crédito", CategoryId = serviciosCategory.Id }); modelBuilder.Entity <EventType>().HasData(new { Id = 5L, Name = "Fidelidad", CategoryId = serviciosCategory.Id }); modelBuilder.Entity <EventType>().HasData(new { Id = 6L, Name = "Publicidad", CategoryId = serviciosCategory.Id }); modelBuilder.Entity <EventType>().HasData(new { Id = 7L, Name = "MercadoPago", CategoryId = externoCategory.Id }); modelBuilder.Entity <EventType>().HasData(new { Id = 8L, Name = "MercadoShop", CategoryId = externoCategory.Id }); modelBuilder.Entity <User>().HasData(new User() { Id = 1, Username = "******" }); modelBuilder.Entity <User>().HasData(new User() { Id = 2, Username = "******" }); }