public void DeleteNull() { Entities.Fields obj = null; adaptadorFields.Setup(item => item.SaveChanges()).Returns(null); BusinessRules.Interfaces.IFields BusinessRulesFields = new BusinessRules.BusinessRules.Fields(adaptadorFields.Object); var objReturn = BusinessRulesFields.Delete(obj); Assert.IsTrue(objReturn == null); }
protected void GetListOfFieldsInTables(string database, string table, string schema) { using (SqlConnection cnn = new SqlConnection(property.CONNECTION_STRING)) { using (SqlCommand cmd = new SqlCommand(Utils.fieldscommand.Replace("{database}", database).Replace("{table}", table).Replace("{schema}", schema), cnn)) { cmd.CommandType = CommandType.Text; cmd.CommandTimeout = 0; records = new List <Entities.Fields>(); IDataReader drResult = null; try { if (cnn.State == ConnectionState.Closed) { cnn.Open(); } drResult = cmd.ExecuteReader(); while (drResult.Read()) { Entities.Fields record = new Entities.Fields(); record.TABLE_CATALOG = (string)(drResult["TABLE_CATALOG"].ToString()); record.TABLE_NAME = (string)(drResult["TABLE_NAME"].ToString()); record.TABLE_SCHEMA = (string)(drResult["TABLE_SCHEMA"].ToString()); record.ORDINAL_POSITION = (int)(drResult["ORDINAL_POSITION"]); record.COLUMN_NAME = (string)(drResult["COLUMN_NAME"].ToString()); record.DATA_TYPE = (string)(drResult["DATA_TYPE"].ToString()); record.IS_NULLABLE = (string)(drResult["IS_NULLABLE"].ToString()); record.CHARACTER_MAXIMUM_LENGTH = (int)(drResult["CHARACTER_MAXIMUM_LENGTH"]); record.CONSTRAINT_TYPE = (string)(drResult["CONSTRAINT_TYPE"].ToString()); record.KEY_CODE = (int)(drResult["KEY_CODE"]); record.CONSTRAINT_NAME = (string)(drResult["CONSTRAINT_NAME"].ToString()); record.COLUMN_DEFAULT = (string)(drResult["COLUMN_DEFAULT"].ToString()); record.TABLE_NAME_RELATIONSHIP = (string)(drResult["TABLE_NAME_RELATIONSHIP"].ToString()); record.CLASS_TYPE = (string)(drResult["CLASS_TYPE"].ToString()); records.Add(record); } Session["fields"] = records; } catch (SqlException exception) { records = null; string Error = exception.Message; } finally { if (cnn.State == ConnectionState.Open) { cnn.Close(); } } } } }
public void Delete() { var obj = new Entities.Fields { Id = 1 }; adaptadorFields.Setup(item => item.SaveChanges()).Returns(1); BusinessRules.Interfaces.IFields BusinessRulesFields = new BusinessRules.BusinessRules.Fields(adaptadorFields.Object); var objReturn = BusinessRulesFields.Delete(obj); Assert.IsTrue(objReturn != null && objReturn.Value); }
public void Create() { var obj = new Entities.Fields { Id = 200, Code = "Object", Name = "Object" }; adaptadorFields.Setup(item => item.SaveChanges()).Returns(1); BusinessRules.Interfaces.IFields BusinessRulesFields = new BusinessRules.BusinessRules.Fields(adaptadorFields.Object); var objReturn = BusinessRulesFields.Create(obj); Assert.IsTrue(objReturn != null && objReturn.Value > 0); }