private Guid ImportClass6(string class6Value) { Guid result = Guid.Empty; using (var ctx = new EF6.RT2020Entities()) { //string sql = "Class6Code = '" + class6Value + "'"; var oC6 = ctx.ProductClass6.Where(x => x.Class6Code == class6Value).FirstOrDefault(); if (oC6 == null) { oC6 = new EF6.ProductClass6(); oC6.Class6Id = Guid.NewGuid(); oC6.Class6Code = class6Value; oC6.Class6Initial = class6Value; oC6.CreatedBy = ConfigHelper.CurrentUserId; oC6.CreatedOn = DateTime.Now; ctx.ProductClass6.Add(oC6); } oC6.ModifiedBy = ConfigHelper.CurrentUserId; oC6.ModifiedOn = DateTime.Now; ctx.SaveChanges(); result = oC6.Class6Id; } return(result); }
private static string GetFormatedText(EF6.ProductClass6 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.ProductClass6 object from the database using the given Class6Id /// </summary> /// <param name="class6Id">The primary key value</param> /// <returns>A EF6.ProductClass6 object</returns> public static EF6.ProductClass6 Get(Guid class6Id) { EF6.ProductClass6 result = null; using (var ctx = new EF6.RT2020Entities()) { result = ctx.ProductClass6.Where(x => x.Class6Id == class6Id).AsNoTracking().FirstOrDefault(); } return(result); }
/// <summary> /// Get a EF6.ProductClass6 object from the database using the given QueryString /// </summary> /// <param name="class6Id">The primary key value</param> /// <returns>A EF6.ProductClass6 object</returns> public static EF6.ProductClass6 Get(string whereClause) { EF6.ProductClass6 result = null; using (var ctx = new EF6.RT2020Entities()) { result = ctx.ProductClass6 .SqlQuery(string.Format("Select * from ProductClass6 Where {0}", whereClause)) .AsNoTracking() .FirstOrDefault(); } return(result); }
private bool Save() { bool result = false; using (var ctx = new EF6.RT2020Entities()) { switch (_ClassType) { case ProductHelper.Classes.Class1: #region ProductClass1 var class1 = ctx.ProductClass1.Find(_ClassId); if (class1 == null) { class1 = new EF6.ProductClass1(); class1.Class1Id = Guid.NewGuid(); class1.Class1Code = txtClassCode.Text; class1.CreatedOn = DateTime.Now; class1.CreatedBy = ConfigHelper.CurrentUserId; class1.Retired = false; ctx.ProductClass1.Add(class1); } class1.Class1Name = txtClassName.Text; class1.Class1Name_Chs = txtClassNameAlt1.Text; class1.Class1Name_Cht = txtClassNameAlt2.Text; class1.Class1Initial = txtInitial.Text; class1.ModifiedOn = DateTime.Now; class1.ModifiedBy = ConfigHelper.CurrentUserId; ctx.SaveChanges(); result = true; break; #endregion case ProductHelper.Classes.Class2: #region ProductClass2 var class2 = ctx.ProductClass2.Find(_ClassId); if (class2 == null) { class2 = new EF6.ProductClass2(); class2.Class2Id = Guid.NewGuid(); class2.Class2Code = txtClassCode.Text; class2.CreatedOn = DateTime.Now; class2.CreatedBy = ConfigHelper.CurrentUserId; class2.Retired = false; ctx.ProductClass2.Add(class2); } class2.Class2Name = txtClassName.Text; class2.Class2Name_Chs = txtClassNameAlt1.Text; class2.Class2Name_Cht = txtClassNameAlt2.Text; class2.Class2Initial = txtInitial.Text; class2.ModifiedOn = DateTime.Now; class2.ModifiedBy = ConfigHelper.CurrentUserId; ctx.SaveChanges(); result = true; break; #endregion case ProductHelper.Classes.Class3: #region ProductClass3 var class3 = ctx.ProductClass3.Find(_ClassId); if (class3 == null) { class3 = new EF6.ProductClass3(); class3.Class3Id = Guid.NewGuid(); class3.Class3Code = txtClassCode.Text; class3.CreatedOn = DateTime.Now; class3.CreatedBy = ConfigHelper.CurrentUserId; class3.Retired = false; ctx.ProductClass3.Add(class3); } class3.Class3Name = txtClassName.Text; class3.Class3Name_Chs = txtClassNameAlt1.Text; class3.Class3Name_Cht = txtClassNameAlt2.Text; class3.Class3Initial = txtInitial.Text; class3.ModifiedOn = DateTime.Now; class3.ModifiedBy = ConfigHelper.CurrentUserId; ctx.SaveChanges(); result = true; break; #endregion case ProductHelper.Classes.Class4: #region ProductClass4 var class4 = ctx.ProductClass4.Find(_ClassId); if (class4 == null) { class4 = new EF6.ProductClass4(); class4.Class4Id = Guid.NewGuid(); class4.Class4Code = txtClassCode.Text; class4.CreatedOn = DateTime.Now; class4.CreatedBy = ConfigHelper.CurrentUserId; class4.Retired = false; ctx.ProductClass4.Add(class4); } class4.Class4Name = txtClassName.Text; class4.Class4Name_Chs = txtClassNameAlt1.Text; class4.Class4Name_Cht = txtClassNameAlt2.Text; class4.Class4Initial = txtInitial.Text; class4.ModifiedOn = DateTime.Now; class4.ModifiedBy = ConfigHelper.CurrentUserId; ctx.SaveChanges(); result = true; break; #endregion case ProductHelper.Classes.Class5: #region ProductClass5 var class5 = ctx.ProductClass5.Find(_ClassId); if (class5 == null) { class5 = new EF6.ProductClass5(); class5.Class5Id = Guid.NewGuid(); class5.Class5Code = txtClassCode.Text; class5.CreatedOn = DateTime.Now; class5.CreatedBy = ConfigHelper.CurrentUserId; class5.Retired = false; ctx.ProductClass5.Add(class5); } class5.Class5Name = txtClassName.Text; class5.Class5Name_Chs = txtClassNameAlt1.Text; class5.Class5Name_Cht = txtClassNameAlt2.Text; class5.Class5Initial = txtInitial.Text; class5.ModifiedOn = DateTime.Now; class5.ModifiedBy = ConfigHelper.CurrentUserId; ctx.SaveChanges(); result = true; break; #endregion case ProductHelper.Classes.Class6: #region ProductClass6 var class6 = ctx.ProductClass6.Find(_ClassId); if (class6 == null) { class6 = new EF6.ProductClass6(); class6.Class6Id = Guid.NewGuid(); class6.Class6Code = txtClassCode.Text; class6.CreatedOn = DateTime.Now; class6.CreatedBy = ConfigHelper.CurrentUserId; class6.Retired = false; ctx.ProductClass6.Add(class6); } class6.Class6Name = txtClassName.Text; class6.Class6Name_Chs = txtClassNameAlt1.Text; class6.Class6Name_Cht = txtClassNameAlt2.Text; class6.Class6Initial = txtInitial.Text; class6.ModifiedOn = DateTime.Now; class6.ModifiedBy = ConfigHelper.CurrentUserId; ctx.SaveChanges(); result = true; break; #endregion } } return(result); }
private bool Save() { bool result = false; using (var ctx = new EF6.RT2020Entities()) { switch (_ClassMode) { case ProductHelper.Classes.Class1: #region Class1 EF6.ProductClass1 class1; if (_EditMode == EnumHelper.EditMode.Add) { class1 = new EF6.ProductClass1(); class1.Class1Id = Guid.NewGuid(); class1.Class1Code = txtCode.Text; class1.CreatedBy = ConfigHelper.CurrentUserId; class1.CreatedOn = DateTime.Now; class1.Retired = false; ctx.ProductClass1.Add(class1); } else { class1 = ctx.ProductClass1.Find(_ClassId); } class1.Class1Initial = txtInitial.Text; class1.Class1Name = txtName.Text; class1.Class1Name_Chs = txtNameChs.Text; class1.Class1Name_Cht = txtNameCht.Text; if ((Guid)cboParentClass.SelectedValue != Guid.Empty) { class1.ParentClass = (Guid)cboParentClass.SelectedValue; } if ((Guid)cboAltClass.SelectedValue != Guid.Empty) { class1.AlternateClass = (Guid)cboAltClass.SelectedValue; } class1.ModifiedBy = ConfigHelper.CurrentUserId; class1.ModifiedOn = DateTime.Now; break; #endregion case ProductHelper.Classes.Class2: #region Class2 EF6.ProductClass2 class2; if (_EditMode == EnumHelper.EditMode.Add) { class2 = new EF6.ProductClass2(); class2.Class2Id = Guid.NewGuid(); class2.Class2Code = txtCode.Text; class2.CreatedBy = ConfigHelper.CurrentUserId; class2.CreatedOn = DateTime.Now; class2.Retired = false; ctx.ProductClass2.Add(class2); } else { class2 = ctx.ProductClass2.Find(_ClassId); } class2.Class2Initial = txtInitial.Text; class2.Class2Name = txtName.Text; class2.Class2Name_Chs = txtNameChs.Text; class2.Class2Name_Cht = txtNameCht.Text; if ((Guid)cboParentClass.SelectedValue != Guid.Empty) { class2.ParentClass = (Guid)cboParentClass.SelectedValue; } if ((Guid)cboAltClass.SelectedValue != Guid.Empty) { class2.AlternateClass = (Guid)cboAltClass.SelectedValue; } class2.ModifiedBy = ConfigHelper.CurrentUserId; class2.ModifiedOn = DateTime.Now; break; #endregion case ProductHelper.Classes.Class3: #region Class3 EF6.ProductClass3 class3; if (_EditMode == EnumHelper.EditMode.Add) { class3 = new EF6.ProductClass3(); class3.Class3Id = Guid.NewGuid(); class3.Class3Code = txtCode.Text; class3.CreatedBy = ConfigHelper.CurrentUserId; class3.CreatedOn = DateTime.Now; class3.Retired = false; ctx.ProductClass3.Add(class3); } else { class3 = ctx.ProductClass3.Find(_ClassId); } class3.Class3Initial = txtInitial.Text; class3.Class3Name = txtName.Text; class3.Class3Name_Chs = txtNameChs.Text; class3.Class3Name_Cht = txtNameCht.Text; if ((Guid)cboParentClass.SelectedValue != Guid.Empty) { class3.ParentClass = (Guid)cboParentClass.SelectedValue; } if ((Guid)cboAltClass.SelectedValue != Guid.Empty) { class3.AlternatedClass = (Guid)cboAltClass.SelectedValue; } class3.ModifiedBy = ConfigHelper.CurrentUserId; class3.ModifiedOn = DateTime.Now; break; #endregion case ProductHelper.Classes.Class4: #region Class4 EF6.ProductClass4 class4; if (_EditMode == EnumHelper.EditMode.Add) { class4 = new EF6.ProductClass4(); class4.Class4Id = Guid.NewGuid(); class4.Class4Code = txtCode.Text; class4.CreatedBy = ConfigHelper.CurrentUserId; class4.CreatedOn = DateTime.Now; class4.Retired = false; ctx.ProductClass4.Add(class4); } else { class4 = ctx.ProductClass4.Find(_ClassId); } class4.Class4Initial = txtInitial.Text; class4.Class4Name = txtName.Text; class4.Class4Name_Chs = txtNameChs.Text; class4.Class4Name_Cht = txtNameCht.Text; if ((Guid)cboParentClass.SelectedValue != Guid.Empty) { class4.ParentClass = (Guid)cboParentClass.SelectedValue; } if ((Guid)cboAltClass.SelectedValue != Guid.Empty) { class4.AlternateClass = (Guid)cboAltClass.SelectedValue; } class4.ModifiedBy = ConfigHelper.CurrentUserId; class4.ModifiedOn = DateTime.Now; break; #endregion case ProductHelper.Classes.Class5: #region Class5 EF6.ProductClass5 class5; if (_EditMode == EnumHelper.EditMode.Add) { class5 = new EF6.ProductClass5(); class5.Class5Id = Guid.NewGuid(); class5.Class5Code = txtCode.Text; class5.CreatedBy = ConfigHelper.CurrentUserId; class5.CreatedOn = DateTime.Now; class5.Retired = false; ctx.ProductClass5.Add(class5); } else { class5 = ctx.ProductClass5.Find(_ClassId); } class5.Class5Initial = txtInitial.Text; class5.Class5Name = txtName.Text; class5.Class5Name_Chs = txtNameChs.Text; class5.Class5Name_Cht = txtNameCht.Text; if ((Guid)cboParentClass.SelectedValue != Guid.Empty) { class5.ParentClass = (Guid)cboParentClass.SelectedValue; } if ((Guid)cboAltClass.SelectedValue != Guid.Empty) { class5.AlternateClass = (Guid)cboAltClass.SelectedValue; } class5.ModifiedBy = ConfigHelper.CurrentUserId; class5.ModifiedOn = DateTime.Now; break; #endregion case ProductHelper.Classes.Class6: #region Class6 EF6.ProductClass6 class6; if (_EditMode == EnumHelper.EditMode.Add) { class6 = new EF6.ProductClass6(); class6.Class6Id = Guid.NewGuid(); class6.Class6Code = txtCode.Text; class6.CreatedBy = ConfigHelper.CurrentUserId; class6.CreatedOn = DateTime.Now; class6.Retired = false; ctx.ProductClass6.Add(class6); } else { class6 = ctx.ProductClass6.Find(_ClassId); } class6.Class6Initial = txtInitial.Text; class6.Class6Name = txtName.Text; class6.Class6Name_Chs = txtNameChs.Text; class6.Class6Name_Cht = txtNameCht.Text; if ((Guid)cboParentClass.SelectedValue != Guid.Empty) { class6.ParentClass = (Guid)cboParentClass.SelectedValue; } if ((Guid)cboAltClass.SelectedValue != Guid.Empty) { class6.AlternateClass = (Guid)cboAltClass.SelectedValue; } class6.ModifiedBy = ConfigHelper.CurrentUserId; class6.ModifiedOn = DateTime.Now; break; #endregion } ctx.SaveChanges(); Helper.DesktopHelper.RefreshMainList <ClassList>(); result = true; } return(result);; }