public void LoadFromName(string name)
{
if (string.IsNullOrEmpty(name))
{
return;
}
string sql = SQLScripts.GET_ACCOUNT_FROM_NAME;
sql = sql.Replace("[NAME]", name);
DataSet ds = SQLHelper.ExecuteDataSet(sql, "Account");
DB_Account acc = ConversionHelper.Convert <DB_Account>(ds).Cast <DB_Account>().FirstOrDefault();
if (acc != null)
{
this.ID = acc.ID;
this.Name = acc.Name;
this.Note = acc.Note;
this.IsOffBudget = acc.IsOffBudget;
this.IsActive = acc.IsActive;
this.Type = acc.Type;
}
}
public void Load(string id)
{
if (string.IsNullOrEmpty(id))
{
return;
}
string sql = SQLScripts.GET_SELECTED_ACCOUNT;
sql = sql.Replace("[ID]", id);
DataSet ds = SQLHelper.ExecuteDataSet(sql, "Account");
DB_Account acc = ConversionHelper.Convert <DB_Account>(ds).Cast <DB_Account>().FirstOrDefault();
if (acc != null)
{
this.ID = acc.ID;
this.Name = acc.Name;
this.Note = acc.Note;
this.IsOffBudget = acc.IsOffBudget;
this.IsActive = acc.IsActive;
this.Type = acc.Type;
}
}
