internal List <Picklist> GetAll(string tenantCode, PicklistQuery query)
{
var lstPicklists = new List <Picklist>();
try
{
var cmd = CreateProcedureCommand("dbo.Picklist_GetAll");
cmd.AppendXSmallText("@strTenantCode", tenantCode);
cmd.AppendInt("@intPageNumber", query.PagingParameters.PageNumber);
cmd.AppendInt("@intPageSize", query.PagingParameters.PageSize);
if (!string.IsNullOrEmpty(query.SearchText))
{
cmd.AppendSmallText("@strSearchText", query.SearchText);
}
cmd.AppendBit("@bitIsdeleted", query.IsDeleted);
using (SqlDataReader reader = ExecuteCommandAndReturnReader(cmd))
{
while (reader.Read())
{
var info = new Picklist()
{
Id = (short)(reader.IsDBNull(0) ? 0 : reader.GetInt16(0)),
Name = reader.IsDBNull(1) ? string.Empty : reader.GetString(1),
IsStandard = !reader.IsDBNull(2) && reader.GetBoolean(2),
EntityId = (short)(reader.IsDBNull(3) ? 0 : reader.GetInt16(3)),
FixedValueList = !reader.IsDBNull(4) && reader.GetBoolean(4),
CustomizeValue = !reader.IsDBNull(5) && reader.GetBoolean(5),
IsKeyValueType = !reader.IsDBNull(6) && reader.GetBoolean(6),
Active = !reader.IsDBNull(7) && reader.GetBoolean(7),
IsDeleteted = !reader.IsDBNull(8) && reader.GetBoolean(8),
UpdatedBy = reader.IsDBNull(9) ? Guid.Empty : reader.GetGuid(9),
UpdatedDate = reader.IsDBNull(10) ? DateTime.MinValue : reader.GetDateTime(10)
};
lstPicklists.Add(info);
}
}
}
catch (SqlException e)
{
throw ReportAndTranslateException(e, "Picklist::GetAll");
}
return(lstPicklists);
}
internal List <Values> GetAllPicklistValues(string tenantCode, short picklistId, PicklistQuery query)
{
var pickListValues = new List <Values>();
try
{
var cmd = CreateProcedureCommand("dbo.PicklistValue_GetAll");
cmd.AppendXSmallText("@strTenantCode", tenantCode);
cmd.AppendInt("@intPageNumber", query.PagingParameters.PageNumber);
cmd.AppendInt("@intPageSize", query.PagingParameters.PageSize);
if (!string.IsNullOrEmpty(query.SearchText))
{
cmd.AppendSmallText("@strSearchText", query.SearchText);
}
cmd.AppendBit("@bitIsdeleted", query.IsDeleted);
cmd.AppendSmallInt("@intPicklistId", picklistId);
using (SqlDataReader reader = ExecuteCommandAndReturnReader(cmd))
{
while (reader.Read())
{
var info = new Values()
{
Id = reader.IsDBNull(0) ? Guid.Empty : reader.GetGuid(0),
PicklistId = (short)(reader.IsDBNull(1) ? 0 : reader.GetInt16(1)),
Key = reader.IsDBNull(2) ? string.Empty : reader.GetString(2),
Text = reader.IsDBNull(3) ? string.Empty : reader.GetString(3),
Active = !reader.IsDBNull(4) && reader.GetBoolean(4),
IsDeleteted = !reader.IsDBNull(5) && reader.GetBoolean(5),
Flagged = !reader.IsDBNull(6) && reader.GetBoolean(6),
UpdatedBy = reader.IsDBNull(7) ? Guid.Empty : reader.GetGuid(7),
UpdatedDate = reader.IsDBNull(8) ? DateTime.MinValue : reader.GetDateTime(8)
};
pickListValues.Add(info);
}
}
}
catch (SqlException e)
{
throw ReportAndTranslateException(e, "PicklistValue::GetAll");
}
return(pickListValues);
}
