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