public async Task <int> ApprovedSIVCount()
{
SqlParameter[] sqlParams = { };
try
{
var response = await SqlHelperExtension.ExecuteScalar(_connectionString, SqlConstant.ProcGetApprovedSIVCount, System.Data.CommandType.StoredProcedure, sqlParams);
return(Convert.ToInt32(response));
}
catch (Exception ex)
{
return(-1);
}
}
public async Task <int> IsExistsItemNumber(string itemnumber)
{
SqlParameter[] sqlparams =
{
new SqlParameter("@in_itemNumber", itemnumber ?? string.Empty)
};
try {
var response = await SqlHelperExtension.ExecuteScalar(_connectionString, "usp_CheckProductItemExists", System.Data.CommandType.StoredProcedure, sqlparams);
return(Convert.ToInt32(response));
}
catch (Exception ex)
{
return(-1);
}
}