/// <summary> /// Gets the class id. /// </summary> /// <param name="classCode">The class code.</param> /// <returns></returns> public static Guid GetClassId(string classCode) { Guid result = Guid.Empty; using (var ctx = new EF6.RT2020Entities()) { string query = "ClassCode = '" + classCode + "'"; var item = ctx.MemberClass.Where(x => x.ClassCode == classCode).FirstOrDefault(); if (item == null) { item = new EF6.MemberClass(); item.ClassId = System.Guid.NewGuid(); item.ClassCode = classCode; item.ClassName = classCode; item.ClassName_Chs = classCode; item.ClassName_Cht = classCode; ctx.MemberClass.Add(item); ctx.SaveChanges(); } return(item.ClassId); } return(result); }
private bool Save() { bool result = false; using (var ctx = new EF6.RT2020Entities()) { var item = ctx.MemberClass.Find(_ClassId); if (item == null) { item = new EF6.MemberClass(); item.ClassId = new Guid(); item.ClassCode = txtClassCode.Text; ctx.MemberClass.Add(item); } item.ClassName = txtClassName.Text; item.ClassName_Chs = txtClassNameAlt1.Text; item.ClassName_Cht = txtClassNameAlt2.Text; item.ParentClass = (cboParentClass.SelectedValue == null) ? Guid.Empty : new Guid(cboParentClass.SelectedValue.ToString()); ctx.SaveChanges(); result = true; } return(result); }
private static string GetFormatedText(EF6.MemberClass 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.MemberClass object from the database using the given ClassId /// </summary> /// <param name="ClassId">The primary key value</param> /// <returns>A EF6.MemberClass object</returns> public static EF6.MemberClass Get(Guid ClassId) { EF6.MemberClass result = null; using (var ctx = new EF6.RT2020Entities()) { result = ctx.MemberClass.Where(x => x.ClassId == ClassId).AsNoTracking().FirstOrDefault(); } return(result); }
/// <summary> /// Get a EF6.MemberClass object from the database using the given QueryString /// </summary> /// <param name="ClassId">The primary key value</param> /// <returns>A EF6.MemberClass object</returns> public static EF6.MemberClass Get(string whereClause) { EF6.MemberClass result = null; using (var ctx = new EF6.RT2020Entities()) { result = ctx.MemberClass .SqlQuery(string.Format("Select * from MemberClass Where {0}", whereClause)) .AsNoTracking() .FirstOrDefault(); } return(result); }
public static string GetParentName(EF6.MemberClass target) { var result = ""; if (target.ParentClass.HasValue) { using (var ctx = new EF6.RT2020Entities()) { var item = ctx.MemberClass.Where(x => x.ClassId == target.ParentClass.Value).AsNoTracking().FirstOrDefault(); if (item != null) { result = CookieHelper.CurrentLocaleId == LanguageHelper.AlternateLanguage2.Key ? item.ClassName_Cht : CookieHelper.CurrentLocaleId == LanguageHelper.AlternateLanguage1.Key ? item.ClassName_Chs : item.ClassName; } } } return(result); }