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