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