public static clsInspector_RiskAssessor SelectInspector_RiskAssessorById(int? InspectorRiskAssId)
{
clsInspector_RiskAssessor objInspector_RiskAssessor = new clsInspector_RiskAssessor();
bool isnull = true;
string SpName = "usp_SelectInspector_RiskAssessor";
var objPar = new DynamicParameters();
if (String.IsNullOrEmpty(InspectorRiskAssId.ToString()))
{
throw new ArgumentException("Function parameters cannot be blank!");
}
else
{
try
{
objPar.Add("@InspectorRiskAssId", InspectorRiskAssId, dbType: DbType.Int32);
using (IDbConnection db = new SqlConnection(System.Configuration.ConfigurationManager.AppSettings["databaseConnection"]))
{
objInspector_RiskAssessor = db.Query<clsInspector_RiskAssessor>(SpName, objPar, commandType: CommandType.StoredProcedure).SingleOrDefault();
isnull = false;
}
}
catch(Exception ex)
{
ErrorHandler.ErrorLogging(ex,false);
ErrorHandler.ReadError();
}
}
if (isnull) return null;
else return objInspector_RiskAssessor;
}
public static Boolean InsertUpdateInspector_RiskAssessor(clsInspector_RiskAssessor objInspector_RiskAssessor)
{
bool isAdded = false;
string SpName = "usp_InsertUpdateInspector_RiskAssessor";
try
{
using (IDbConnection db = new SqlConnection(System.Configuration.ConfigurationManager.AppSettings["databaseConnection"]))
{
db.Execute(SpName, objInspector_RiskAssessor, commandType: CommandType.StoredProcedure);
}
isAdded = true;
}
catch (Exception ex)
{
ErrorHandler.ErrorLogging(ex, false);
ErrorHandler.ReadError();
}
return isAdded;
}
