public static void AddUserChart(int chartId, int userId, int officeId, string defaultFilterTypes)
{
using (var db = PocoDatabase.DbConnection(DbConfiguration.LtcDashboard))
{
var model = db.Fetch <gUserCharts>($"SELECT * FROM user_charts WHERE User_Id = {userId} AND Chart_Id={chartId}").FirstOrDefault();
if (model == null)
{
gUserCharts userChart = new gUserCharts();
userChart.User_Id = userId;
userChart.Chart_Id = chartId;
userChart.FilterTypes = defaultFilterTypes;
db.Save(userChart);
}
}
}
public static void UpdateCardFilterTypes(int chartId, string filterTypes, int officeId)
{
using (var db = PocoDatabase.DbConnection(DbConfiguration.LtcDashboard))
{
var model = db.Fetch <gUserCharts>($"SELECT * FROM user_charts WHERE Chart_Id={chartId}").FirstOrDefault();
if (model != null)
{
gUserCharts userChart = new gUserCharts();
userChart.User_Id = model.User_Id;
userChart.ID = model.ID;
userChart.Chart_Id = model.Chart_Id;
userChart.FilterTypes = filterTypes;
db.Save(userChart);
}
}
}
