public List <ParametersCustomModel> GetParametersCustomModel(int corporateid, int facilityid)
{
try
{
var paramters = new List <ParametersCustomModel>();
using (var parametersRep = UnitOfWork.ParametersRepository)
{
var lstParameters = parametersRep.Where(a => (a.IsActive == null || (bool)a.IsActive)).ToList();
if (corporateid != 0)
{
lstParameters =
lstParameters.Where(a => a.CorporateID == corporateid && a.FacilityID == facilityid)
.ToList();
}
using (var globalCodeBal = new GlobalCodeBal())
{
paramters.AddRange(lstParameters.Select(item => new ParametersCustomModel()
{
ParametersID = item.ParametersID,
CorporateID = item.CorporateID,
FacilityID = item.FacilityID,
FacilityNumber = item.FacilityNumber,
ParamLevel = item.ParamLevel,
ParamName = item.ParamName,
ParamDescription = item.ParamDescription,
ParamType = item.ParamType,
ParamDataType = item.ParamDataType,
IntValue1 = item.IntValue1,
IntValue2 = item.IntValue2,
NumValue1 = item.NumValue1,
NumValue2 = item.NumValue2,
DatValue1 = item.DatValue1,
DatValue2 = item.DatValue2,
StrValue1 = item.StrValue1,
StrValue2 = item.StrValue2,
BitValue = item.BitValue,
EffectiveStartDate = item.EffectiveStartDate,
EffectiveEndDate = item.EffectiveEndDate,
ModifiedBy = item.ModifiedBy,
ModifiedDate = item.ModifiedDate,
IsActive = item.IsActive,
CreatedBy = item.CreatedBy,
CreatedDate = item.CreatedDate,
SystemCode = item.SystemCode,
ParamLevelName =
globalCodeBal.GetNameByGlobalCodeId(Convert.ToInt32(item.ParamLevel)),
ParamTypeName = item.ParamType == false ? "Single Value" : "Range",
ParamDataTypeName =
globalCodeBal.GetNameByGlobalCodeId(Convert.ToInt32(item.ParamDataType)),
Value1 =
Convert.ToInt32(item.ParamDataType) == Convert.ToInt32(ParamtersDataType.Integer)
? item.IntValue1.ToString()
: Convert.ToInt32(item.ParamDataType) == Convert.ToInt32(ParamtersDataType.Numeric)
? item.NumValue1.ToString()
: Convert.ToInt32(item.ParamDataType) == Convert.ToInt32(ParamtersDataType.Date)
? item.DatValue1 != null ? item.DatValue1.ToString() : string.Empty
: Convert.ToInt32(item.ParamDataType) ==
Convert.ToInt32(ParamtersDataType.String)
? item.StrValue1.ToString()
: Convert.ToInt32(item.ParamDataType) ==
Convert.ToInt32(ParamtersDataType.Bool)
? Convert.ToBoolean(item.BitValue).ToString()
: Convert.ToInt32(item.ParamDataType) == (Convert.ToInt32(ParamtersDataType.LocalTimeType))
? (item.ExtValue1).ToString()
: Convert.ToInt32(item.ParamDataType) == (Convert.ToInt32(ParamtersDataType.DemoTimeType))
? (item.ExtValue1).ToString() : string.Empty,
Value2 =
Convert.ToBoolean(item.ParamType)
? Convert.ToInt32(item.ParamDataType) == Convert.ToInt32(ParamtersDataType.Integer)
? item.IntValue2.ToString()
: Convert.ToInt32(item.ParamDataType) ==
Convert.ToInt32(ParamtersDataType.Numeric)
? item.NumValue2.ToString()
: Convert.ToInt32(item.ParamDataType) ==
Convert.ToInt32(ParamtersDataType.Date)
? item.DatValue2 != null ? item.DatValue2.ToString() : string.Empty
: Convert.ToInt32(item.ParamDataType) ==
Convert.ToInt32(ParamtersDataType.String)
? item.StrValue2.ToString()
: Convert.ToInt32(item.ParamDataType) ==
Convert.ToInt32(ParamtersDataType.Bool)
? Convert.ToBoolean(item.BitValue).ToString()
: Convert.ToInt32(item.ParamDataType) == (Convert.ToInt32(ParamtersDataType.LocalTimeType))
? (item.ExtValue2).ToString()
: Convert.ToInt32(item.ParamDataType) == (Convert.ToInt32(ParamtersDataType.DemoTimeType))
? (item.ExtValue2).ToString()
: string.Empty
: string.Empty,
}));
return(paramters);
}
}
}
catch (Exception ex)
{
throw ex;
}
}
public ParametersCustomModel GetParametersCustomModelByID(int?ParametersId)
{
using (var ParametersRep = UnitOfWork.ParametersRepository)
{
using (var globalCodeBal = new GlobalCodeBal())
{
var parametersobj = ParametersRep.Where(x => x.ParametersID == ParametersId).FirstOrDefault();
var parmcutomModel = new ParametersCustomModel();
if (parametersobj != null)
{
parmcutomModel.ParametersID = parametersobj.ParametersID;
parmcutomModel.CorporateID = parametersobj.CorporateID;
parmcutomModel.FacilityID = parametersobj.FacilityID;
parmcutomModel.FacilityNumber = parametersobj.FacilityNumber;
parmcutomModel.ParamLevel = parametersobj.ParamLevel;
parmcutomModel.ParamName = parametersobj.ParamName;
parmcutomModel.ParamDescription = parametersobj.ParamDescription;
parmcutomModel.ParamType = parametersobj.ParamType;
parmcutomModel.ParamDataType = parametersobj.ParamDataType;
parmcutomModel.IntValue1 = parametersobj.IntValue1;
parmcutomModel.IntValue2 = parametersobj.IntValue2;
parmcutomModel.NumValue1 = parametersobj.NumValue1;
parmcutomModel.NumValue2 = parametersobj.NumValue2;
parmcutomModel.DatValue1 = parametersobj.DatValue1;
parmcutomModel.DatValue2 = parametersobj.DatValue2;
parmcutomModel.StrValue1 = parametersobj.StrValue1;
parmcutomModel.StrValue2 = parametersobj.StrValue2;
parmcutomModel.BitValue = parametersobj.BitValue;
parmcutomModel.EffectiveStartDate = parametersobj.EffectiveStartDate;
parmcutomModel.EffectiveEndDate = parametersobj.EffectiveEndDate;
parmcutomModel.ModifiedBy = parametersobj.ModifiedBy;
parmcutomModel.ModifiedDate = parametersobj.ModifiedDate;
parmcutomModel.IsActive = parametersobj.IsActive;
parmcutomModel.CreatedBy = parametersobj.CreatedBy;
parmcutomModel.CreatedDate = parametersobj.CreatedDate;
parmcutomModel.SystemCode = parametersobj.SystemCode;
parmcutomModel.ParamLevelName =
globalCodeBal.GetNameByGlobalCodeId(Convert.ToInt32(parametersobj.ParamLevel));
parmcutomModel.ParamTypeName = parametersobj.ParamType == false ? "Single Value" : "Range";
parmcutomModel.ParamDataTypeName =
globalCodeBal.GetNameByGlobalCodeId(Convert.ToInt32(parametersobj.ParamDataType));
parmcutomModel.Value1 =
Convert.ToInt32(parametersobj.ParamDataType) == Convert.ToInt32(ParamtersDataType.Integer)
? parametersobj.IntValue1.ToString()
: Convert.ToInt32(parametersobj.ParamDataType) == Convert.ToInt32(ParamtersDataType.Numeric)
? parametersobj.NumValue1.ToString()
: Convert.ToInt32(parametersobj.ParamDataType) == Convert.ToInt32(ParamtersDataType.Date)
? parametersobj.DatValue1 != null?parametersobj.DatValue1.ToString() : string.Empty
: Convert.ToInt32(parametersobj.ParamDataType) == Convert.ToInt32(ParamtersDataType.String)
? parametersobj.StrValue1.ToString()
: Convert.ToInt32(parametersobj.ParamDataType) == Convert.ToInt32(ParamtersDataType.Bool)
? Convert.ToBoolean(parametersobj.BitValue).ToString()
: Convert.ToInt32(parametersobj.ParamDataType) == (Convert.ToInt32(ParamtersDataType.LocalTimeType))
? (parametersobj.ExtValue1).ToString()
: Convert.ToInt32(parametersobj.ParamDataType) == (Convert.ToInt32(ParamtersDataType.DemoTimeType))
? (parametersobj.ExtValue1).ToString() : string.Empty;
parmcutomModel.Value2 =
Convert.ToBoolean(parametersobj.ParamType)
? Convert.ToInt32(parametersobj.ParamDataType) == Convert.ToInt32(ParamtersDataType.Integer)
? parametersobj.IntValue2.ToString()
: Convert.ToInt32(parametersobj.ParamDataType) == Convert.ToInt32(ParamtersDataType.Numeric)
? parametersobj.NumValue2.ToString()
: Convert.ToInt32(parametersobj.ParamDataType) == Convert.ToInt32(ParamtersDataType.Date)
? parametersobj.DatValue2 != null?parametersobj.DatValue2.ToString() : string.Empty
: Convert.ToInt32(parametersobj.ParamDataType) == Convert.ToInt32(ParamtersDataType.String)
? parametersobj.StrValue2.ToString()
: Convert.ToInt32(parametersobj.ParamDataType) == Convert.ToInt32(ParamtersDataType.Bool)
? Convert.ToBoolean(parametersobj.BitValue).ToString()
: Convert.ToInt32(parametersobj.ParamDataType) == (Convert.ToInt32(ParamtersDataType.LocalTimeType))
? (parametersobj.ExtValue2).ToString()
: Convert.ToInt32(parametersobj.ParamDataType) == (Convert.ToInt32(ParamtersDataType.DemoTimeType))
? (parametersobj.ExtValue2).ToString()
: string.Empty
: string.Empty;
}
return(parmcutomModel);
}
}
}