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