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); } }