public static DataTable ReduceCountAndSaveHistory(string sPhoneNumber, string sAwardId) { DataBase dataBase = new DataBase(); string sql = "exec spLotteryProcess @CellPhoneNo = @CellPhone , @AwardID = @Award "; SqlParameter[] sqlparameter = new SqlParameter[2]; sqlparameter[0] = new SqlParameter("@CellPhone", sPhoneNumber); sqlparameter[1] = new SqlParameter("@Award", sAwardId); return dataBase.ExcuteSqlReturnDataTableTransaction(sql, sqlparameter); }