public static Task <bool> DeleteAppSettingByIdAsync(int id)
{
return(Task.Run(() =>
{
using (var db = new ConfigCenterConnection())
{
var appSetting = db.AppSetting.SingleOrDefault(x => x.Id == id);
db.AppSetting.Remove(appSetting);
db.SaveChanges();
var app = db.App.FirstOrDefault(x => x.Id == appSetting.AppId);
if (app != null)
{
app.Version = DateTime.Now.ToString("yyyyMMddHHmmss");
db.Entry(app).State = EntityState.Modified;
db.SaveChanges();
//更新zookeeper的值
var path = ZooKeeperHelper.ZooKeeperRootNode + "/" + app.AppId;
if (!ZooKeeperHelper.Exists(path))
{
ZooKeeperHelper.Create(path, null);
}
ZooKeeperHelper.SetData(path, app.Version, -1);
}
return true;
}
}));
}
public static Task SaveAppSettingAsync(AppSettingDto appSettingDto)
{
return(Task.Run(() =>
{
using (var db = new ConfigCenterConnection())
{
var appSetting = Mapper.Map <AppSettingDto, AppSetting>(appSettingDto);
db.AppSetting.Add(appSetting);
db.SaveChanges();
var app = db.App.FirstOrDefault(x => x.Id == appSettingDto.AppId);
if (app != null)
{
app.Version = DateTime.Now.ToString("yyyyMMddHHmmss");
db.Entry(app).State = EntityState.Modified;
db.SaveChanges();
//更新zookeeper的值
var path = ZooKeeperHelper.ZooKeeperRootNode + "/" + app.AppId;
if (!ZooKeeperHelper.Exists(path))
{
ZooKeeperHelper.Create(path, null);
}
ZooKeeperHelper.SetData(path, app.Version, -1);
}
}
}));
}
public static Task <List <AppDto> > GetAppVersionsAsync(string[] appIds)
{
return(Task.Run(() =>
{
using (var db = new ConfigCenterConnection())
{
return Mapper.Map <List <App>, List <AppDto> >(db.App.Where(x => appIds.Contains(x.AppId)).ToList());
}
}));
}
public static Task <AppDto> GetAppVersionAsync(string appId)
{
return(Task.Run(() =>
{
using (var db = new ConfigCenterConnection())
{
return Mapper.Map <App, AppDto>(db.App.SingleOrDefault(x => x.AppId == appId));
}
}));
}
public static Task <AppSettingDto> GetAppSettingByIdAsync(int id)
{
return(Task.Run(() =>
{
using (var db = new ConfigCenterConnection())
{
return Mapper.Map <AppSetting, AppSettingDto>(db.AppSetting.SingleOrDefault(x => x.Id == id));
}
}));
}
public static Task <List <AppSettingDto> > GetAppSettingsAsync(int appId)
{
return(Task.Run(() =>
{
using (var db = new ConfigCenterConnection())
{
return Mapper.Map <List <AppSetting>, List <AppSettingDto> >(db.AppSetting.Where(x => x.AppId == appId).ToList());
}
}));
}
public static Task <bool> DeleteAppByIdAsync(int id)
{
return(Task.Run(() =>
{
using (var db = new ConfigCenterConnection())
{
db.App.Remove(db.App.SingleOrDefault(x => x.Id == id));
db.SaveChanges();
return true;
}
}));
}
public static Task SaveAppAsync(AppDto appDto)
{
return(Task.Run(() =>
{
using (var db = new ConfigCenterConnection())
{
var app = Mapper.Map <AppDto, App>(appDto);
db.App.Add(app);
db.SaveChanges();
}
}));
}
public static Task <AppDtos> GetAppsAsync(int pageIndex, int pageSize, string kword)
{
return(Task.Run(() =>
{
using (var db = new ConfigCenterConnection())
{
AppDtos appDtos = new AppDtos();
Expression <Func <App, bool> > where = x => x.AppId.Contains(kword);
var Items = db.App.Where(where).OrderBy(o => o.Id).Skip((pageIndex - 1) * pageSize).Take(pageSize).ToList();
appDtos.Items = Mapper.Map <List <App>, List <AppDto> >(Items);;
appDtos.TotalPage = db.App.Count(where);
return appDtos;
}
}));
}
