public DataSet SelectGlAccountTest(IGlAccount glAccount) { DataSet tableVerify = new DataSet(); tableVerify = dbEntity.SelectObject(glAccount) as DataSet; return(tableVerify); }
public void VerifyCountry() { ICountry country = BusinessObjectInitializer.CreateCountry(); Random random = new Random(); country.Code = DATestUtils.GenerateString(3, true, true); country.Name = DATestUtils.GenerateString(30, true, false); country.IdRegion = random.Next(1, 3); country.IdCurrency = random.Next(1, 12); country.Rank = random.Next(100000, 200000); int newId = InsertCountryTest(country); Assert.Greater(newId, 0); int rowsAffected = UpdateCountryTest(country); Assert.AreEqual(1, rowsAffected); DataTable resultTable = SelectCountryTest(country).Tables[0]; //Verifies that the table contains the correct column names and order StringCollection columns = new StringCollection(); columns.AddRange(new string[] { "Code", "Name", "RegionName", "CurrencyName", "Email", "Rank", "Id", "IdRegion", "IdCurrency" }); DATestUtils.CheckTableStructure(resultTable, columns); try { //we delete the 7 accounts associated with a country GlAccountTest accountTest = new GlAccountTest(); accountTest.Initialize(); IGlAccount glAccount = BusinessObjectInitializer.CreateGLAccount(); glAccount.IdCountry = newId; for (int i = 1; i <= 7; i++) { glAccount.Id = i; accountTest.DeleteGlAccountTest(glAccount); } accountTest.CleanUp(); } catch (Exception ex) { throw new Exception("Pre-Condition failed for delete operation. Gl/account operation meessage: " + ex.Message); } int rowCount = DeleteCountryTest(country); Assert.AreEqual(1, rowCount); }
public void VerifyGlAccount() { IGlAccount glAccount = BusinessObjectInitializer.CreateGLAccount(); Random random = new Random(); glAccount.Name = DATestUtils.GenerateString(30, true, false); glAccount.Account = DATestUtils.GenerateString(20, true, false); glAccount.IdCostType = random.Next(1, 6); glAccount.IdCountry = random.Next(1, 3); int newId = InsertGlAccountTest(glAccount); Assert.Greater(newId, 0); int rowsAffected = UpdateGlAccountTest(glAccount); Assert.AreEqual(1, rowsAffected); DataTable resultTable = SelectGlAccountTest(glAccount).Tables[0]; //Verifies that the table contains the correct column names and order StringCollection columns = new StringCollection(); columns.AddRange(new string[] { "CountryName", "G/L Account", "Name", "CostType", "Id", "IdCountry", "IdCostType" }); DATestUtils.CheckTableStructure(resultTable, columns); int rowCount = DeleteGlAccountTest(glAccount); Assert.AreEqual(1, rowCount); }
protected override void InitializeObject(IGenericEntity ent) { if (ent is IGlAccount) { IGlAccount GlAccount = (IGlAccount)ent; DBStoredProcedure spInsert = new DBStoredProcedure(); spInsert.ProcedureName = "catInsertGlAccount"; spInsert.AddParameter(new DBParameter("@IdCountry", DbType.Int32, ParameterDirection.Input, GlAccount.IdCountry)); spInsert.AddParameter(new DBParameter("@Account", DbType.String, ParameterDirection.Input, GlAccount.Account)); spInsert.AddParameter(new DBParameter("@Name", DbType.String, ParameterDirection.Input, GlAccount.Name)); spInsert.AddParameter(new DBParameter("@IdCostType", DbType.Int32, ParameterDirection.Input, GlAccount.IdCostType)); DBStoredProcedure spUpdate = new DBStoredProcedure(); spUpdate.ProcedureName = "catUpdateGlAccount"; spUpdate.AddParameter(new DBParameter("@Id", DbType.Int32, ParameterDirection.Input, GlAccount.Id)); spUpdate.AddParameter(new DBParameter("@IdCountry", DbType.Int32, ParameterDirection.Input, GlAccount.IdCountry)); spUpdate.AddParameter(new DBParameter("@Account", DbType.String, ParameterDirection.Input, GlAccount.Account)); spUpdate.AddParameter(new DBParameter("@Name", DbType.String, ParameterDirection.Input, GlAccount.Name)); spUpdate.AddParameter(new DBParameter("@IdCostType", DbType.Int32, ParameterDirection.Input, GlAccount.IdCostType)); DBStoredProcedure spDelete = new DBStoredProcedure(); spDelete.ProcedureName = "catDeleteGlAccount"; spDelete.AddParameter(new DBParameter("@Id", DbType.Int32, ParameterDirection.Input, GlAccount.Id)); spDelete.AddParameter(new DBParameter("@IdCountry", DbType.Int32, ParameterDirection.Input, GlAccount.IdCountry)); this.AddStoredProcedure("InsertObject", spInsert); this.AddStoredProcedure("UpdateObject", spUpdate); this.AddStoredProcedure("DeleteObject", spDelete); DBStoredProcedure spSelect = new DBStoredProcedure(); spSelect.ProcedureName = "catSelectGlAccount"; spSelect.AddParameter(new DBParameter("@Id", DbType.Int32, ParameterDirection.Input, GlAccount.Id)); spSelect.AddParameter(new DBParameter("@IdCountry", DbType.Int32, ParameterDirection.Input, GlAccount.IdCountry)); this.AddStoredProcedure("SelectObject", spSelect); } }
public int DeleteGlAccountTest(IGlAccount glAccount) { int rowCount = dbEntity.DeleteObject(glAccount); return(rowCount); }
public int InsertGlAccountTest(IGlAccount glAccount) { glAccount.Id = dbEntity.InsertObject(glAccount); return(glAccount.Id); }