internal bool GetParameterConfigurations(TargetVsAchievementBO targetVsAchievementBO) { DataAccessSqlHelper sqlHelper = new DataAccessSqlHelper(targetVsAchievementBO.ConString); SqlCommand command = sqlHelper.CreateCommand(CommandType.StoredProcedure); command.CommandText = "uspUploadTargetVsAchievement"; sqlHelper.AddParameter(command, "@Mode", "P", ParameterDirection.Input); return((bool)sqlHelper.ExecuteScalar(command)); }
internal DataSet GetUploadTargetVsAchievementShopWise(TargetVsAchievementBO targetVsAchievementBO) { DataAccessSqlHelper sqlHelper = new DataAccessSqlHelper(targetVsAchievementBO.ConString); SqlCommand command = sqlHelper.CreateCommand(CommandType.StoredProcedure); command.CommandText = "uspUploadTargetVsAchievement"; sqlHelper.AddParameter(command, "@Mode", targetVsAchievementBO.Mode, ParameterDirection.Input); sqlHelper.AddParameter(command, "@UserId", targetVsAchievementBO.UserId, ParameterDirection.Input); sqlHelper.AddParameter(command, "@ShopId", targetVsAchievementBO.ShopId, ParameterDirection.Input); return(sqlHelper.ExecuteDataSet(command)); }