public List <ENT.UserAndPlantMappingSUB> GetList(string search)
{
try
{
parFields.Clear();
QueryDisctionery.SelectPart = @"SELECT Distinct UserAndPlantMapping.AspNetUserID, AspNetUsers.UserName AS DisplayName ";
QueryDisctionery.TablePart = @"FROM UserAndPlantMapping LEFT OUTER JOIN
AspNetUsers ON UserAndPlantMapping.AspNetUserID = AspNetUsers.Id";
QueryDisctionery.OrderPart = " order by AspNetUsers.UserName desc";
if (!string.IsNullOrWhiteSpace(search))
{
QueryDisctionery.ParameterPart = "where M.DisplayName like '%" + search + "%'";
}
using (SqlDataReader dr = objDBHelper.ExecuteReaderQuery(QueryDisctionery, parFields, objEntity))
{
lstEntity = COM.DBHelper.CopyDataReaderToEntity <ENT.UserAndPlantMappingSUB>(dr);
objDBHelper.Disposed();
}
}
catch (Exception)
{
throw;
}
finally
{
parFields.Clear();
}
return(lstEntity);
}
public MainDeviceMasterDAL()
{
parFields.Clear();
}
public OTPCodeMaster()
{
parFields.Clear();
}
public SubDeviceMasterDAL()
{
parFields.Clear();
}
public CityMasterDAL()
{
parFields.Clear();
}
public AdminMasterDAL()
{
parFields.Clear();
}
public CountryMasterDAL()
{
parFields.Clear();
}
public StateMasterDAL()
{
parFields.Clear();
}
public PlantMasterDAL()
{
parFields.Clear();
}
public PlantDeviceLastStatus()
{
parFields.Clear();
}
public MessageSendLog()
{
parFields.Clear();
}