private bool Save()
{
bool result = false;
using (var ctx = new EF6.RT2020Entities())
{
var jt = ctx.JobTitle.Find(_JobTitleId);
if (jt == null)
{
jt = new EF6.JobTitle();
jt.JobTitleId = Guid.NewGuid();
jt.JobTitleCode = txtJobTitleCode.Text;
ctx.JobTitle.Add(jt);
_JobTitleId = jt.JobTitleId;
}
jt.JobTitleName = txtJobTitleName.Text;
jt.JobTitleName_Chs = txtJobTitleNameAlt1.Text;
jt.JobTitleName_Cht = txtJobTitleNameAlt2.Text;
if ((Guid)cboParentJobTitle.SelectedValue != Guid.Empty)
{
jt.ParentJobTitle = (Guid)cboParentJobTitle.SelectedValue;
}
ctx.SaveChanges();
result = true;
}
return(result);
}
private static string GetFormatedText(EF6.JobTitle 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.JobTitle object from the database using the given JobTitleId
/// </summary>
/// <param name="jobTitleId">The primary key value</param>
/// <returns>A EF6.JobTitle object</returns>
public static EF6.JobTitle Get(Guid jobTitleId)
{
EF6.JobTitle result = null;
using (var ctx = new EF6.RT2020Entities())
{
result = ctx.JobTitle.Where(x => x.JobTitleId == jobTitleId).AsNoTracking().FirstOrDefault();
}
return(result);
}
/// <summary>
/// Get a EF6.JobTitle object from the database using the given QueryString
/// </summary>
/// <param name="jobTitleId">The primary key value</param>
/// <returns>A EF6.JobTitle object</returns>
public static EF6.JobTitle Get(string whereClause)
{
EF6.JobTitle result = null;
using (var ctx = new EF6.RT2020Entities())
{
result = ctx.JobTitle
.SqlQuery(string.Format("Select * from JobTitle Where {0}", whereClause))
.AsNoTracking()
.FirstOrDefault();
}
return(result);
}
