private bool Save()
{
bool result = false;
using (var ctx = new EF6.RT2020Entities())
{
var item = ctx.SmartTag4Member_Options.Find(_OptionId);
if (item == null)
{
item = new EF6.SmartTag4Member_Options();
item.OptionId = Guid.NewGuid();
item.TagId = _SmartTagId;
item.OptionCode = txtOptionCode.Text;
ctx.SmartTag4Member_Options.Add(item);
}
item.OptionName = txtOptionName.Text;
item.OptionName_Alt1 = txtOptionNameAlt1.Text;
item.OptionName_Alt2 = txtOptionNameAlt2.Text;
ctx.SaveChanges();
_OptionId = item.OptionId;
result = true;
}
return(result);
}
private static string GetFormatedText(EF6.SmartTag4Member_Options target, string[] textField, string textFormatString)
{
for (int i = 0; i < textField.Length; i++)
{
PropertyInfo pi = target.GetType().GetProperty(textField[i]);
textFormatString = textFormatString.Replace("{" + i.ToString() + "}", pi != null ? pi.GetValue(target, null).ToString() : string.Empty);
}
return(textFormatString);
}
/// <summary>
/// Get a EF6.SmartTag4Member_Options object from the database using the given OptionId
/// </summary>
/// <param name="optionId">The primary key value</param>
/// <returns>A EF6.SmartTag4Member_Options object</returns>
public static EF6.SmartTag4Member_Options Get(Guid optionId)
{
EF6.SmartTag4Member_Options result = null;
using (var ctx = new EF6.RT2020Entities())
{
result = ctx.SmartTag4Member_Options.Where(x => x.OptionId == optionId).AsNoTracking().FirstOrDefault();
}
return(result);
}
/// <summary>
/// Get a EF6.SmartTag4Member_Options object from the database using the given QueryString
/// </summary>
/// <param name="optionId">The primary key value</param>
/// <returns>A EF6.SmartTag4Member_Options object</returns>
public static EF6.SmartTag4Member_Options Get(string whereClause)
{
EF6.SmartTag4Member_Options result = null;
using (var ctx = new EF6.RT2020Entities())
{
result = ctx.SmartTag4Member_Options
.SqlQuery(string.Format("Select * from SmartTag4Member_Options Where {0}", whereClause))
.AsNoTracking()
.FirstOrDefault();
}
return(result);
}
