/// <summary>
/// Saves this instance.
/// </summary>
/// <returns></returns>
private bool Save()
{
bool result = false;
if (Verify())
{
using (var ctx = new EF6.RT2020Entities())
{
var objReason = ctx.PriceManagementReason.Find(_ReasonId);
if (objReason == null)
{
objReason = new EF6.PriceManagementReason();
objReason.ReasonId = Guid.NewGuid();
objReason.ReasonCode = txtCode.Text;
ctx.PriceManagementReason.Add(objReason);
}
objReason.ReasonName = txtName.Text;
objReason.ReasonName_Chs = txtNameAlt1.Text;
objReason.ReasonName_Cht = txtNameAlt2.Text;
ctx.SaveChanges();
result = true;
_ReasonId = objReason.ReasonId;
}
}
return(result);
}
private static string GetFormatedText(EF6.PriceManagementReason 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.PriceManagementReason object from the database using the given ReasonId
/// </summary>
/// <param name="reasonId">The primary key value</param>
/// <returns>A EF6.PriceManagementReason object</returns>
public static EF6.PriceManagementReason Get(Guid reasonId)
{
EF6.PriceManagementReason result = null;
using (var ctx = new EF6.RT2020Entities())
{
result = ctx.PriceManagementReason.Where(x => x.ReasonId == reasonId).AsNoTracking().FirstOrDefault();
}
return(result);
}
/// <summary>
/// Get a EF6.PriceManagementReason object from the database using the given QueryString
/// </summary>
/// <param name="reasonId">The primary key value</param>
/// <returns>A EF6.PriceManagementReason object</returns>
public static EF6.PriceManagementReason Get(string whereClause)
{
EF6.PriceManagementReason result = null;
using (var ctx = new EF6.RT2020Entities())
{
result = ctx.PriceManagementReason
.SqlQuery(string.Format("Select * from PriceManagementReason Where {0}", whereClause))
.AsNoTracking()
.FirstOrDefault();
}
return(result);
}
