public List <T> Find(U _Search_VM)
{
DataTable temp = null;
GenericDataTableMapper <T> _fillMachine = new GenericDataTableMapper <T>();
try
{
SqlParametersGenerator _SqlParametersGenerator = new SqlParametersGenerator();
List <SqlParameter> sqlParameters = _SqlParametersGenerator.Generate <U>(_Search_VM);
List <T> lst = new StartUp().ExecuteQuery <T>(Find_SP, sqlParameters);
if (lst == null)
{
return(new List <T>());
}
return(lst);
}
catch (Exception ex)
{
return(new List <T>());
}
finally
{
if (temp != null)
{
temp.Dispose();
}
}
}
public int InsertWithResult(T _Search_VM)
{
DataTable temp = null;
GenericDataTableMapper <T> _fillMachine = new GenericDataTableMapper <T>();
try
{
SqlParameter result = new SqlParameter("@Result", SqlDbType.Int);
result.Direction = ParameterDirection.Output;
result.Value = 0;
SqlParametersGenerator _SqlParametersGenerator = new SqlParametersGenerator();
List <SqlParameter> sqlParameters = _SqlParametersGenerator.GenerateInsertUpdateParameters <T>(_Search_VM);
sqlParameters.Add(result);
int Result = 0;
new StartUp().ExecuteNonQuery(Insert_SP, sqlParameters);
int.TryParse(result.Value.ToString(), out Result);
return(Result);
}
catch (Exception ex)
{
return(-2);
}
finally
{
if (temp != null)
{
temp.Dispose();
}
}
}
public int Delete(T _Search_VM)
{
DataTable temp = null;
int Result = 0;
GenericDataTableMapper <T> _fillMachine = new GenericDataTableMapper <T>();
try
{
SqlParametersGenerator _SqlParametersGenerator = new SqlParametersGenerator()
{
CheckForNull = false
};
List <SqlParameter> sqlParameters = _SqlParametersGenerator.Generate <T>(_Search_VM);
return(new StartUp().ExecuteNonQuery(Delete_SP, sqlParameters));
}
catch (Exception ex)
{
return(-1);
}
finally
{
if (temp != null)
{
temp.Dispose();
}
}
}
public int Update(T _Search_VM)
{
DataTable temp = null;
GenericDataTableMapper <T> _fillMachine = new GenericDataTableMapper <T>();
try
{
//SqlParameter result = new SqlParameter("@Result", SqlDbType.Int);
//result.Direction = ParameterDirection.Output;
SqlParametersGenerator _SqlParametersGenerator = new SqlParametersGenerator();
List <SqlParameter> sqlParameters = _SqlParametersGenerator.Generate <T>(_Search_VM);
// sqlParameters.Add(result);
return(new StartUp().ExecuteNonQuery(Update_SP, sqlParameters));
}
catch (Exception ex)
{
return(-2);
}
finally
{
if (temp != null)
{
temp.Dispose();
}
}
}
public List <T> Find()
{
GenericDataTableMapper <T> _fillMachine = new GenericDataTableMapper <T>();
try
{
List <T> lst = new StartUp().ExecuteQuery <T>(Find_SP);
return(lst);
}
catch (Exception ex)
{
return(null);
}
}
public List <T> FindList(U _RadiologistSearch_VM)
{
GenericDataTableMapper <T> _fillMachine = new GenericDataTableMapper <T>();
try
{
SqlParametersGenerator _SqlParametersGenerator = new SqlParametersGenerator();
List <SqlParameter> sqlParameters = _SqlParametersGenerator.Generate <U>(_RadiologistSearch_VM);
List <T> lst = new StartUp().ExecuteQuery <T>(Find_SP, sqlParameters);
return(lst);
}
catch (Exception ex)
{
return(null);
}
finally
{
}
}
public int Insert(T _Search_VM)
{
DataTable temp = null;
GenericDataTableMapper <T> _fillMachine = new GenericDataTableMapper <T>();
try
{
SqlParametersGenerator _SqlParametersGenerator = new SqlParametersGenerator();
List <SqlParameter> sqlParameters = _SqlParametersGenerator.GenerateInsertUpdateParameters <T>(_Search_VM);
return(new StartUp().ExecuteNonQuery(Insert_SP, sqlParameters));
}
catch (Exception ex)
{
return(-2);
}
finally
{
if (temp != null)
{
temp.Dispose();
}
}
}
