public void Delete()
{
QueryLite query = new QueryLite(ConfigurationManager.ConnectionStrings["EbabobaConnectionString"].ConnectionString);
query.Add($"Delete from Schedule where ScheduleId = @ScheduleId");
query.AddParameter("@ScheduleId", this.ScheduleId);
query.Execute();
query.Clear();
}
public void Delete()
{
QueryLite query = new QueryLite(ConfigurationManager.ConnectionStrings["EbabobaConnectionString"].ConnectionString);
query.Add($"Delete from History where HistoryId = @HistoryId");
query.AddParameter("@HistoryId", this.HistoryId);
query.Execute();
query.Clear();
}
public void Delete()
{
QueryLite query = new QueryLite(ConfigurationManager.ConnectionStrings["EbabobaConnectionString"].ConnectionString);
query.Add($"Delete from TransactionType where TransactionTypeId = @TransactionTypeId");
query.AddParameter("@TransactionTypeId", this.TransactionTypeId);
query.Execute();
query.Clear();
}
public void Insert()
{
QueryLite query = new QueryLite(ConfigurationManager.ConnectionStrings["EbabobaConnectionString"].ConnectionString);
query.Add("insert into Card");
query.AddInsertValues(new List <string>()
{
this.Name, this.CardId, this.CurrencyId
});
query.Execute();
query.Clear();
}
public void Insert()
{
QueryLite query = new QueryLite(ConfigurationManager.ConnectionStrings["EbabobaConnectionString"].ConnectionString);
query.Add("insert into Schedule");
query.AddInsertValues(new List <string>()
{
this.CardId, this.Date, this.Frequency, this.Sum, this.TypeId, this.IsIncome
});
query.Execute();
query.Clear();
}
public void Insert()
{
QueryLite query = new QueryLite(ConfigurationManager.ConnectionStrings["EbabobaConnectionString"].ConnectionString);
query.Add("insert into TransactionType");
query.AddInsertValues(new List <string>()
{
this.Name, this.IsIncome
});
query.Execute();
query.Clear();
}
public void Update()
{
QueryLite query = new QueryLite(ConfigurationManager.ConnectionStrings["EbabobaConnectionString"].ConnectionString);
Dictionary <string, string> updates = new Dictionary <string, string>();
updates.Add("Name", this.Name);
query.Add("update cr");
query.AddUpdates(updates);
query.Add("from Currency cr where CurrencyId = @CurrencyId");
query.AddParameter("@CurrencyId", this.CurrencyId);
query.Execute();
query.Clear();
}
public void Update()
{
QueryLite query = new QueryLite(ConfigurationManager.ConnectionStrings["EbabobaConnectionString"].ConnectionString);
Dictionary <string, string> updates = new Dictionary <string, string>();
updates.Add("Name", this.Name);
updates.Add("IsIncome", this.IsIncome);
query.Add("update tt");
query.AddUpdates(updates);
query.Add("from TransactionType tt where TransactionTypeId = @TransactionTypeId");
query.AddParameter("@TransactionTypeId", this.TransactionTypeId);
query.Execute();
query.Clear();
}
public void Update()
{
QueryLite query = new QueryLite(ConfigurationManager.ConnectionStrings["EbabobaConnectionString"].ConnectionString);
Dictionary <string, string> updates = new Dictionary <string, string>();
updates.Add("CardId", this.CardId);
updates.Add("Date", this.Date);
updates.Add("IsIncome", this.IsIncome);
updates.Add("Sum", this.Sum);
updates.Add("TypeId", this.TypeId);
updates.Add("CurrencyId", this.CurrencyId);
query.Add("update hs");
query.AddUpdates(updates);
query.Add("from History hs where HistoryId = @HistoryId");
query.AddParameter("@HistoryId", this.HistoryId);
query.Execute();
query.Clear();
}
public void Update()
{
QueryLite query = new QueryLite(ConfigurationManager.ConnectionStrings["EbabobaConnectionString"].ConnectionString);
Dictionary <string, string> updates = new Dictionary <string, string>();
updates.Add("CardId", this.CardId);
updates.Add("Date", this.Date);
updates.Add("Frequency", this.Frequency);
updates.Add("IsIncome", this.IsIncome);
updates.Add("Sum", this.Sum);
updates.Add("TypeId", this.TypeId);
query.Add("update cr");
query.AddUpdates(updates);
query.Add("from Schedule cr where ScheduleId = @ScheduleId");
query.AddParameter("@ScheduleId", this.ScheduleId);
query.Execute();
query.Clear();
}