/// <summary>
/// Gets the group id.
/// </summary>
/// <param name="groupCode">The group code.</param>
/// <returns></returns>
public static Guid GetGroupId(string groupCode)
{
Guid result = Guid.Empty;
using (var ctx = new EF6.RT2020Entities())
{
string query = "GroupCode = '" + groupCode + "'";
var item = ctx.MemberGroup.Where(x => x.GroupCode == groupCode).FirstOrDefault();
if (item == null)
{
item = new EF6.MemberGroup();
item.GroupId = Guid.NewGuid();
item.GroupCode = groupCode;
item.GroupName = groupCode;
item.GroupName_Chs = groupCode;
item.GroupName_Cht = groupCode;
ctx.MemberGroup.Add(item);
ctx.SaveChanges();
}
result = item.GroupId;
}
return(result);
}
private bool Save()
{
bool result = false;
using (var ctx = new EF6.RT2020Entities())
{
var item = ctx.MemberGroup.Find(_GroupId);
if (item == null)
{
item = new EF6.MemberGroup();
item.GroupId = new Guid();
item.GroupCode = txtGroupCode.Text;
ctx.MemberGroup.Add(item);
}
item.GroupName = txtGroupName.Text;
item.GroupName_Chs = txtGroupNameAlt1.Text;
item.GroupName_Cht = txtGroupNameAlt2.Text;
if ((Guid)cboParentGroup.SelectedValue != Guid.Empty)
{
item.ParentGroup = (Guid)cboParentGroup.SelectedValue;
}
ctx.SaveChanges();
result = true;
}
return(result);;
}
private static string GetFormatedText(EF6.MemberGroup 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.MemberGroup object from the database using the given GroupId
/// </summary>
/// <param name="groupId">The primary key value</param>
/// <returns>A EF6.MemberGroup object</returns>
public static EF6.MemberGroup Get(Guid groupId)
{
EF6.MemberGroup result = null;
using (var ctx = new EF6.RT2020Entities())
{
result = ctx.MemberGroup.Where(x => x.GroupId == groupId).AsNoTracking().FirstOrDefault();
}
return(result);
}
/// <summary>
/// Get a EF6.MemberGroup object from the database using the given QueryString
/// </summary>
/// <param name="groupId">The primary key value</param>
/// <returns>A EF6.MemberGroup object</returns>
public static EF6.MemberGroup Get(string whereClause)
{
EF6.MemberGroup result = null;
using (var ctx = new EF6.RT2020Entities())
{
result = ctx.MemberGroup
.SqlQuery(string.Format("Select * from MemberGroup Where {0}", whereClause))
.AsNoTracking()
.FirstOrDefault();
}
return(result);
}
