public void GblParameter_Construction()
{
GblParameter parameter = new GblParameter();
Assert.AreEqual(null, parameter.Name);
Assert.AreEqual(null, parameter.Value);
}
public void GblParameter_ParseStream()
{
const string text = "Value\r\nName";
TextReader reader = new StringReader(text);
GblParameter parameter = GblParameter.ParseStream(reader);
Assert.AreEqual("Name", parameter.Name);
Assert.AreEqual("Value", parameter.Value);
}
public void GblParameter_Verify()
{
GblParameter parameter = new GblParameter();
Assert.AreEqual(false, parameter.Verify(false));
parameter = new GblParameter
{
Name = "Name",
Value = "Value"
};
Assert.AreEqual(true, parameter.Verify(false));
}
public void GblParameter_Serialization()
{
GblParameter parameter = new GblParameter();
_TestSerialization(parameter);
parameter = new GblParameter
{
Name = "Name",
Value = "Value"
};
_TestSerialization(parameter);
}
private void _TestSerialization
(
GblParameter first
)
{
byte[] bytes = first.SaveToMemory();
GblParameter second = bytes
.RestoreObjectFromMemory <GblParameter>();
Assert.AreEqual(first.Name, second.Name);
Assert.AreEqual(first.Value, second.Value);
}
public void GblParameter_ToString()
{
GblParameter parameter = new GblParameter
{
Name = "Start",
Value = "Now"
};
Assert.AreEqual
(
"Name: Start, Value: Now",
parameter.ToString()
);
}
public async Task <ICollection <GblParameter> > ListCollection(GblParameter model)
{
using (var connection = new SqlConnection(ConnectionString))
{
var result = connection.Query <
Common.GblParameter>
("PA_CON_GBL_PARAMETER",
param: new
{
P_PK_GLB_PAR_PARAMETER = model.PK_GLB_PAR_PARAMETER,
P_CREATION_USER = model.Creation_User,
P_CREATION_DATE = model.Creation_Date,
P_MODIFICATION_USER = model.Modification_User,
P_MODIFICATION_DATE = model.Modification_Date,
P_KEY_SEARCH = model.SEARCH_KEY,
P_DESCRIPTION = model.DESCRIPTION,
P_VALUE = model.VALUE,
P_CATEGORY = model.CATEGORY,
P_ACTIVE = model.ACTIVE
},
commandType: CommandType.StoredProcedure);
return(await Task.FromResult <ICollection <Common.GblParameter> >(result.ToList()));
}
}
