private Guid ImportAppendix3(string appendix3Value) { Guid result = Guid.Empty; using (var ctx = new EF6.RT2020Entities()) { //string sql = "Appendix3Code = '" + appendix3Value + "'"; var oA3 = ctx.ProductAppendix3.Where(x => x.Appendix3Code == appendix3Value).FirstOrDefault(); if (oA3 == null) { oA3 = new EF6.ProductAppendix3(); oA3.Appendix3Id = Guid.NewGuid(); oA3.Appendix3Code = appendix3Value; oA3.Appendix3Initial = appendix3Value; oA3.CreatedBy = ConfigHelper.CurrentUserId; oA3.CreatedOn = DateTime.Now; ctx.ProductAppendix3.Add(oA3); } oA3.ModifiedBy = ConfigHelper.CurrentUserId; oA3.ModifiedOn = DateTime.Now; ctx.SaveChanges(); result = oA3.Appendix3Id; } return(result); }
private static string GetFormatedText(EF6.ProductAppendix3 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.ProductAppendix3 object from the database using the given Appendix3Id /// </summary> /// <param name="appendix3Id">The primary key value</param> /// <returns>A EF6.ProductAppendix3 object</returns> public static EF6.ProductAppendix3 Get(Guid appendix3Id) { EF6.ProductAppendix3 result = null; using (var ctx = new EF6.RT2020Entities()) { result = ctx.ProductAppendix3.Where(x => x.Appendix3Id == appendix3Id).AsNoTracking().FirstOrDefault(); } return(result); }
/// <summary> /// Get a EF6.ProductAppendix3 object from the database using the given QueryString /// </summary> /// <param name="appendix3Id">The primary key value</param> /// <returns>A EF6.ProductAppendix3 object</returns> public static EF6.ProductAppendix3 Get(string whereClause) { EF6.ProductAppendix3 result = null; using (var ctx = new EF6.RT2020Entities()) { result = ctx.ProductAppendix3 .SqlQuery(string.Format("Select * from ProductAppendix3 Where {0}", whereClause)) .AsNoTracking() .FirstOrDefault(); } return(result); }
private bool SaveAppendix3() { bool result = false; using (var ctx = new EF6.RT2020Entities()) { EF6.ProductAppendix3 item = null; switch (_EditMode) { case EnumHelper.EditMode.Add: item = new EF6.ProductAppendix3(); item.Appendix3Id = Guid.NewGuid(); item.Appendix3Code = txtCode.Text; item.CreatedBy = ConfigHelper.CurrentUserId; item.CreatedOn = DateTime.Now; ctx.ProductAppendix3.Add(item); break; case EnumHelper.EditMode.Edit: item = ctx.ProductAppendix3.Find(_AppendixId); break; } item.Appendix3Initial = txtInitial.Text; item.Appendix3Name = txtName.Text; item.Appendix3Name_Chs = txtNameChs.Text; item.Appendix3Name_Cht = txtNameCht.Text; if ((Guid)cboParentAppendix.SelectedValue != Guid.Empty) { item.ParentAppendix = (Guid)cboParentAppendix.SelectedValue; } item.ModifiedBy = ConfigHelper.CurrentUserId; item.ModifiedOn = DateTime.Now; ctx.SaveChanges(); _AppendixId = item.Appendix3Id; result = true; } return(result); }
private bool Save() { bool result = false; using (var ctx = new EF6.RT2020Entities()) { switch (_AppendixType) { case ProductHelper.Appendix.Appendix1: #region ProductAppendix1 var Appendix1 = ctx.ProductAppendix1.Find(_AppendixId); if (Appendix1 == null) { Appendix1 = new EF6.ProductAppendix1(); Appendix1.Appendix1Id = Guid.NewGuid(); Appendix1.Appendix1Code = txtCode.Text; Appendix1.CreatedOn = DateTime.Now; Appendix1.CreatedBy = ConfigHelper.CurrentUserId; Appendix1.Retired = false; ctx.ProductAppendix1.Add(Appendix1); } Appendix1.Appendix1Name = txtName.Text; Appendix1.Appendix1Name_Chs = txtNameAlt1.Text; Appendix1.Appendix1Name_Cht = txtNameAlt2.Text; Appendix1.Appendix1Initial = txtInitial.Text; Appendix1.ModifiedOn = DateTime.Now; Appendix1.ModifiedBy = ConfigHelper.CurrentUserId; ctx.SaveChanges(); result = true; break; #endregion case ProductHelper.Appendix.Appendix2: #region ProductAppendix2 var Appendix2 = ctx.ProductAppendix2.Find(_AppendixId); if (Appendix2 == null) { Appendix2 = new EF6.ProductAppendix2(); Appendix2.Appendix2Id = Guid.NewGuid(); Appendix2.Appendix2Code = txtCode.Text; Appendix2.CreatedOn = DateTime.Now; Appendix2.CreatedBy = ConfigHelper.CurrentUserId; Appendix2.Retired = false; ctx.ProductAppendix2.Add(Appendix2); } Appendix2.Appendix2Name = txtName.Text; Appendix2.Appendix2Name_Chs = txtNameAlt1.Text; Appendix2.Appendix2Name_Cht = txtNameAlt2.Text; Appendix2.Appendix2Initial = txtInitial.Text; Appendix2.ModifiedOn = DateTime.Now; Appendix2.ModifiedBy = ConfigHelper.CurrentUserId; ctx.SaveChanges(); result = true; break; #endregion case ProductHelper.Appendix.Appendix3: #region ProductAppendix3 var Appendix3 = ctx.ProductAppendix3.Find(_AppendixId); if (Appendix3 == null) { Appendix3 = new EF6.ProductAppendix3(); Appendix3.Appendix3Id = Guid.NewGuid(); Appendix3.Appendix3Code = txtCode.Text; Appendix3.CreatedOn = DateTime.Now; Appendix3.CreatedBy = ConfigHelper.CurrentUserId; Appendix3.Retired = false; ctx.ProductAppendix3.Add(Appendix3); } Appendix3.Appendix3Name = txtName.Text; Appendix3.Appendix3Name_Chs = txtNameAlt1.Text; Appendix3.Appendix3Name_Cht = txtNameAlt2.Text; Appendix3.Appendix3Initial = txtInitial.Text; Appendix3.ModifiedOn = DateTime.Now; Appendix3.ModifiedBy = ConfigHelper.CurrentUserId; ctx.SaveChanges(); result = true; break; #endregion } } return(result); }