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); } } }