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);
}
