private Guid ImportClass1(string class1Value)
{
Guid result = Guid.Empty;
using (var ctx = new EF6.RT2020Entities())
{
//string sql = "Class1Code = '" + class1Value + "'";
var oC1 = ctx.ProductClass1.Where(x => x.Class1Code == class1Value).FirstOrDefault();
if (oC1 == null)
{
oC1 = new EF6.ProductClass1();
oC1.Class1Id = Guid.NewGuid();
oC1.Class1Code = class1Value;
oC1.Class1Initial = class1Value;
oC1.CreatedBy = ConfigHelper.CurrentUserId;
oC1.CreatedOn = DateTime.Now;
ctx.ProductClass1.Add(oC1);
}
oC1.ModifiedBy = ConfigHelper.CurrentUserId;
oC1.ModifiedOn = DateTime.Now;
ctx.SaveChanges();
result = oC1.Class1Id;
}
return(result);
}
private static string GetFormatedText(EF6.ProductClass1 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.ProductClass1 object from the database using the given Class1Id
/// </summary>
/// <param name="class1Id">The primary key value</param>
/// <returns>A EF6.ProductClass1 object</returns>
public static EF6.ProductClass1 Get(Guid class1Id)
{
EF6.ProductClass1 result = null;
using (var ctx = new EF6.RT2020Entities())
{
result = ctx.ProductClass1.Where(x => x.Class1Id == class1Id).AsNoTracking().FirstOrDefault();
}
return(result);
}
/// <summary>
/// Get a EF6.ProductClass1 object from the database using the given QueryString
/// </summary>
/// <param name="class1Id">The primary key value</param>
/// <returns>A EF6.ProductClass1 object</returns>
public static EF6.ProductClass1 Get(string whereClause)
{
EF6.ProductClass1 result = null;
using (var ctx = new EF6.RT2020Entities())
{
result = ctx.ProductClass1
.SqlQuery(string.Format("Select * from ProductClass1 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);;
}
