public void Add(DevTaskItem d)
{
SqlItemList sqlItems = Get(d);
SetInsertIntoSql(SynnDataProvider.TableNames.DevTasks, sqlItems);
ExecuteSql();
}
public void Add(CashMonthlyData i)
{
SqlItemList sqlItems = Get(i);
SetInsertIntoSql(SynnDataProvider.TableNames.CashData, sqlItems);
ExecuteSql();
}
public void Upsert(string key, string serializedCredentials)
{
CheckKey(key);
var userCreds = GetUserCredentialsByKey(key);
if (!string.IsNullOrEmpty(userCreds))
{
SqlItemList where = new SqlItemList
{
new SqlItem("userid", key),
new SqlItem("appuserid", appUserId)
};
SqlItemList items = new SqlItemList {
new SqlItem("credentials", serializedCredentials)
};
SetUpdateSql(SynnDataProvider.TableNames.GoogleTokens, items, where);
}
else
{
SqlItemList items = new SqlItemList();
items.Add(new SqlItem("userid", key));
items.Add(new SqlItem("appuserid", appUserId));
items.Add(new SqlItem("credentials", serializedCredentials));
SetInsertIntoSql(SynnDataProvider.TableNames.GoogleTokens, items);
}
ExecuteSql();
}
public void Add(MoneyTransactionTemplate i)
{
SqlItemList sqlItems = Get(i);
SetInsertIntoSql(SynnDataProvider.TableNames.MoneyTransactionTemplatess, sqlItems);
ExecuteSql();
}
public void Add(MonthlyMoneyTransaction p)
{
SqlItemList sqlItems = GetFrom(p);
SetInsertIntoSql(SynnDataProvider.TableNames.MoneyTransactionItems, sqlItems);
ExecuteSql();
}
public void Add(QuickTask p)
{
SqlItemList sqlItems = Get(p);
SetInsertIntoSql(SynnDataProvider.TableNames.QuickTasks, sqlItems);
ExecuteSql();
}
public void Add(PermissionGroup g)
{
var sqlItems = new SqlItemList();
sqlItems.Add(new SqlItem("Name", g.Name));
SetInsertIntoSql(SynnDataProvider.TableNames.PermissionGroups, sqlItems);
ExecuteSql();
}
public void FinishMethod(string stepName)
{
var sqlItems = new SqlItemList();
sqlItems.Add(new SqlItem("Name", stepName));
sqlItems.Add(new SqlItem("Date", DateTime.Now));
SetInsertIntoSql(SynnDataProvider.TableNames.MigrationItems, sqlItems);
ExecuteSql();
}
public void Save(ShiftDayData i)
{
var sqlItems = new SqlItemList();
sqlItems.Add(new SqlItem("Date", i.Date));
sqlItems.Add(new SqlItem("DaylyShift", (int)i.DaylyShift));
SetInsertIntoSql(SynnDataProvider.TableNames.ShiftsData, sqlItems);
ExecuteSql();
}
public void Add(WeddingGuest g)
{
var sqlItems = new SqlItemList();
sqlItems.Add(new SqlItem("GuestName", g.Name));
sqlItems.Add(new SqlItem("Payment", g.Amount));
SetInsertIntoSql(SynnDataProvider.TableNames.WeddingItems, sqlItems);
ExecuteSql();
}
private static SqlItemList Get(MoneyMonthlyData p)
{
var sqlItems = new SqlItemList();
sqlItems.Add(new SqlItem("Date", p.Date));
sqlItems.Add(new SqlItem("TotalSpent", p.TotalSpent));
sqlItems.Add(new SqlItem("Active", p.Active));
return(sqlItems);
}
public void Add(GenericData u)
{
u.CreationDate = DateTime.Now;
u.UpdateDate = DateTime.Now;
SqlItemList sqlItems = Get(u);
SetInsertIntoSql(u.GetType().Name, sqlItems);
ExecuteSql();
}
public void FinishMethod(string stepName)
{
var sqlItems = new SqlItemList();
sqlItems.Add(new SqlItem("Name", stepName));
sqlItems.Add(new SqlItem("Date", DateTime.Now));
SetInsertIntoSql(TableName, sqlItems);
ExecuteSql();
}
public void Add(DictionarySearchParameters p)
{
var sqlItems = new SqlItemList();
sqlItems.Add(new SqlItem("dKey", p.Key));
sqlItems.Add(new SqlItem("Value", p.Value));
SetInsertIntoSql(SynnDataProvider.TableNames.UserDictionary, sqlItems);
ExecuteSql();
}
private SqlItemList Get(DevTaskItem u)
{
var sqlItems = new SqlItemList();
sqlItems.Add(new SqlItem("Description", u.Description));
sqlItems.Add(new SqlItem("Name", u.Name));
sqlItems.Add(new SqlItem("Status", u.Status));
return(sqlItems);
}
public void AddToUsbList(MusicItem m)
{
var sqlItems = new SqlItemList();
sqlItems.Add(new SqlItem("UserId", GlobalAppData.CurrentUser.Id));
sqlItems.Add(new SqlItem("ItemId", m.Id));
SetInsertIntoSql(xmConsts.UserUsbList, sqlItems);
ExecuteSql();
}
public void Update(LoggedUser u)
{
SqlItemList sqlItems = Get(u);
var wItems = new SqlItemList {
new SqlItem("Id", u.Id)
};
SetUpdateSql(SynnDataProvider.TableNames.Users, sqlItems, wItems);
ExecuteSql();
}
public void Add(string key, string value)
{
var sqlItems = new SqlItemList();
sqlItems.Add(new SqlItem("UserId", SynnDataProvider.DbProvider.CurrentUser.Id));
sqlItems.Add(new SqlItem("dKey", key));
sqlItems.Add(new SqlItem("Value", value));
SetInsertIntoSql(SynnDataProvider.TableNames.UserDictionary, sqlItems);
ExecuteSql();
}
public void AddLog(string message)
{
var sqlItems = new SqlItemList();
sqlItems.Add(new SqlItem("Date", DateTime.Now));
sqlItems.Add(new SqlItem("Trace", string.Empty));
sqlItems.Add(new SqlItem("Message", message));
SetInsertIntoSql(SynnDataProvider.TableNames.Log, sqlItems);
ExecuteSql();
}
private static SqlItemList GetFrom(MonthlyMoneyTransaction p)
{
var sqlItems = new SqlItemList();
sqlItems.Add(new SqlItem("Amount", p.Amount));
sqlItems.Add(new SqlItem("Closed", p.Closed));
sqlItems.Add(new SqlItem("Month", p.Month));
sqlItems.Add(new SqlItem("TemplateId", p.TemplateId));
return(sqlItems);
}
public void Add(CashMoneyItem p)
{
var sqlItems = new SqlItemList();
sqlItems.Add(new SqlItem("Date", p.Date));
sqlItems.Add(new SqlItem("TotalSpent", p.TotalSpent));
sqlItems.Add(new SqlItem("Description", p.Description));
SetInsertIntoSql(SynnDataProvider.TableNames.CashItems, sqlItems);
ExecuteSql();
}
private static SqlItemList Get(QuickTask p)
{
var sqlItems = new SqlItemList();
sqlItems.Add(new SqlItem("Name", p.Name));
sqlItems.Add(new SqlItem("Description", p.Description));
sqlItems.Add(new SqlItem("CreationDate", p.CreationDate));
sqlItems.Add(new SqlItem("Active", p.Active));
return(sqlItems);
}
public void Add(ThemeScript i)
{
var sqlItems = new SqlItemList();
sqlItems.Add(new SqlItem("CssAttribute", i.CssAttribute));
sqlItems.Add(new SqlItem("CssValue", i.CssValue));
sqlItems.Add(new SqlItem("ElementIdentifier", i.ElementIdentifier));
SetInsertIntoSql(SynnDataProvider.TableNames.ThemeItems, sqlItems);
ExecuteSql();
}
public void Update(DevTaskItem d)
{
SqlItemList sqlItems = Get(d);
var wItems = new SqlItemList {
new SqlItem("Id", d.Id)
};
SetUpdateSql(SynnDataProvider.TableNames.DevTasks, sqlItems, wItems);
ExecuteSql();
}
private void Update(ShopSearchParameters i)
{
SqlItemList sqlItems = GetUpdateParams(i);
SetUpdateSql(SynnDataProvider.TableNames.ShoppingItems, sqlItems, new SqlItemList {
new SqlItem {
FieldName = "Id", FieldValue = i.Id.Value
}
});
ExecuteSql();
}
public void Update(MonthlyMoneyTransaction i)
{
SqlItemList sqlItems = GetFrom(i);
SetUpdateSql(SynnDataProvider.TableNames.MoneyTransactionItems, sqlItems, new SqlItemList {
new SqlItem {
FieldName = "Id", FieldValue = i.Id
}
});
ExecuteSql();
}
public void Update(QuickTask item)
{
SqlItemList sqlItems = Get(item);
SetUpdateSql(SynnDataProvider.TableNames.QuickTasks, sqlItems, new SqlItemList {
new SqlItem {
FieldName = "Id", FieldValue = item.Id
}
});
ExecuteSql();
}
public void AddNewShopItem(ref ShopItem n)
{
var sqlItems = new SqlItemList();
sqlItems.Add(new SqlItem("Name", n.Name));
sqlItems.Add(new SqlItem("Active", true));
SetInsertIntoSql(SynnDataProvider.TableNames.ShoppingItems, sqlItems);
ExecuteSql();
n.Id = GetLastIdentityValue();
}
public string AddLog(Exception l)
{
var sqlItems = new SqlItemList();
sqlItems.Add(new SqlItem("Date", DateTime.Now));
sqlItems.Add(new SqlItem("Trace", l.StackTrace));
sqlItems.Add(new SqlItem("Message", l.Message));
SetInsertIntoSql(SynnDataProvider.TableNames.Log, sqlItems);
ExecuteSql();
return(GetMsSqlLastIdentityValue().ToString());
}
private static SqlItemList Get(LoggedUser u)
{
var sqlItems = new SqlItemList();
sqlItems.Add(new SqlItem("UserName", u.UserName));
sqlItems.Add(new SqlItem("Password", u.Password));
sqlItems.Add(new SqlItem("DisplayName", u.DisplayName));
sqlItems.Add(new SqlItem("EmailAdress", u.EmailAdress));
sqlItems.Add(new SqlItem("AllowedClientPagePermissions", XmlHelper.ToXml(u.AllowedClientPagePermissions)));
return(sqlItems);
}
