public void CurrencySqlExtractToFile( )
{
GenericDatabaseStorage <SqlConnection, SqlCommand> storage = new GenericDatabaseStorage <SqlConnection, SqlCommand>(typeof(TestRecord), "Data Source=FRENZY;Initial Catalog=Pruebas;User Id=sa;Password=Toshiba;");
storage.SelectSql = "SELECT * FROM Currency";
storage.FillRecordCallback = new FillRecordHandler(FillRecordOrder);
FileDataLink.EasyExtractToFile(storage, "tempord.txt");
FileDataLink link = new FileDataLink(storage);
link.ExtractToFile("tempord.txt");
TestRecord[] res = CommonEngine.ReadFile(typeof(TestRecord), "tempord.txt") as TestRecord[];
if (File.Exists("tempord.txt"))
{
File.Delete("tempord.txt");
}
Assert.AreEqual(105, res.Length);
Assert.AreEqual("AED", res[0].CurrencyCode);
Assert.AreEqual("AFA", res[1].CurrencyCode);
Assert.AreEqual("ALL", res[2].CurrencyCode);
}
public void CurrencyOracleExtractToFile( )
{
GenericDatabaseStorage <OracleConnection, OracleCommand> storage = new GenericDatabaseStorage <OracleConnection, OracleCommand>(typeof(TestRecord), "User Id=SHELL;Password=shell;Data Source=ora9dev");
storage.SelectSql = "SELECT * FROM CURRENCY";
storage.FillRecordCallback = new FillRecordHandler(FillRecordOrder);
FileDataLink.EasyExtractToFile(storage, "tempord.txt");
FileDataLink link = new FileDataLink(storage);
link.ExtractToFile("tempord.txt");
TestRecord[] res = CommonEngine.ReadFile(typeof(TestRecord), "tempord.txt") as TestRecord[];
if (File.Exists("tempord.txt"))
{
File.Delete("tempord.txt");
}
Assert.AreEqual(3, res.Length);
Assert.AreEqual("AED", res[0].CurrencyCode);
Assert.AreEqual("AFA", res[1].CurrencyCode);
Assert.AreEqual("ALL", res[2].CurrencyCode);
}
void SortBy(string field)
{
txtSortedBy.Text = "Sorted By " + field.Substring(1);
CustomersVerticalBar[] res2 = (CustomersVerticalBar[])mRecords.Clone();
CommonEngine.SortRecordsByField(res2, field);
grid2.SelectedObject = res2;
}
public void OrdersExtractToFile()
{
SqlServerStorage storage = new SqlServerStorage(typeof(OrdersVerticalBar));
storage.ServerName = "NEON-64";
storage.DatabaseName = "Northwind";
storage.SelectSql = "SELECT * FROM Orders";
storage.FillRecordCallback = new FillRecordHandler(FillRecordOrder);
FileDataLink.EasyExtractToFile(storage, "tempord.txt");
FileDataLink link = new FileDataLink(storage);
link.ExtractToFile("tempord.txt");
OrdersVerticalBar[] res = CommonEngine.ReadFile(typeof(OrdersVerticalBar), "tempord.txt") as OrdersVerticalBar[];
if (File.Exists("tempord.txt"))
{
File.Delete("tempord.txt");
}
Assert.AreEqual(830, res.Length);
Assert.AreEqual("VINET", res[0].CustomerID);
Assert.AreEqual("TOMSP", res[1].CustomerID);
Assert.AreEqual("HANAR", res[2].CustomerID);
}
/// <summary>Creates a new DelimitedClassBuilder.</summary>
/// <param name="options">The specifications for the Csv file.</param>
public CsvClassBuilder(CsvOptions options) : base(options.RecordClassName, options.Delimiter.ToString())
{
IgnoreFirstLines = 1;
if (options.SampleFileName != string.Empty)
{
var firstLine = CommonEngine.RawReadFirstLines(options.SampleFileName, 1);
if (options.HeaderLines > 0)
{
foreach (var header in firstLine.Split(options.HeaderDelimiter == char.MinValue ? options.Delimiter : options.HeaderDelimiter))
{
AddField(StringToIdentifier(header));
}
}
else
{
var fieldsNbr = firstLine.Split(options.Delimiter).Length;
for (var i = 0; i < fieldsNbr; i++)
{
AddField(options.FieldsPrefix + i.ToString());
}
}
}
else if (options.NumberOfFields > 0)
{
AddFields(options.NumberOfFields, options.FieldsPrefix);
}
else
{
throw new BadUsageException("You must provide a SampleFileName or a NumberOfFields to parse a genric CSV file.");
}
}
public void OrdersInsertBad()
{
var storage = new SqlServerStorage(typeof(OrdersVerticalBar));
storage.ServerName = "NEON-64";
storage.DatabaseName = "Northwind";
storage.InsertSqlCallback = new InsertSqlHandler(GetInsertSqlOrder);
var res =
(OrdersVerticalBar[])
CommonEngine.ReadFile(typeof(OrdersVerticalBar),
TestCommon.GetPath("Good", "OrdersVerticalBar.txt"));
var res2 = new OrdersVerticalBar[1];
res2[0] = res[0];
//storage.ExecuteInBatchSize
//res2[0].OrderDate = new DateTime(1750, 10, 10);
try {
storage.InsertRecords(res2);
}
catch (SqlException ex) {
if (ex.Number == 208)
{
Assert.Ignore("You dont have this tables in your SqlServer");
}
if (ex.Number == 6)
{
Assert.Ignore("SqlServer not found, skipping this test.");
}
Assert.Ignore(ex.ToString());
}
}
public async void GetAllLevel2(string level1_id = "")
{
try
{
gridLevel2.DataBindings.Clear();
PRO_tblLevel2DRO level2s = await PRO_tblLevel2BUS.GetAllLevel2(CommonEngine.userInfo.UserID, ConfigEngine.Language, level1_id, false, new DTO.Systems.SYS_tblActionLogDTO
{
Activity = BaseConstant.COMMAND_INSERT_EN,
UserID = CommonEngine.userInfo.UserID,
LanguageID = ConfigEngine.Language,
ActionEN = BaseConstant.COMMAND_LOAD_ALL_DATA_EN,
ActionVN = BaseConstant.COMMAND_LOAD_ALL_DATA_VI,
FunctionID = "21",
DescriptionVN = string.Format("Tài khoản '{0}' vừa tải thành công dữ liệu nhóm hàng.", CommonEngine.userInfo.UserID),
DescriptionEN = string.Format("Account '{0}' downloaded successfully data of product group.", CommonEngine.userInfo.UserID)
});
if (!CommonEngine.CheckValidResponseItem(level2s.ResponseItem))
{
return;
}
gridLevel2.DataSource = level2s.Level2List != null ? level2s.Level2List : null;
barBottom.Visible = (level2s.Level2List != null && level2s.Level2List.Count > 0) ? true : false;
CommonEngine.LoadUserPermission("21", btnDelete, btnPrint, btnImport, btnExport);
}
catch (Exception ex)
{
CommonEngine.ShowExceptionMessage(ex);
}
}
public async void GetAllProvinces()
{
try
{
gridProvince.DataBindings.Clear();
PRO_tblProvinceDRO list = await PRO_tblProvinceBUS.GetAllProvinces(CommonEngine.userInfo.UserID, CommonEngine.userInfo.LanguageID, false, new SYS_tblActionLogDTO
{
Activity = BaseConstant.COMMAND_INSERT_EN,
UserID = CommonEngine.userInfo.UserID,
LanguageID = ConfigEngine.Language,
ActionEN = BaseConstant.COMMAND_LOAD_ALL_DATA_EN,
ActionVN = BaseConstant.COMMAND_LOAD_ALL_DATA_VI,
FunctionID = "8",
DescriptionVN = string.Format("Tài khoản '{0}' vừa tải thành công dữ liệu tỉnh thành.", CommonEngine.userInfo.UserID),
DescriptionEN = string.Format("Account '{0}' downloaded successfully data of provinces.", CommonEngine.userInfo.UserID)
});
if (!CommonEngine.CheckValidResponseItem(list.ResponseItem))
{
return;
}
gridProvince.DataSource = list.ProvinceList != null ? list.ProvinceList : null;
barBottom.Visible = (list.ProvinceList != null && list.ProvinceList.Count > 0) ? true : false;
CommonEngine.LoadUserPermission("8", btnDelete, btnPrint, btnImport, btnExport);
}
catch (Exception ex)
{
CommonEngine.ShowExceptionMessage(ex);
}
}
public void CustomerInsert()
{
var storage = new SqlServerStorage(typeof(CustomersVerticalBar));
storage.ServerName = "NEON-64";
storage.DatabaseName = "Northwind";
storage.InsertSqlCallback = new InsertSqlHandler(GetInsertSqlCust);
try {
storage.InsertRecords(CommonEngine.ReadFile(typeof(CustomersVerticalBar),
TestCommon.GetPath("Good", "CustomersVerticalBar.txt")));
}
catch (SqlException ex) {
if (ex.Number == 208)
{
Assert.Ignore("You dont have this tables in your SqlServer");
}
if (ex.Number == 6)
{
Assert.Ignore("SqlServer not found, skipping this test.");
}
Assert.Ignore(ex.ToString());
}
}
private async void btnCheckValid_Click(object sender, EventArgs e)
{
CommonEngine.ShowWaitForm(this.ParentForm);
isClickCheckFile = await CheckValidTemplate();
CommonEngine.CloseWaitForm();
}
public async void GetAllUsers()
{
try
{
gridUser.DataBindings.Clear();
SYS_tblUserDRO users = new SYS_tblUserDRO();
users = await SYS_tblUserBUS.GetAllUsers(CommonEngine.userInfo.UserID, CommonEngine.userInfo.LanguageID, new SYS_tblActionLogDTO
{
Activity = BaseConstant.COMMAND_INSERT_EN,
UserID = CommonEngine.userInfo.UserID,
LanguageID = ConfigEngine.Language,
ActionEN = BaseConstant.COMMAND_LOAD_ALL_DATA_EN,
ActionVN = BaseConstant.COMMAND_LOAD_ALL_DATA_VI,
FunctionID = "10",
DescriptionVN = string.Format("Tài khoản '{0}' vừa tải thành công dữ liệu người dùng.", CommonEngine.userInfo.UserID),
DescriptionEN = string.Format("Account '{0}' downloaded successfully data of users.", CommonEngine.userInfo.UserID)
});
if (!CommonEngine.CheckValidResponseItem(users.ResponseItem))
{
return;
}
gridUser.DataSource = users.UserList;
barBottom.Visible = (users != null && users.UserList.Count > 0) ? true : false;
CommonEngine.LoadUserPermission("10", btnDelete, btnPrint, btnImport, btnExport);
}
catch (Exception ex)
{
CommonEngine.ShowExceptionMessage(ex);
}
}
private bool CheckValidate()
{
if (txtGroupCode.Text.Equals(""))
{
depError.SetError(txtGroupCode, LanguageEngine.GetMessageCaption("000003", ConfigEngine.Language));
txtGroupCode.Focus();
return(false);
}
if (txtGroupCode.Text.Contains(" "))
{
depError.SetError(txtGroupCode, LanguageEngine.GetMessageCaption("000004", ConfigEngine.Language));
txtGroupCode.Focus();
return(false);
}
if (CommonEngine.CheckExistsUnicodeChar(txtGroupCode.Text))
{
depError.SetError(txtGroupCode, LanguageEngine.GetMessageCaption("000021", ConfigEngine.Language));
txtGroupCode.Focus();
return(false);
}
if (txtVNName.Text.Trim().Equals(""))
{
depError.SetError(txtVNName, LanguageEngine.GetMessageCaption("000003", ConfigEngine.Language));
txtVNName.Focus();
return(false);
}
if (txtENName.Text.Trim().Equals(""))
{
depError.SetError(txtENName, LanguageEngine.GetMessageCaption("000003", ConfigEngine.Language));
txtENName.Focus();
return(false);
}
return(true);
}
private async void trlUser_FocusedNodeChanged(object sender, DevExpress.XtraTreeList.FocusedNodeChangedEventArgs e)
{
try
{
trlPermission.ClearNodes();
TreeListNode node = trlUser.FocusedNode;
//CommonEngine.ShowWaitForm(this);
await LoadPermission(node.GetDisplayText(tlcCode) + "", rootNode, node.Level == 0?false : true);
string result = "", tmpGroup = "", tmpUser = "";
if (node.Level.Equals(0))
{
tmpGroup = string.Format(@" {0}: {1}", ConfigEngine.Language.Equals("vi") ? "Nhóm" : "Group", node.GetDisplayText(tlcName));
tmpUser = "";
}
else
{
tmpGroup = string.Format(@" {0}: {1}", ConfigEngine.Language.Equals("vi") ? "Nhóm" : "Group", node.ParentNode.GetDisplayText(tlcName));
tmpUser = string.Format(@"<br> {0}: {1}", ConfigEngine.Language.Equals("vi") ? "Người dùng" : "User", node.GetDisplayText(tlcName));
}
result = string.Format(@"{0}{1}", tmpGroup, tmpUser);
lblUserInfo.Caption = result;
}
catch (Exception ex)
{
CommonEngine.ShowExceptionMessage(ex);
return;
}
finally
{
//CommonEngine.CloseWaitForm();
}
}
private void LoadAllUser(TreeListNode group_node, string group_id, List <SYS_tblUserDTO> user_list)
{
string strFullName = "";
try
{
this.Cursor = Cursors.WaitCursor;
trlUser.BeginUnboundLoad();
var users = (from user in user_list
where user.GroupID.Equals(group_id)
select user).ToList();
foreach (var user in users)
{
strFullName = (!string.IsNullOrEmpty(user.FullName)) ? " - " + user.FullName : "";
userNode = trlUser.AppendNode(new object[] { string.Format(@"{0}{1}", user.Username, strFullName), user.Username }, group_node);
userNode.ImageIndex = 1;
userNode.SelectImageIndex = 1;
}
trlUser.EndUnboundLoad();
}
catch (Exception ex)
{
CommonEngine.ShowExceptionMessage(ex);
}
finally
{
this.Cursor = Cursors.Default;
}
}
private async void LoadAllUserLevel()
{
try
{
this.Cursor = Cursors.WaitCursor;
SYS_tblUserLevelDRO userLevel = new SYS_tblUserLevelDRO();
userLevel = await SYS_tblUserLevelBUS.GetAllUserLevel(CommonEngine.userInfo.UserID, ConfigEngine.Language);
if (!CommonEngine.CheckValidResponseItem(userLevel.ResponseItem))
{
return;
}
gluUserLevel.DataSource = userLevel.UserLevelList;
gluUserLevel.DisplayMember = "UserLevelName";
gluUserLevel.ValueMember = "UserLevelID";
}
catch (Exception ex)
{
CommonEngine.ShowExceptionMessage(ex);
}
finally
{
this.Cursor = Cursors.Default;
}
}
public async void GetAllStall(string store_id, string warehouse_id)
{
try
{
gridStall.DataBindings.Clear();
PRO_tblStallDRO stalls = await PRO_tblStallBUS.GetAllStall(CommonEngine.userInfo.UserID, ConfigEngine.Language, false, store_id, warehouse_id, new SYS_tblActionLogDTO
{
Activity = BaseConstant.COMMAND_INSERT_EN,
UserID = CommonEngine.userInfo.UserID,
LanguageID = ConfigEngine.Language,
ActionEN = BaseConstant.COMMAND_LOAD_ALL_DATA_EN,
ActionVN = BaseConstant.COMMAND_LOAD_ALL_DATA_VI,
FunctionID = "19",
DescriptionVN = string.Format("Tài khoản '{0}' vừa tải thành công dữ liệu quầy bán.", CommonEngine.userInfo.UserID),
DescriptionEN = string.Format("Account '{0}' downloaded successfully data of stalls.", CommonEngine.userInfo.UserID)
});
if (!CommonEngine.CheckValidResponseItem(stalls.ResponseItem))
{
return;
}
gridStall.DataSource = stalls.StallList != null ? stalls.StallList : null;
barFooter.Visible = (stalls.StallList != null && stalls.StallList.Count > 0) ? true : false;
CommonEngine.LoadUserPermission("19", btnDelete, btnPrint, btnImport, btnExport);
}
catch (Exception ex)
{
CommonEngine.ShowExceptionMessage(ex);
}
}
private async void gluGroupUser_ButtonClick(object sender, DevExpress.XtraEditors.Controls.ButtonPressedEventArgs e)
{
if (e.Button.Index == 1)
{
CommonEngine.OpenInputForm(new uc_GroupUserDetail(), new Size(450, 290), false);
await LoadGroupUser(null);
}
}
private void gluLevel2_ButtonClick(object sender, DevExpress.XtraEditors.Controls.ButtonPressedEventArgs e)
{
if (e.Button.Index == 1)
{
CommonEngine.OpenInputForm(new uc_Level2Detail(), new Size(450, 320), false);
LoadLevel2(gluLevel1.EditValue + "");
}
}
private async void gluProvince_ButtonClick(object sender, DevExpress.XtraEditors.Controls.ButtonPressedEventArgs e)
{
if (e.Button.Index == 1)
{
CommonEngine.OpenInputForm(new uc_ProvinceDetail(), new Size(435, 265), false);
await LoadProvince();
}
}
public void Sort5()
{
engine = new FileHelperEngine(typeof(CustomersSort));
CustomersSort[] res = engine.ReadFile(TestCommon.TestPath(@"good\Sort1.txt")) as CustomersSort[];
Assert.AreEqual(8, res.Length);
CommonEngine.SortRecordsByField(res, "CompanyNameNoExistHere");
}
/// <summary>
/// Sort by field (eg mCountry) and display result in a
/// grid, replaces the previous sort
/// </summary>
/// <param name="field">Field to sort on</param>
private void SortBy(string field)
{
// first character of field is always m, remove it.
txtSortedBy.Text = "Sorted By " + field.Substring(1);
CustomersVerticalBar[] res2 = (CustomersVerticalBar[])mRecords.Clone();
CommonEngine.SortRecordsByField(res2, field);
grid2.SelectedObject = res2;
}
private List <IEngine> CreateEngines()
{
var commonEngine = new CommonEngine();
var hommEngine = new HommEngine(commonEngine);
return(new List <IEngine> {
commonEngine, hommEngine
});
}
public void Sort3()
{
var engine = new FileHelperEngine <CustomersVerticalBar>();
var res = engine.ReadFile(FileTest.Good.Sort1.Path);
Assert.Throws <BadUsageException>(()
=> CommonEngine.SortRecords(res));
}
public void RemoveDuplicatedRecords()
{
var eng = new FileHelperEngine <DiffOrdersFixed>();
DiffOrdersFixed[] res = FileTest.Good.DiffOrdersDup.ReadWithEngine <DiffOrdersFixed>(eng);
Assert.AreEqual(14, res.Length);
res = (DiffOrdersFixed[])CommonEngine.RemoveDuplicateRecords(res);
Assert.AreEqual(4, res.Length);
}
public void Sort5()
{
var engine = new FileHelperEngine <CustomersSort>();
CustomersSort[] res = engine.ReadFile(FileTest.Good.Sort1.Path);
Assert.AreEqual(8, res.Length);
Assert.Throws <BadUsageException>(()
=> CommonEngine.SortRecordsByField(res, "CompanyNameNoExistHere"));
}
public void RemoveDuplicatedRecords()
{
FileHelperEngine eng = new FileHelperEngine(typeof(DiffOrdersFixed));
DiffOrdersFixed[] res = (DiffOrdersFixed[])Common.ReadTest(eng, @"good\DiffOrdersDup.txt");
Assert.AreEqual(14, res.Length);
res = (DiffOrdersFixed[])CommonEngine.RemoveDuplicateRecords(res);
Assert.AreEqual(4, res.Length);
}
public void Sort3()
{
engine = new FileHelperEngine(typeof(CustomersVerticalBar));
object[] res = engine.ReadFile(Common.TestPath(@"good\Sort1.txt"));
Assert.Throws <BadUsageException>(()
=> CommonEngine.SortRecords(res));
}
public void OrdersInsert()
{
SqlServerStorage storage = new SqlServerStorage(typeof(CustomersVerticalBar));
storage.ServerName = "NEON-64";
storage.DatabaseName = "Northwind";
storage.InsertSqlCallback = new InsertSqlHandler(GetInsertSqlCust);
storage.InsertRecords(CommonEngine.ReadFile(typeof(CustomersVerticalBar), TestCommon.TestPath(@"Good\CustomersVerticalBar.txt")));
}
private string[][] GetSampleLines(IEnumerable <string> files, int nroOfLines)
{
var res = new List <string[]>();
foreach (var file in files)
{
res.Add(CommonEngine.RawReadFirstLinesArray(file, nroOfLines, mEncoding));
}
return(res.ToArray());
}
protected override void OnLoad(EventArgs e)
{
base.OnLoad(e);
CommonEngine.CloseWaitForm();
BeginInvoke(new MethodInvoker(() =>
{
if (!string.IsNullOrEmpty(txtGroupID.Text))
{
txtVNName.Focus();
}
}));
}
