public static mdlTenant Retrieve(int id) { using (apiDBContext context = new apiDBContext()) { return(context.Tenant.Where(t => t.Id == id).Select(t => new mdlTenant() { Id = t.Id, Email = t.Email, Username = t.Username, Type = t.TypeNavigation.Name }).FirstOrDefault()); } }
public static List <mdlConfig> Retrieve(int id = 0) { using (apiDBContext context = new apiDBContext()) { return(context.Config.Where(c => id == 0 || c.Id == id).Select(c => new mdlConfig() { Id = c.Id, ConfigName = c.ConfigName, ConfigValue = c.ConfigValue }).ToList <mdlConfig>()); } }
public static mdlConfig Delete(int configId) { using (apiDBContext context = new apiDBContext()) { Config dbConfig = context.Config.Where(c => c.Id == configId).FirstOrDefault(); context.Config.Remove(dbConfig); context.SaveChanges(); return(new mdlConfig() { Id = configId, ConfigName = dbConfig.ConfigName, ConfigValue = dbConfig.ConfigValue }); } }
public static mdlConfig Update(mdlConfig config) { using (apiDBContext context = new apiDBContext()) { Config dbConfig = context.Config.Where(c => c.Id == config.Id).FirstOrDefault(); dbConfig.ConfigName = config.ConfigName; dbConfig.ConfigValue = config.ConfigValue; Config entityConfig = context.Config.Update(dbConfig).Entity; context.SaveChanges(); return(new mdlConfig() { Id = entityConfig.Id, ConfigName = entityConfig.ConfigName, ConfigValue = entityConfig.ConfigValue }); } }
public static mdlConfig Create(mdlConfig config) { using (apiDBContext context = new apiDBContext()) { Config dbConfig = context.Config.Add(new Config() { ConfigName = config.ConfigName, ConfigValue = config.ConfigValue }).Entity; context.SaveChanges(); return(new mdlConfig() { Id = dbConfig.Id, ConfigName = dbConfig.ConfigName, ConfigValue = dbConfig.ConfigValue }); } }